Exam 6: Database Design 2: Design Method

How can you attempt to avoid the problem of creating a table that is not in third normal form?

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

When the existence of one entity depends on the existence of another related entity, there is an existence ____________________.

A subtype ____________________ is the specific attribute that determines the subtype-supertype relationship.

In DBDL documentation, what element of a table is followed by an arrow pointing to the table identified by the element?

After you have completed the first two steps for a given user view, you can merge the results into the cumulative design.

If each employee works in a single department and each department has several employees, what is the relationship between departments and employees?

If a many-to-many-to-many relationship is created when it is not appropriate to do so, how can the problem be corrected?

What is a relationship that is necessary for identification?

After the information-level design is completed, what is the next step?

Which of the following is used to improve performance in frequently used columns by maintaining a sort order but does not enforce constraints?

Describe the different types of primary keys.

In a one-to-many relationship, the primary key of the "many" table becomes the foreign key of the "one" table.

As soon as you have completed Steps 1 through 3 for a given user view, you can merge the results into the __________________ design.

If an entity represented in a supertype table is not represented in the subtype table, what is this called in IDEF1X terminology?