The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
0 votes
191 views

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

asked in Databases by Junior (643 points)
retagged by | 191 views
0
A. a student cant have more than one driving teacher(taking general case),so it is not correct.

B. one license number cant be possessed by more than one model,hence it is also not correct.

D.teacher's name can uniquely identif which car model it is having,so i think D is the correct dependency.

whats the answer??

Please log in or register to answer this question.

Related questions



Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

47,256 questions
51,483 answers
178,688 comments
66,769 users