draw the ERD: CREATE TABLE book$\_$author $($

book$\_$id INT,

author$\_$id INT,

CONSTRAINT fk$\_$bookauthor$\_$book FOREIGN KEY $($book$\_$id$)$ REFERENCES book$($id$),$

CONSTRAINT fk$\_$bookauthor$\_$author FOREIGN KEY $($author$\_$id$)$ REFERENCES author$($id$)$

$)$;

$$

CREATE TABLE member$\_$status $($

id INT,

status$\_$value VARCHAR$(50),$

CONSTRAINT pk$\_$memberstatus PRIMARY KEY $($id$)$

$)$;

CREATE TABLE fine$\_$payment $($

id INT,

member$\_$id INT,

payment$\_$date DATE,

payment$\_$amount INT,

CONSTRAINT pk$\_$fine$\_$payment PRIMARY KEY $($id$),$

CONSTRAINT fk$\_$finepay$\_$member FOREIGN KEY $($member$\_$id$)$ REFERENCES member$($id$)$

$)$;

CREATE TABLE loan $($

id INT,

book$\_$id INT,

member$\_$id INT,

loan$\_$date DATE,

returned$\_$date DATE,

CONSTRAINT pk$\_$loan PRIMARY KEY $($id$),$

CONSTRAINT fk$\_$loan$\_$book FOREIGN KEY $($book$\_$id$)$ REFERENCES book$($id$),$

CONSTRAINT fk$\_$loan$\_$member FOREIGN KEY $($member$\_$id$)$ REFERENCES member$($id$)$

$)$;

CREATE TABLE fine $($

id INT,

book$\_$id INT,

loan$\_$id INT,

fine$\_$date DATE,

fine$\_$amount INT,

CONSTRAINT pk$\_$fine PRIMARY KEY $($id$),$

CONSTRAINT fk$\_$fine$\_$book FOREIGN KEY $($book$\_$id$)$ REFERENCES book$($id$),$

CONSTRAINT fk$\_$fine$\_$loan FOREIGN KEY $($loan$\_$id$)$ REFERENCES loan$($id$)$

$)$;

CREATE DATABASE IF NOT EXISTS LibraryDB;

USE LibraryDB;

$$

$$

CREATE TABLE Publishers $($

$$ PublisherID INT AUTO$\_$INCREMENT PRIMARY KEY,

$$ PublisherName VARCHAR$(100)$ NOT NULL UNIQUE,

$$ OfficeAddress VARCHAR$(150),$

$$ ContactNumber VARCHAR$(15),$

$$ EmailAddress VARCHAR$(50)$ UNIQUE

$)$;

$$

CREATE TABLE Reservations $($

$$ TransactionID INT AUTO$\_$INCREMENT PRIMARY KEY,

$$ MemberID INT NOT NULL,

$$ BookID VARCHAR$(30)$ NOT NULL,

$$ DateReserved DATE,

$$ DateReturned DATE,

$$ CurrentStatus ENUM$(\text{'}$Reserved$\text{'},$ 'Returned'$)$ NOT NULL,

$$ FOREIGN KEY $($MemberID$)$ REFERENCES LibraryMembers$($MemberID$),$

$$ FOREIGN KEY $($BookID$)$ REFERENCES Books$($BookID$)$

$)$;

$$

CREATE TABLE LibraryReports $($

$$ ReportID INT AUTO$\_$INCREMENT PRIMARY KEY,

$$ DateCreated DATE NOT NULL,

$$ ReportCategory ENUM$(\text{'}$Monthly$\text{'},$ 'Yearly', 'Custom'$)$ NOT NULL,

$$ ReportDetails TEXT,

$$ GeneratedBy INT,

$$ FOREIGN KEY $($GeneratedBy$)$ REFERENCES StaffMembers$($StaffID$)$

$)$;

$$

CREATE TABLE Genres $($

$$ GenreID INT AUTO$\_$INCREMENT PRIMARY KEY,

$$ GenreName VARCHAR$(50)$ NOT NULL UNIQUE,

$$ GenreDescription TEXT

$)$;

$$

CREATE TABLE BookStatuses $($

$$ BookID VARCHAR$(30)$ PRIMARY KEY,

$$ BookCondition ENUM$(\text{'}$Available$\text{'},$ 'Issued', 'Reserved', 'Damaged', 'Lost'$)$ NOT NULL,

$$ LastUpdated TIMESTAMP DEFAULT CURRENT$\_$TIMESTAMP,

$$ FOREIGN KEY $($BookID$)$ REFERENCES Books$($BookID$)$

$)$;

$$

CREATE TABLE BOOKS $($

$$ BOOK$\_$ID VARCHAR$(30)$ PRIMARY KEY,

$$ GENRE VARCHAR$(50)$ NOT NULL,

$$ NAME VARCHAR$(50)$ NOT NULL,

$$ AUTHOR VARCHAR$(50)$ NOT NULL,

$$ COPIES INT NOT NULL

$)$;

$$

CREATE TABLE ADMIN $($

$$ USER$\_$ID VARCHAR$(30)$ PRIMARY KEY,

$$ NAME VARCHAR$(30),$

$$ PASSWORD VARCHAR$(50),$

$$ CONTACT VARCHAR$(10)$

$)$;

$$

CREATE TABLE MEMBERS $($

$$ MEMBER$\_$ID INT AUTO$\_$INCREMENT PRIMARY KEY,

$$ NAME VARCHAR$(50)$ NOT NULL,

$$ CONTACT VARCHAR$(15)$ NOT NULL

$)$;

$$

$$

$$

CREATE TABLE STAFF $($

$$ STAFF$\_$ID INT AUTO$\_$INCREMENT PRIMARY KEY,

$$ NAME VARCHAR$(50)$ NOT NULL,

$$ ROLE VARCHAR$(50),$

$$ CONTACT VARCHAR$(10)$

$)$;

$$

CREATE TABLE Authors $($

$$ AuthorID INT AUTO$\_$INCREMENT PRIMARY KEY,

$$ Name VARCHAR$(50)$ NOT NULL,

$$ Nationality VARCHAR$(50)$

$)$;

$$

$$