This is a simple list table of a company trying to keep track ofparts that they sell and orders that came in purchasing those parts(in other words, not a database but a flat one table file). Youwill design a database for this company so that they won’t berelying on a simple 1 table list system to keep track of theirdata. Looking at the table below, produce the 3NF of thedata.
OrderNum | OrderDate | PartNum | Description | NumOrdered | QuotedPrice |
21608 | 10/20/2010 | AT94 | Iron | 11 | $21.95 |
21610 | 10/20/2010 | DR93 | Gas Range | 1 | $495.00 |
21610 | 10/20/2010 | DW11 | Washer | 1 | $399.99 |
21613 | 10/21/2010 | KL62 | Dryer | 4 | $329.95 |
21614 | 10/21/2010 | KT03 | Dishwasher | 2 | $595.00 |
21617 | 10/23/2010 | BV06 | Home Gym | 2 | $794.95 |
21617 | 10/23/2010 | CD52 | Microwave Oven | 4 | $150.00 |
21619 | 10/23/2010 | DR93 | Gas Range | 1 | $495.00 |
21523 | 10/23/2010 | KV29 | Treadmill | 2 | |
Create the database in an actual databaseapplication (i.e Microsoft Access, MySQL or Oracle, etc.).You must use SQL commands to create the tables in the database (i.eCreate Table command). Submit the SQL commands with thecompleted database as part of the assignment. The tablesshould be populated with records from the scenario you chose.
