Exam 2: Database Design Fundamentals

If the primary key of a table contains only a single column, the table is automatically in ____________________ normal form.

____ is one of the categories of update anomalies.

A table's design should be as simple as possible; you should restrict each position in a table to a single entry by not allowing multiple entries (called a(n) ____________________ group) in an individual location in the table.

A(n) ____ is a characteristic or property of an entity.

The same column name can appear in two different tables in a relational database.

A relation is in ____________________ normal form if it does not contain any repeating groups.

Qualification is an update anomaly.

A determinant is any column (or collection of columns) that determines another table.

In one style of entity-relationship (E-R) diagrams, a crow's foot is used to represent the ____________________ side of a relationship.

The definition for a primary key really defines a candidate key as well.

In a relational database, each entity has its own table.

In one style of entity-relationship (E-R) diagrams, the letter n is used to represent the ____________________ side of a relationship.

What is the precise definition of a primary key?

The ____________________ key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.

A ____ column is a column that is not part of the primary key.

If a table contained both employee numbers and Social Security numbers, both columns would be referred to as candidate keys.

In a relation, the order of the rows and columns is immaterial.

______________________________ is another name given to third normal form in this text.

Any column (or collection of columns) that determines another column is called a(n) ____.

____ can occur when there is a column in a table that is dependent on only a portion of the primary key.