Can you write a report for this library management database? please include these:

1. INTRODUCTION

2. ANALYSIS

3. DATABASE DESIGN

4. PROGRAMMING

5. EXAMPLES

6. RESULTS and CONCLUSION

SQL CODE TO CREATE TABLES-

/* Create tables for the library management database

SAMPLE DATABASE CREATED FOR CODE WORKING */ Create database lib; use lib ;

CREATE TABLE reservation_status ( id INT, status_value VARCHAR(50), CONSTRAINT pk_res_status PRIMARY KEY (id) );

CREATE TABLE category ( id INT, category_name VARCHAR(100), CONSTRAINT pk_category PRIMARY KEY (id) );

CREATE TABLE book ( id INT, title VARCHAR(500), category_id INT, publication_date DATE, copies_owned INT, CONSTRAINT pk_book PRIMARY KEY (id), CONSTRAINT fk_book_category FOREIGN KEY (category_id) REFERENCES category(id) );

CREATE TABLE author ( id INT, first_name VARCHAR(300), last_name VARCHAR(300), CONSTRAINT pk_author PRIMARY KEY (id) );

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 member ( id INT, first_name VARCHAR(300), last_name VARCHAR(300), joined_date DATE, active_status_id INT, CONSTRAINT pk_member PRIMARY KEY (id), CONSTRAINT fk_member_status FOREIGN KEY (active_status_id) REFERENCES member_status(id) );

CREATE TABLE reservation ( id INT, book_id INT, member_id INT, reservation_date DATE, reservation_status_id INT, CONSTRAINT pk_reservation PRIMARY KEY (id), CONSTRAINT fk_res_book FOREIGN KEY (book_id) REFERENCES book(id), CONSTRAINT fk_res_member FOREIGN KEY (member_id) REFERENCES member(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) );

reservation_status PK id status_value PK category id category_name reservation PK id FK book id FK member_id reservation_date FK reservation_status_id fine payment id member_id payment_date payment amount PK FK PK FK book id title category_id publication date copies owned member id PK first_name last_name joined_date FK active_status_id FK FK book_author book id author_id PK : FK FK PK FK FK loan id book_id member id loan_date returned_date fine id member_id loan_id fine_date fine_amount member_status PK id status value +PK author id first_name last name