Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q you are hired to create a new DB for a clothing store to manage their inventory. The store already has a DB , but
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:
Design a normalized rd normal form DB to hold similar information. Draw an ER and an RM for the new design points
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 dont delete the old table
Make sure you have all PK and FK with suitable data types for all columns
Write queries to migrate copy the data from the old table to your new tables. The data migration should be fully automated
Create a view to show a list of products with an added column productProfit price average item cost
Export the new database in a new sql file that can be run to generate the DB with all data
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started