Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Quiz

## Instruction

That's right! Now, let's see if you can make the database generate numbers for you.

## Exercise

Our small healthcare unit needs another table: medicine. It should have the following columns:

• id which is the primary key generated automatically and has the following values: 10, 20, 30, 40, ... (Do not use sequences.)
• market_name - up to 64 characters,
• active_substance - up to 128 characters,
• volume a float number,
• quantity - an integer number,
• on_prescription - a yes/no field.

### Stuck? Here's a hint!

It might be worth taking a look at Part 5 if you can't remember how to generate numbers automatically.