This really can't, can't work well
Computer exercises for the first two questions

CodePudding user response:

The create table book (book_id nchar (6) primary key,... )

The create table author (book_id nchar (6),... )

The alter table author with check the add foreign key (book_id) references book (book_id)