Convert the following unnormalized relation to fourth normal form using the same

Question

Convert the following unnormalized relation to fourth normal form using the same requirements as in Question 5 (many sales reps can represent one customer and one sales rep can represent many customers).

Question 5:

5. TAL Distributors is considering changing its business model so that many sales reps can represent one customer
and one sales rep can represent many customers. Using this information, convert the following unnormalized
relation to fourth normal form.

Rep (RepNum, LastName, FirstName, Street, City, State, PostalCode, Commission, Rate, (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit))

Explanation / Answer

A table is in fourth normal form (4NF) if and only if it is in BCNF and contains no more than one multi-valued dependency.

So lets decompose this table in to Representative and Customer attributes each in their individual tables.

Rep -> (RepNum, LastName, FirstName, Street, City, State, PostalCode, Commission, Rate)

Customer -> (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit )

Now to represent the relationship between Representative and Customer we introduce a new relationship table Rep_Customer_Reltn which has just the id attributes from both the tables so

Rep_Customer_Reltn -> (RepNum,CustomerNum)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects