Exam 6: Database Design 2: Design Method

The second step in creating a user view is to normalize the tables.

A weak entity corresponds to the term ____________________.

In the ____________________ design method,specific user requirements are synthesized into a design.

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

Explain the difference between a minimum cardinality of zero and a minimum cardinality of one.

If a many-to-many-to-many relationship is created when it is not appropriate to do so,the conversion to ____ normal form will correct the problem.

One way to indicate a one-to-many relationship is to place a crow's foot at the ____________________ end of the relationship.

When you combine third normal form tables,the result will always be in third normal form.

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

An entity that does not require a relationship to another entity for identification is called a(n) ____.

____ means that an entity has a minimum cardinality of zero.

The use of an "m" and an "n" in an E-R diagram indicates a many-to-many relationship.

A(n) ____ is a system-generated primary key that is usually hidden from users.

The simplest way to implement a one-to-one relationship is to treat it as a one-to-many relationship.

In IDEF1X,the ____ is the symbol for category.