Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Tables in SQL

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.