Exam 2: Database Design Fundamentals

Normalization is done before creating the database design.

A relation is a characteristic or property of an entity.

How does a DBMS that follows the relational model handle entities, attributes of entities, and relationships between entities?

In the one-to-many type of relationship, the word many always indicates a large number.

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.

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

A(n) ____________________ is the association between entities.

In one style of entity-relationship (E-R) diagrams, diamonds are used to describe ____________________.

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.

Columns are sometimes called tuples.

A(n) ____ is the association between entities.

A relational database is a collection of ____________________.

A relation is essentially a three-dimensional table.

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

A(n) ____________________ is a person, place, thing, or event for which you want to store and process data.