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
);

Console

Code editor

Result

TableConsole