Exam 12: Database Design

Rows in a table often are called records or _____.

A(n) _____ interviews users, examines existing and proposed documents, investigates current procedures, and reviews organizational policies to determine exactly the type of data needs the database must support.

The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, you should restrict each position in the table to a single entry, that is, you do not permit multiple entries, often called _____ in the table.

The accompanying figure shows the Access relationship diagram for the Camashaly Design database. ____________________ are represented by lines with the "one" end represented by the number 1 and the "many" end represented by the infinity symbol.

Many-to-many relationships are implemented through an additional table that contains matching fields for both of the related tables.

What is functional dependence?

An organization can use either Social Security Number or Employee ID as the primary key for a table. These two fields are considered _____ keys.

If a client can be offered many courses and each course is offered to many clients, there is a(n) ____________________ relationship between clients and courses.

The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each column in a table should have a _____ name and entries in each column should match this column name.

A(n) ____________________ is an association between entities.

A(n) _____ is an association between entities.

The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. In general, when converting a non-1NF table to 1NF, the primary key typically will include the original primary key _____ with the key of the repeating group.

A(n) ____________________ key is a field in one table whose values are required to match the primary key of another table.

If there are two possibilities for a primary key, one field is chosen as the primary key and the other field is called a(n) ____________________ key.

Existing documents, such as purchase orders and procedural manuals, can often furnish helpful information concerning the database design.

A table is in second normal form (2NF) if it is in first normal form and no _____ field is dependent on only a portion of the primary key.

The determination of database requirements is part of a process known as ____________________.