##
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.