PLZ help with the following: 1. Populate every relation with “sufficient” representative rows (at least 4 for each table). Create table book (title varchar(80) not null, year INT not null , num INT primary key , subject Varchar(50) null);    Create table client (CID int primary key,fname varchar(20), lname varchar(20), type varchar(6), constraint checkclient check (type in ('Faculty', 'Student')));     Create table author (year INT, ID INT primary key, fname varchar(50) not null,lname varchar(50)); Create table BookAuthors(booknum int, authorID int, primary key (booknum, authorID),  constraint fk_book foreign key (booknum) references book(num), constraint fk_author foreign key (authorid) references author(id));   create table bookcheckouts( booknum int, clientID int, checkoutdate date, expectedDuedate date not null, returnedate date, primary key (booknum, clientID, checkoutDate), constraint book_checks foreign key(booknum) references book(num), constraint book_clients foreign key (clientid) references client(CID));

PLZ help with the following:

1. Populate every relation with “sufficient” representative rows (at least 4 for each table).

Create table book (title varchar(80) not null, year INT not null , num INT primary key , subject Varchar(50) null); 

Create table client (CID int primary key,fname varchar(20), lname varchar(20), type varchar(6), constraint checkclient check (type in ('Faculty', 'Student')));

Create table author (year INT, ID INT primary key, fname varchar(50) not null,lname varchar(50));

Create table BookAuthors(booknum int, authorID int, primary key (booknum, authorID), 
constraint fk_book foreign key (booknum) references book(num),
constraint fk_author foreign key (authorid) references author(id));

create table bookcheckouts( booknum int, clientID int, checkoutdate date, expectedDuedate date not null, returnedate date, primary key (booknum, clientID, checkoutDate),
constraint book_checks foreign key(booknum) references book(num),
constraint book_clients foreign key (clientid) references client(CID));