Q $$ you are hired to create a new DB for a clothing store to manage their inventory. The store already has a DB$,$ but it became hard to maintain and generated many anomalies. You want to create a new design for the DB$.$ They have given you part of the DB in an SQL script file to generate your new version. You need to:

$1-$ Design a normalized $(3$rd normal form$)$ DB to hold similar information. Draw an ER and an RM for the new design $(10$ points$)$

$2-$ Write the SQL queries to create the new tables. You can create the new tables in the same DB$,$ then later, they can delete the old table $($don$$t delete the old table$)$

$3-$ Make sure you have all PK and FK$,$ with suitable data types for all columns

$4-$ Write queries to migrate $($copy$)$ the data from the old table to your new tables. The data migration should be fully automated

$5-$ Create a view to show a list of products with an added column $($productProfit$)=$ price $$ average item cost

$6-$ Export the new database in a new sql file that can be run to generate the DB with all data