Based on the following \"User View\", normalize up to 3NF. UNF has been complete

Question

Based on the following "User View", normalize up to 3NF. UNF has been completed for you Create a conceptual diagram based on the 3NF view of task 3 4. 5. Timberbridge Manufacturing Supplier Order Detail Report Supp Supp Number Name Part Number Desc SC12 BT04 BT98 EPX1 SC34 STP12 1/2" Frn. Stp TC3 SC12 Order Order Part Qty Quoted Date Ordered Price 1/2" Screw 1"Butt Jnt 2"Butt Jnt Butt Epoxy 3/4" Screw 12489 9/2/2016 12491 9/2/2016 124 Fastnal1 89.95 440 250 399.99 19.96 2500 279.96 3200 404.96 1200 150.96 79.96 1100 11 Butt-r-us 500 12494 9/4/2016 12495 9/4/2016 12498 9/5/2016 124 Fastnal1 256 Stapleton 124 Fastnal1 Funiture Tacks 1/2" Screw 1000 End of report UNF Order [OrderNo, Orderdate, SuppNo, SuppName, (PartNo, PartDesc, QtyOrd, Price)] 1NF 2NF 3NF

Explanation / Answer

4

UNF:

Order[OrderNo,Orderdate,SuppNo,SuppName,(PartNo,PartDesc,QtyOrd,Price)]

1NF

convert non-atomic (PartNo,PartDesc,QtyOrd,Price) attributes to atomic attributes

Order[OrderNo,Orderdate,SuppNo,SuppName,PartNo,PartDesc,QtyOrd,Price]

2NF

all non key attributes should be fully functionally dependent on primary key attribute

Order[OrderNo,Orderdate]

Supplier[SuppNo,SuppName]

Part[PartNo,PartDesc,QtyOrd,Price]

underlined attributes are primary keys

3NF

Remove transitive dependency .

As there is no transitive dependency

The tables are in 3NF

5.

Conceptual diagram of 3NF relations

OrderNo(PK)

OrderDate

SuppNo(PK)

SuppName

PartNo(PK)

PartDesc

QtyOrd

Price

Order

OrderNo(PK)

OrderDate

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---