Exam 6: Database Design 2: Design Method

Convert the following table to first normal form: Branch (BranchNum ,BranchName,(BookCode,Title,CopyNum,Quality,Price) )

On an E-R diagram,the number closest to the relationship represents ____ cardinality.

____________________ refers to the number of items that must be included in a relationship.

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

What type of information should be included on a survey form in order for it to be considered valuable to the design process?

An entity that depends on another entity for its own existence is called a(n) ____________________.

When provided with a user view or some sort of stated requirement,you must develop a collection of tables that will support it.

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

A column that you create for an entity to serve solely as the primary key and that is visible to users is called a(n) ____.

Independent entities have ____ in an E-R diagram.

The information-level design methodology involves representing the individual user view as a collection of tables,refining them to eliminate any problems,and then merging them into a cumulative design.

An entity that exists to implement a many-to-many relationship is called a(n) ____.

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

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

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

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

The second step in creating a user view is to identify all keys in the tables.

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

The properties of the entities you choose as you design the user view will become the ____ in the appropriate tables.

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