Exam 6: Database Design 2: Design Method

In IDEF1X, _______________ categories are represented by two horizontal lines below the category symbol.

List the types of information that must be included on a survey form in order for it to be considered valuable to the design process.

The information-level design methodology is completed independently of any particular DBMS that the organization will ultimately use.

You can recognize entity subtypes by the fact the primary key is also a(n) ____________________.

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

In an entity-relationship diagram, rectangles represent foreign keys.

When the user views are not clearly defined, you should consider each stated requirement as a separate user view.

The E-R model (also called ERM) uses diagrams to represent the high-level abstract and conceptual representation of data, along with entities, attributes, and ____________________.

What type of primary key is system-generated and is usually hidden from users?

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.

What type of key is also called a logical key?

A rectangle represents each _____________ in an E-R diagram.

Which of the following is an example of an enforcing restriction?

A(n) ____________________ is a special value that represents the absence of a value in a field.

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

When combining third normal form tables, the resulting table will not be in third normal form when a column A in one user view determines a column B in a second user view, yet column A is not a column in the second user view.

What is an existence dependency? Provide an example.

When determining the primary key of a table you must decide what properties are required to uniquely identify an entity.

What does it mean when an entity has a minimum cardinality of zero?

A design that supports all user views is called a constructive design.