Exam 6: Database Design 2: Design Method

If you find that more than one table in your cumulative design has the same primary key, you should combine the tables to form a new table.

____________________ key restrictions determine the relationships between tables.

In IDEF1X terminology, what is a subtype called?

List the steps that must be followed for each user view, as suggested by the information-level design methodology.

What is an entity that can serve as the relationship between other entities called?

To obtain information about ____________________ dependencies you might ask users questions such as: "If you know a particular employee number, can you establish other information, such as employee name?"

The basic relationships among entities are: one-to-many, many-to-many, and one-to-one.

If each employee works in a single department, and each department has only one employee, the relationship between employees and departments is a one-to-many relationship.

An alternative to the primary key of a table is listed with which abbreviation in DBDL?

Columns that are of interest strictly for the purpose of retrieval are known as ____________________.

A surrogate key is a primary key that consists of a column that uniquely identifies an entity.

An entity with a minimum cardinality of one plays a(n) ____________________ role in the relationship.

The first step in creating a user view is to normalize the collection of tables.

During the ____________________-level design, designers must consider the characteristics of the particular DBMS that the organization will use.

As you design the user view, which aspect of the table are the properties of the entities you choose?

A weak entity is an entity that depends on another entity for its own existence.

On an E-R diagram, what does the number closest to the relationship represent?

What is the term used in an E-R diagram that specifies the maximum number of entities that can participate in a relationship?

What is an entity that does not require a relationship to another entity for identification?

For each table, you must identify the primary key and any alternate keys, secondary keys, and ____________________ keys.