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

Introduction
UNIQUE
NOT NULL
CHECK
DEFAULT
Summary
34. Revision #2

Instruction

Wow! That was perfect. Are you ready for the next challenge?

Exercise

This time, use the ERD diagram below to build the correct table:

The book table

Remember to set each column as NULLable or not!

Stuck? Here's a hint!

Type

CREATE TABLE book (
  isbn char(10)  PRIMARY KEY,
  title varchar(128)  NOT NULL,
  author varchar(64)  NOT NULL,
  publishing_house varchar(64)  NOT NULL,
  genre varchar(64)  NULL,
  description text NULL
);