bookStore.sdl Example Schema

(Click here to download bookStore.sdl source file.)

create table author(    last_name   char(13) primary key,    full_name   char(35),    gender      char(1),    yr_born     smallint,    yr_died     smallint,    short_bio   varchar(216),);create table book(    bookid      char(14) primary key,    last_name   char(13) references author,    title       varchar(105) key,    descr       char(61),    publisher   varchar(136),    publ_year   smallint key,    date_acqd   date,    price       decimal(10,2),    cost        decimal(10,2));