Exam 6: Database Design 2: Design Method

The style of E-R diagram used in the text is ____________________.​

When implementing the physical-level design,for secondary keys,you must ensure that it is possible to retrieve data rapidly on the basis of a value of the ____ key.​

​A relationship that is not necessary for identification is called a(n)____________________ relationship.

When a DBMS creates a(n)____ key,it is usually an automatic numbering data type,such as the Access AutoNumber data type.​

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

After the information-level design is completed,____ is the next step.​

Complete categories are represented by ____ line(s)below the category symbol.​

A set of requirements that is necessary to support the operations of a particular database user is known as a(n)____.​

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

On an E-R diagram,____________________ entities have rounded corners.​

The type of information collected on the survey form that describes how data is updated is ____.​

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

​A foreign key is a column or collection of columns in one table that is required to match the value of the primary key for some row in another table,or be null.

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

A(n)____________________ is essentially both an entity and a relationship and is represented in an E-R diagram by a diamond within a rectangle.​