TABLE NAME PRIMARY KEY NORMALIZATION DEPENDENCY LEVEL ITEM I

TABLE NAME PRIMARY KEY NORMALIZATION DEPENDENCY LEVEL ITEM ITEM ID Dependent on Item FEEDBACK ITEM ID Dependent on Item BID BID HISTORY Dependent on Item ITEM ID, CLIENT I D,BID DATE ITEM ID Dependent on Item BUY IT NOW BUYERS CLIENT ID WATCH LIST Dependent on CLIENT ID CLIENT Dependent on Client CLIENT CLIENT ID SELLER Dependent on Client CLIENT ID Dependent on Item PURCHASE HISTORY ITEM ID, CLIENT I and Buyer D

Solution

The first is level 1NF as it depend only on item id.

the second is level 2NF as it is dependant on bid and itemid

the third is level 4 NF because it is dependant on more than 4 things

the fourth is level 2NF as it is dependant on itemid and buy it now.

        the fifth is 2NF as it is dependant on buyers and clientid

the sixth is 2NF as it is dependant on watch_list and clientid

the seventh is 1NF only dependant on client_id