This is a simple list table of a company trying to keep track of parts that...

60.1K

Verified Solution

Question

Programming

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.

Answer & Explanation Solved by verified expert

4.1 Ratings (541 Votes)

Consider the relation givenFIrst NormalForm 1NF This relation is in the first normal form because all columnsare atomic in natureeach column contains single value and each row has same number of olumnsSecond NormalForm 2NF This table contains partial dependency that needs to remove bymaking new table likePart Part table store part details likePartNum DescriptionOrders This table stores order detailslikeIron orderNum and OrderDateBelow are tables in 2NF1Table NamePartSchema Part PartNum Description FD PartNumDescriptionBelow is the table dataPartNumDescriptionAT94IronDR93Gas RangeDW11WasherKL62DryerKT03DishwasherBV06Home GymCD52Microwave See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

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