NIELIT A Level Introduction to Database Management System Assignment 10

NIELIT A Level

Introduction to Database Management System

Assignment 10

Wholesale Dealer

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
dependencies;
– 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.

Next Assignment