Multiple choice

Consider the following dependencies in a database:
Date_of_Birth$\rightarrow$Age Age$\rightarrow$Eligibility Name$\rightarrow$Roll_number Roll_number $\rightarrow$ Name Course_ number $\rightarrow$Courses_ name Course_ number$\rightarrow$Instructor (Roll_number; Courses_ name) $\rightarrow$Grade The relation (Roll_number, Name, Date_of_Birth, age) is

  1. in second normal form but not in third normal form

  2. in third normal form but not in BCNF

  3. in BCNF

  4. in none of the above

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Given:  Date_of_Birth$\rightarrow$Age Age$\rightarrow$Eligibility Name$\rightarrow$Roll_number Roll_number $\rightarrow$ Name Course_ number $\rightarrow$Courses_ name Course_ number$\rightarrow$Instructor (Roll_number; Courses_ name) $\rightarrow$Grade For given relation: Date_of_Birth$\rightarrow$ Eligibility Course_ name$\rightarrow$ Instructor After observing we see that, it is not in 3rd normal form because in third normal form relation, every non-prime attribute is non transitively and fully dependent on the every candidate key. In 2nd normal form, all non - prime attributes are fully functionally dependent on the relation keys.