06-30-2010, 06:29 AM
[Q1. In which normal form the following STUDENT relation is if only A,B can act as the key. Marks 10
Answer:
No normal form exist here because here is functional dependency and starting form first normal form we have to remove the functional dependency. That’s why relation is in no normal form.
Q2. Examine the table shown below which is already in Second Normal Form (2NF). Marks 10
Answer:
3rd normal form:
Address ---------------------------------------------- Tel_No
New Garden Town, Lahore---------------------------042-4466375,042-4586975,042-4554668
Blue Area, Islamabad---------------------------------- 051-5546584,051-4687458
Address is taken as forigen key in 3rd normal form.
Answer:
No normal form exist here because here is functional dependency and starting form first normal form we have to remove the functional dependency. That’s why relation is in no normal form.
Q2. Examine the table shown below which is already in Second Normal Form (2NF). Marks 10
Answer:
3rd normal form:
Address ---------------------------------------------- Tel_No
New Garden Town, Lahore---------------------------042-4466375,042-4586975,042-4554668
Blue Area, Islamabad---------------------------------- 051-5546584,051-4687458
Address is taken as forigen key in 3rd normal form.