CREATE TABLE MEMBER(Member_Id int NOT NULL, M_Name varchar(20), Branch_Code int, Roll_Number int, Phone_Number int, Email_Id varchar(20), Date_of_Join date, Status varchar(20), primary key (Member_id)); 
CREATE TABLE LANGUAGE(Language_id int, L_Name varchar(20),primary key(language_id));
CREATE TABLE AUTHOR(Author_Id int, A_Name varchar(20), Email varchar(20), Phone_Number int, Status varchar(20),primary key(Author_Id));
CREATE TABLE PUBLISHER(Publisher_id int , P_Name varchar(20), Address varchar(40),primary key (Publisher_id));
CREATE TABLE BOOK (Book_Id int not null, Title varchar(20), Language_id int not null, MRP int, Publisher_Id int not null, Published_Date date, Volume int , Status varchar(20),foreign key(Language_id) references LANGUAGE(Language_id),foreign key(Publisher_Id) references PUBLISHER(Publisher_id), primary key(Book_id)) ;
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));

insert into MEMBER(Member_Id, M_Name, Branch_Code, Roll_Number, Phone_Number, Email_Id, Date_of_Join,Status) values(1,'Raju',001,52,9876342161,'raju@gmail.com','17/03/2023','ACTIVE'); 
insert into MEMBER(Member_Id, M_Name, Branch_Code, Roll_Number, Phone_Number, Email_Id, Date_of_Join,Status) values(2,'Arjun',006,34,987356782,'arjun22@gmail.com','16/04/2023','ACTIVE');