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
Final Quiz
2. Question 1
Summary

Instruction

Let's start with the first exercise!

Exercise

Create a table called person based on the description below:

Each person has:

  • An id (expressed as an integer) which is the table's primary key.
  • An ssn (social security number) of precisely 11 characters; this number is unique for each person and should never be NULL.
  • A first_name (up to 255 characters) and a last_name (up to 255 characters) – both of these fields must have a defined value.
  • A salary that must always be greater than 0. The salary can be up to 10 digits long, of which 2 digits are found behind the decimal point. If no salary is specified, then 5000.00 is inserted by default.

Some people also have a middle_name of up to 255 characters, but this isn't mandatory.