bookStore.sdl Example Schema

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

create table author(
    LastName    char(15) primary key,
    FullName    char(35),
    YearBorn    smallint,
    YearDied    smallint,
    Bio         char(250),
);

create table book(
    BookISBN     char(13) primary key,
    LastName     char(15) references author,
    Title        char(100) key,
    Description  char(60),
    Publisher    char(100),
    PurchaseDate date,
    Price        decimal(10,2)
);