NIELIT A Level
Introduction to Database Management System
Consider the following relation that keeps track of the sales of a wholesale dealer in trousers:
TrousersSold(customerID, customerName, model, size, day, numberSold, price)
Suppose the following functional dependencies hold on the relation:
customerID -> customerName
customerID, model, size, day -> numberSold
model, size -> price
model, price -> size
a) Decompose the relation in smaller relations such that
– each of the smaller relations is in BNCF with respect to the projection of the original
– the decomposition is a lossles join decomposition.
b) Is your decomposition dependency preserving? If your answer is “yes”, argue why. If your
answer is “no”, show which dependencies have been lost.