Exam 2: Database Design Fundamentals

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

In a relational database,relationships are implemented by having common columns in two or more tables.

What are the six steps necessary to design a database for a set of requirements?

In a relation,all values in a column are values of the same attribute.

A record is another term for a(n)____.

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

A relation is a characteristic or property of an entity.

A relational database is a collection of ____________________.

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

What is the precise definition of a primary key?

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

You can determine functional dependence by viewing sample data.

Because there is a one-to-many relationship between sales reps and customers in the TAL Distributors database,one sales rep can be associated with zero,one,or more customers.

A table is in third normal form if it is in second normal form and no nonkey column is dependent on only a portion of the primary key.

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

Qualification is an update anomaly.

If B is functionally dependent on A,you also can say that A functionally ____________________ B.

The process of determining the particular tables and columns that will comprise a database is known as ____.

The four categories of update anomalies are additions,deletions,inconsistent data,and ____________________.

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