Untitled

CREATE TABLE Aulhot (Author-id int (10) primary key, Name varchar (20), Email varchar (25), Ph_no. int (10), Status varchar (1o));

CREATE TABLE Member (Member id int (10) primary key Branch code int (10), Roll ho int (10), Ph no int (10), Email varchar (25) Name varchar (20), Date of join date, Status varchar (10)),

CREATE TABLE Book-Author (Book id int (10), Author-id int (10), primary key (Book id, Author id), FOREIGN KEY (Book-id) REFERENCES Book (Book-id), FOREIGN KEY (Aulhor id) REFERENCES Author (Author id));

CREATE TABLE Book-Issue (Issue-id int (10) primary key, Date-of- issue date, Book id int (10), Member-id int (10), FOREIGN KEY (Book-id) REFERENCES Bonk (Book id), FOREIGN KEY (Member id) REFERENCES Member (Member id), Expected date of return date, Staty varchay (10));