Question 1

Relational databases are often implemented on tables in what normal form?

Accepted Answer

A) 4NF 
B) 3NF 
C) 2NF 
D) 1NF

Question 2

Which type of table is an excellent candidate for improvement to second normal form?

Accepted Answer

A) table with duplicate records 
B) lookup table 
C) table with a multifield primary key field 
D) table with an AutoNumber primary key field

Question 3

Third normal form is also often referred to as _____.

Accepted Answer

A) ultimate normal form 
B) Boyce-Codd normal form 
C) SQL normal form 
D) Edgar-Hopper normal form

Question 4

What do you call each key that meets the criteria for a primary key?

Accepted Answer

A) candidate key 
B) potential key 
C) lookup key 
D) functional key

Question 5

A(n) _____ occurs if a nonkey attribute determines another nonkey attribute.

Accepted Answer

A) insertion anomaly 
B) unnormalized relation 
C) composite key 
D) transitive dependency

Question 6

A(n) _____ helps constrain the values in a single field to a specific list, which eliminates update anomalies.

Accepted Answer

A) candidate list 
B) attribute 
C) lookup table 
D) functional dependency

Question 7

Which of the following tables should be converted to second normal form?

Accepted Answer

A) Employees (EmpID, EmpFirst, EmpLast, Department) 
B) Visits (VisitID, VisitType, VisitDate, PatientID, LengthInMinutes) 
C) Players (PlayerID, PlayerFirst, PlayerLast, CoachID, CoachFirst, CoachLast, Team) 
D) Bookings (BookingID, CheckInDate, CheckOutDate, RoomID, CustomerI
D)

Question 8

Which of the following is an example of an insertion anomaly?

Accepted Answer

A) A new student cannot be assigned to a professor because the student does not have a StudentID. 
B) A department name must be changed manually in several records. 
C) When professors retire, their records are removed from the database, which also loses information about the students they advised. 
D) A student can take several classes, and classes can enroll many students.

Question 9

What do you call a table that contains multiple field entries in a single column?

Accepted Answer

A) unnormalized relation 
B) composite key 
C) Boyce-Codd normal form 
D) lookup table

Question 10

What do you call a data inconsistency that results from data redundancy or the use of inappropriate nulls?

Accepted Answer

A) relational anomaly 
B) insertion anomaly 
C) update anomaly 
D) deletion anomaly

Exam 5: Database Design: Normalization