Database MCQ

1:

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

A.

in second normal form but not in third normal form

B.

in third normal form but not in BCNF

C.

in BCNF

D.

in none of the above

 

Answer : D

Explanation :

Write your comments here:


Report Error
 

Option: A

Explanation : Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here.