1List att the Super Keys not just candidate keys List the no

1)List att the Super Keys (not just candidate keys)

)List the non-prie attributes

)List the non-trivial functional dependencies.

)Which of the following normal form is the table in? 1NF,2NF,3NF,BCNF (choose all which apply )

)For each normal form which it is not in, demonstrate why it is not in that normal form by describing the normal form violation for that normal form.

Solution

1) D is a super key which is uniquely identified in a rows.

2) D is a candidate key

A,B,C are non prime attributes which are not candidate keys.

3) the following functional dependencies are non trival

D-->A(A is not sub element of D)

D-->B(B is not sub element of D)

D-->C(C is not sub element of D)

4) 1NF : An attribute of a table cannot hold many values

The above table is in 1NF

2NF: It should be 1NF and

No non prie attribute is dependent on proper subset of candidate key

Above table satisfies both conditions so this is 2NF

3NF: It should be 2NF and

for each functional dependency X-->Y atleast one of the conditions hold:

i) X is super key of table

ii) Y is a prime attribute of table

Above table satisfies those conditions hence it is also 3NF

BCNF: It should be 3NF and

for every functional dependency X-->Y,X should be super key o table.

Above table satisfies those conditions hence it is also BCNF