Question 1

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

Accepted Answer

A) 4NF 
B) 3NF 
C) 2NF 
D) 1NF 
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 
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 
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 
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 
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 
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)  
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. 
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 
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 
A) relational anomaly 
B) insertion anomaly 
C) update anomaly 
D) deletion anomaly

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

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

Third normal form is also often referred to as _____.

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

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

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

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

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

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

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

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters

Exam 5: Database Design: Normalization

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

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

Third normal form is also often referred to as _____.

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

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

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

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

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

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

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

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters