The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
0 votes
185 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 (623 points)
retagged by | 185 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.



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

39,537 questions
46,682 answers
139,863 comments
57,677 users