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) → GradeThe relation (Roll_number, Name, Date_of_birth, Age) is:

Question

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) → GradeThe relation (Roll_number, Name, Date_of_birth, Age) is:

TuteeHUB · Accepted Answer

NA

TuteeHUB · Answer

In second normal form but not in third normal form

TuteeHUB · Answer

In third normal form but not in BCNF

TuteeHUB · Answer

In BCNF

TuteeHUB · Answer

None of the above

1.	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) → GradeThe 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
Answer» E.

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) → GradeThe relation (Roll_number, Name, Date_of_birth, Age) is:

Discussion

No Comment Found

Related MCQs

Reply to Comment