Exam 15: Normalize a Database for Effective Design

The ________ requires that all determinants are candidate keys and that all lower levels of NF are satisfied.

An entity relationship diagram tells you about data flow and is a fixed view of the database structure.

A database record equivalent is also known as a(n)________.

The ________ normal form requires that the table has to be free of transitive dependencies.

A(n)________ anomaly forces you to enter data about two different entities when you have data on only one entity.

In the ________ normal form,the table has no fields with partial dependencies on a composite or concatenated key.

A(n)________ is when the field only depends on one part of a composite or concatenated key.In other words,the field is determined by only one piece of a multifield key.

Which of the following is NOT true when deciding when to use a surrogate key?

Which of the following is NOT true about identifying the attributes in an ERD?

In a small business,a department might be managed by no more than one manager,and each manager manages no more than one department.This is an example of a ________ relationship.

________ will remove every record with the foreign key if the record with the value is deleted from the primary table.

An example of an artificial key is a driver's license number.

The ________ normal form dictates that the table must not have repeating groups of values in a single column and that it must have a key.

A primary key is a field that uniquely identifies a record.

A surrogate key can increase the file size and require more joins.

By normalizing to ________,you are eliminating all functional dependencies.

When multiple fields are used to identify a record,it is a(n)________ key.

A deletion anomaly forces you to delete one piece of data when you wanted to delete two pieces of data.