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