Which of the following functional dependencies in the

19) Which of the following functional dependencies in the table FLIGHT is an augmented
functional dependency?
A) FlightID, Date --> NoOfPassengers
B) FlightID --> Origin
C) FlightID --> Destination
D) FlightID, Date --> Origin
Answer: D
Diff: 2 Page Ref: 97-99
20) What type of functional dependency does NOT exist in the table FLIGHT?
D
Diff: 3 Page Ref: 99-102
21) Table FLIGHT is:
B
Diff: 3 Page Ref: 105-109
22) Normalizing table FLIGHT to 3NF will result in:
B
Diff: 2 Page Ref: 105-109
5

DOCTOR
Observe the table DOCTOR:
DOCTOR
DoctorID NameDateOfMDGraduationNumberOfPatients
D111 John 1/1/1999 100
D222 Tina 1/2/2003 117
D333 Ellen 1/1/2001 117
D444 Tina 1/1/2003 144
This table will be used for the following questions citing table DOCTOR.
23) What type of functional dependency exists in the table DOCTOR?
A) Trivial
B) Partial
C) Transitive
D) All of the above
Answer: A
Diff: 3 Page Ref: 99-102
24) Table DOCTOR is:
D
Diff: 3 Page Ref: 105-109
25) Normalizing table DOCTOR to 3NF will result in:
A
Diff: 2 Page Ref: 105-109
4.2 True/False Questions
1) Update operations are also referred to as read operations.
Diff: 1 Page Ref: 91
2) A nonkey column is a column in a relation that is not a primary or a candidate key
column.
Diff: 1 Page Ref: 95
6

3) An insertion anomaly occurs when a user who wants to insert data about one real world
entity is forced to enter a unique value about it.
Diff: 1 Page Ref: 95
4) If A, B, C, and D are columns of the table whose composite primary key is A, B
while C and D are nonkey columns
then B --> C is a partial functional dependency.
Diff: 2 Page Ref: 101-102
5) If A, B, C, and D are columns of the table whose composite primary key is A, B
while C and D are nonkey columns
then B --> D is a transitive functional dependency.
Diff: 2 Page Ref: 101-102
6) If A, B, C, and D are columns of the table whose composite primary key is A, B
while C and D are nonkey columns
then C --> D is a transitive functional dependency.
Diff: 2 Page Ref: 101-102