Program 1 ( Create And Insert)

Creation of Tables

CREATE TABLE PUBLISHER(Name varchar(10)PRIMARY KEY,Address varchar(20),Phone int);

CREATE TABLE BOOK(Book_id int PRIMARY KEY,Title varchar(40),Publisher_name varchar(10),Pub_year int);

CREATE TABLE BOOK_AUTHORS(Book_id int REFERENCES BOOK(book_id) ON DELETE CASCADE,Author_name varchar(20), PRIMARY KEY(Book_id,Author_name));

CREATE TABLE LIBRARY_BRANCH(Branch_id int PRIMARY KEY,Branch_name varchar(20),Address varchar(20));

CREATE TABLE BOOK_COPIES(Book_id int REFERENCESBOOK(Book_id)ON DELETE CASCADE, Branch_id int REFERENCESLIBRARY_BRANCH(Branch_id),No_of_copies int,PRIMARY KEY(Book_id,Branch_id));

CREATE TABLE BOOK_LENDING(Book_id int REFERENCESBOOK(Book_id)ON DELETE CASCADE, Branch_id  int REFERENCES LIBRARY_BRANCH(Branch_id),Card_no int, Date_out date,Due_date date,PRIMARY KEY(Book_id,Branch_id,Card_no));

Insertion of rows to the table

INSERT INTO PUBLISHER VALUES('&Name','&Address','&Phone');

INSERT INTO BOOK VALUES('&Book_id','&Title','&Publisher_name','&Pub_year');

INSERT INTO BOOK_AUTHORS VALUES('&Book_id','&Author_name');

INSERT INTO LIBRARY_BRANCH VALUES('&Branch_id','&Branch_name','&Address');

INSERT INTO BOOK_COPIES VALUES('&Book_id','&Branch_id','&No_of_copies');

INSERT INTO BOOK_LENDING VALUES ('&Book_id','&Branch_id','&Card_no','&Date_out','&Due_date');