Question: Given the relation and functional dependencies below, normalize the SALE relation and resulting relations all the way to BCNF . You need to demonstrate each

Given the relation and functional dependencies below, normalize the SALE relation and resulting relations all the way to BCNF. You need to demonstrate each normalization transformation, justifying every step. That is, you must list the reason(s) why a relation is (or is not) in a certain normal form, and what you need to do to transform the table, if needed. Be sure to use proper relational notation and reference statements for foreign keys. For the 4NF, you may just indicate if yes or no and why.
Relation:
SALE(invoiceNo, itemNo, custID, custName, custAddress, itemName, itemPrice, itemQtyPurch, salesPersonNo, salesPersonName, subtotal, tax, totalDue)
Functional Dependencies:
1. invoiceNo, itemNo -> custID, custName, custAddress, itemName, itemPrice, itemQtyPurch, salesPersonNo, salesPersonName, subtotal, tax, totalDue
2. itemNo -> itemName, itemPrice
3. invoiceNo -> custID, custName, custAddress, salesPersonNo, salesPersonName, subtotal, tax, totalDue
4. custID -> custName, custAddress
5. salesPersonNo -> salesPersonName

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!