Consider the following functional dependencies in a database Date_of_Birth →…

PYQ GATE 2003

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:

  1. A.

    In second normal form but not in third normal form

  2. B.

    In third normal form but not in BCNF

  3. C.

    In BCNF

  4. D.

    None of the above

Attempted by 329 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…