GATE | GATE-CS-2003 | Question 85
Consider the following functional dependencies in a database:
Data_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) None of the above
Explanation: The given table is not in 2NF as age is dependent on date of birth.
Quiz of this Question
My Personal Notes arrow_drop_up
Please Login to comment...