create table author
(
    id int,
    fname       varchar(20),
    lname       varchar(20)
);
insert into author values (1, 'Victor', 'Hugo');
insert into author values (2, 'Alexandre', 'Dumas');

create table book
(
    id     int,
    title  varchar(100),
    author int
);
insert into book
values (1, 'Les Miserables', 1);
insert into book
values (2, 'The Count Of Monte Cristo', 2);