CREATE TABLE BOOK_AUTHOR(Book_Id int, Author_Id int,primary key(Book_Id,Author_Id),foreign key(Book_Id) references BOOK(Book_Id),foreign key(Author_Id) references AUTHOR(Author_Id));
CREATE TABLE BOOK_ISSUE(Issue_Id int not null , Date_Of_Issue date , Book_Id int not null, Member_Id int not null, Expected_Date_Of_Return date, Issue_Status varchar(20),foreign key(Book_Id) references BOOK(Book_Id), foreign key(Member_id) references MEMBER(Member_id), primary key(Issue_Id));
CREATE TABLE BOOK_RETURN(Issue_Id int, Actual_Date_Of_Return date, LateDays varchar(38), LateFee int,foreign key(Issue_id) references BOOK_ISSUE(Issue_id),primary key(Issue_id));
CREATE TABLE  LATE_FEE_RULE(FromDays int, ToDays int, Amount int,Book_Id int,Member_Id int,primary key(Book_Id,Member_Id),foreign key(Book_Id) references BOOK(Book_id),foreign key(Member_Id) references MEMBER(Member_Id));