Database principles create three sql scripts and three E-R diagrams

1. The Henry Books Store Considering the normalized data tables created in assignment#5b do the following tasks. a. Using MySQL Workbench, 1) create a database schema named henry bookstore Inf. 2) Make a table named 'inventory' in the database for the 1 NF table built for the assignment#5b 1.a 3) Make sure to properly set a primary key for the inventory table. 4) Then insert the data given in assignment#5b into the newly created table using SQL insert statements. 5) Then export and submit the database as a script (henry bookstore Inf.sal) and an E-R diagram (henry bookstore Infpng) b. Using MySQL Workbench, 1) create a database schema named henry bookstore 2nf. 2) Make three tables named 'branch', book', and 'inventory' in the database for the 2 NF tables built for the assignment#5blb. 3) Make sure to properly set a primary key for the three tables and two foreign keys in the inventory' table. 4) Then insert the data given in assignment#5b into the newly created tables using SQL insert statements. 5) Then export and submit the database as a script (henry bookstore 2nf.sal) and an E-R diagram (henry bookstore 2nf.png). c. Using MySQL Workbench, 1) create a database schema named henry bookstore 3nf. 2) Then make four tables named branch', 'book', 'inventory', and "book_type' in the database for the 3 NF tables constructed for the assignment#5b 1.c.3) Make sure that you properly set a primary key for the four tables, two foreign keys in the inventory' table, and a foreigrn key in the book table. 4) Then insert the data given in assignment#5b into the newly created tables using SQL insert statements. 5) Then export and submit the database as a script (henry bookstore 3nf.sal) and an E-R diagram (henry bookstore 3nf png) So you will need to submit three sal scripts and three E-R diagrams