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

SQL Constraints

Introduction
Defining columns with UNIQUE
Adding and removing UNIQUE constraints
Summary
14. Quiz

Instruction

There's just one question in this quiz. And here it comes!

Exercise

An electronics store wants us to create a table for storing information about the notebook computers they offer. They need the following columns:

  1. id – An integer and the primary key.
  2. manufacturer – Up to 64 characters.
  3. model – Up to 64 characters.
  4. price – Up to 9999.99. (Note the two digits after the decimal point.)
  5. customer_rank – An integer.

The customer_rank column and the manufacturer – model combination must be unique.

Create a table named notebook based on the above description.