Exam 5: Database Design: Normalization

Discuss the overall process of normalization as it relates to anomalies and list the most common normal forms.

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

What do you call a table that contains a repeating group?

Which of the following tables is most likely a lookup table?

Which of the following statements describes a table in first normal form?

Which Access function returns the position of the space character in a field?

_____ follows a series of steps to break columns into smaller tables to identify entities and facts about each entity.

A table is in second normal form when it is in first normal form and _____.

Which normal form has additional conditions that further remove data redundancies and eliminate data modification anomalies beyond the Boyce-Codd normal form?

A table is in first normal form when it does not contain repeating groups, each column contains atomic values, and there are no duplicate records.

A(n) _____ is a piece of data that cannot be meaningfully divided.

When the primary key field consists of a combination of two or more fields, it is called a _____.

Which of the following expressions combines the atomic values from two fields in a LastName, FirstName format in an expression in an Access query?

An Employee field with an employee's full name contains an atomic value.

In the following Projects table, which field is functionally dependent on the ClientID field? Projects (ProjectID, ProjectType, ProjectName, ProjectManager, Budget, ClientID)

A(n) _____ results if you cannot add data to the database due to absence of other data.

_____ refers to how attributes (fields) depend on or relate to other attributes in a relation (table).

Discuss how a primary key, candidate key, and composite key are related.

The primary key can be a composite key, which is a combination of two or more fields.

_____ describes the relationship of attributes in an entity.