Consider the following functional dependencies in a database:
Date_of_Birth —> Age Age —> Eligibility
Name —> Roll_number Roll_number -> Name
Course_number ---> Course—> name Course_number —> Instructor
(Roll number; Course_number) —> Grade
The relation (Roll_number; Name; Date_of birth, Age) is
A. | in second normal form but not in third normal form |
B. | in third normal form but not in BCNF |
C. | in BCNF |
D. | in none of the above |
Answer : D Explanation : |
|
Option: A Explanation : Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. |