STUDENT : (St_Name, Class#, Th_Mark, Dr_Mark)
STUDENT_DRIVING_TEACHER : (St_Name, Dr_T_Name)
TEACHER_THEORY_CLASS : (Class#, Th_T_Name)
TEACHER_VEHICLE : (Dr_T_Name, License#)
VEHICLE : (License#, Make, Model, Year).
A student takes one theory class as well as driving lessons and at the end
of the session receives marks for theory and driving. A Teacher may teach
theory, driving or both.
1) Which of the following functional dependencies hold :
(A) St_Name→→ Th_T_Name
(B) License#→→ Model
(C) St_Name→ License#
(D) Dr_T_Name→ Model
2) The schema of Question No. 7 is in which normal form ?
(A) BCNF
(B) 5NF
(C) 3NF
(D) 4NF
