Open In App
Related Articles

GATE | GATE-CS-2003 | Question 85

Improve Article
Save Article
Like Article

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
(D) None of the above

Answer: (D)

Explanation: The given table is not in 2NF as age is dependent on date of birth.

Quiz of this Question

Last Updated : 28 Jun, 2021
Like Article
Save Article
Similar Reads