i wand draw erd for tihse system

Entities:

$1.$ Book

$2.$ Author

$3.$ Publisher

$4.$ Genre

$5.$ Customer

$6.$ Order

Relationships:

$1.$ An Author can write multiple Books $($One$-$to$-$Many$)$

$2.$ A Book is written by one Author $($Many$-$to$-$One$)$

$3.$ A Book is published by one Publisher $($Many$-$to$-$One$)$

$4.$ A Publisher can publish multiple Books $($One$-$to$-$Many$)$

$5.$ A Book can belong to multiple Genres $($Many$-$to$-$Many$)$

$6.$ A Genre can have multiple Books $($Many$-$to$-$Many$)$

$7.$ A Customer can place multiple Orders $($One$-$to$-$Many$)$

$8.$ An Order can contain multiple Books $($One$-$to$-$Many$)$

$9.$ A Book can be included in multiple Orders $($Many$-$to$-$Many$)$

$10.$ An Order is placed by one Customer $($Many$-$to$-$One$)$

Logical Design: SQL Coding

$--$ Book table

CREATE TABLE Book $($

book$\_$id INT PRIMARY KEY,

title VARCHAR$(255),$

isbn VARCHAR$(20),$

publisher$\_$id INT,

FOREIGN KEY $($publisher$\_$id$)$ REFERENCES Publisher$($publisher$\_$id$)$

$)$;

$--$ Author table

CREATE TABLE Author $($

author$\_$id INT PRIMARY KEY,

name VARCHAR$(100)$

$)$;

$--$ Publisher table

CREATE TABLE Publisher $($

publisher$\_$id INT PRIMARY KEY,

name VARCHAR$(100)$

$)$;

$--$ Genre table

CREATE TABLE Genre $($

genre$\_$id INT PRIMARY KEY,

name VARCHAR$(100)$

$)$;

$--$ Customer table

CREATE TABLE Customer $($

customer$\_$id INT PRIMARY KEY,

name VARCHAR$(100),$

email VARCHAR$(255),$

address VARCHAR$(255)$

$)$;

$--$ Order table

CREATE TABLE Order $($

order$\_$id INT PRIMARY KEY,

customer$\_$id INT,

order$\_$date TIMESTAMP,

FOREIGN KEY $($customer$\_$id$)$ REFERENCES Customer$($customer$\_$id$)$

$)$;

$--$ Book$\_$Genre table for many$-$to$-$many relationship between Book and Genre

CREATE TABLE Book$\_$Genre $($

book$\_$id INT,

genre$\_$id INT,

PRIMARY KEY $($book$\_$id$,$ genre$\_$id$),$

FOREIGN KEY $($book$\_$id$)$ REFERENCES Book$($book$\_$id$),$

FOREIGN KEY $($genre$\_$id$)$ REFERENCES Genre$($genre$\_$id$)$

$)$;

$--$ Order$\_$Item table to represent the many$-$to$-$many relationship between Order and Book

CREATE TABLE Order$\_$Item $($

order$\_$id INT,

book$\_$id INT,

quantity INT,

PRIMARY KEY $($order$\_$id$,$ book$\_$id$),$

FOREIGN KEY $($order$\_$id$)$ REFERENCES Order$($order$\_$id$),$

FOREIGN KEY $($book$\_$id$)$ REFERENCES Book$($book$\_$id$)$

$)$;

$--$ Author$\_$Book table to represent the many$-$to$-$many relationship between Author and Book

CREATE TABLE Author$\_$Book $($

author$\_$id INT,

book$\_$id INT,

PRIMARY KEY $($author$\_$id$,$ book$\_$id$),$

FOREIGN KEY $($author$\_$id$)$ REFERENCES Author$($author$\_$id$),$

FOREIGN KEY $($book$\_$id$)$ REFERENCES Book$($book$\_$id$)$

$)$;

The Book table stores information about books, including their title, ISBN, and the publisher they belong to$.$

The Author table stores information about authors, including their name.

The Publisher table stores information about publishers, including their name.

The Genre table stores information about book genres, including their name.

The Customer table stores information about customers, including their name, email, and address.

The Order table stores information about orders placed by customers, including the order date.

The Book$\_$Genre table represents the many$-$to$-$many relationship between books and genres.

The Order$\_$Item table represents the many$-$to$-$many relationship between orders and books.

The Author$\_$Book table represents the many$-$to$-$many relationship between authors and books.