ch2

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

Boyce-Codd

____ is the formal term for combining two or more columns to form a primary key.

Concatenation

A matrix is the association between entities. T/F

False

A primary key always comprises a single column. T/F

False

A relation is a characteristic or property of an entity.

False

A secondary key is the unique identifier for a table.

False

A tabular database is a collection of tables. T/F

False

Columns are sometimes called tuples. T/F

False

Normalization is done before creating the database design. T/F

False

You can determine functional dependence by viewing sample data. T/F

False

Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE) table?

ORDER_NUM and ITEM_NUM

____ is the duplication of data.

Redundancy

An unnormalized relation is a relation that may contain repeating groups. T/F

True

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. T/F

True

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

True

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

True

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

True

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

True

It is possible for the computer to generate values that are used as the primary key column. T/F

True

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

True

The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class, you can determine the pay rate. T/F

True

When you convert an unnormalized table to a table in first normal form, the primary key of the table in first normal form is usually the concatenation of at least two columns. T/F

True

You can indicate a table's primary key by underlining the column or collection of columns that comprises the primary key for each table in the database. T/F

True

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

attribute, column, field (all of the above)

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

column

Which of the following symbols is used to qualify column names?

comma(,)

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

database design

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

determinant

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

determines

A relationship is an association between ____________________.

entities

A relation is in _______ if it does not contain any repeating groups

first normal form

____ is one of the categories of update anomalies.

inconsistent data

In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as ____.

lines

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

many

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

nonkey

At TAL Distributors, there is a ____ relationship between sales reps and customers.

one-to-many

There is a commonly accepted shorthand representation to show the structure of a relational database: After the name of the table, all the columns in the table are listed within a set of ____.

parentheses

When you write a column in the format CUSTOMER.REP_NUM, you say that you ____________________ the column name.

qualify

In an entity-relationship (E-R) diagram, ____ are used to represent an entity.

rectangles

A(n) ____ is the association between entities.

relationship

A(n) ____________________ is the association between entities.

relationship

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.

repeating

A record is another term for a(n)

row

A relational database is a collection of ____________________.

tables

In this text, Boyce-Codd normal form is the same as ____.

third normal form

A(n) ____________________ is another name for a record or a row.

tuple

In a relational database each ____ should be unique.

tuple, row, record (all of the above)

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

update anomalies

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

updates