Design and implement your DB project $($A Library system, or other database systems$)$

There are two parts of your project:

$1.$ Database Design

Design ER mode of the Library database with Tables $($attributes and primary$/$foreign keys $)$ using Workbench.

$2.$ Create the Database called Library using "Forward Engineer" in Workbench. Once the Library DB is created, You should insert some sample records for testing.The database manipulation should include INSERT, UPDATE and DELETE operations For this part, you will create a $.$SQL script file so that It can be reproduced from MySQL prompt.

Submit your project before Due Date including:

a$.$ ER mode diagram designed and generated using Workbench

b$.$ Create CIS$395\_$Libary database using forward engineering. Write Insert, update and delete script to manipulate the data in CIS$395$

c$.$ Generate the CIS$395.$SQL script fie so it can be reproduced in any MYSQL server