FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Database Design

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Matching

Review LaterAdd Note

Review Later

Identify the letter of the choice that best matches the phrase or definition.

Premises

Responses

A field that is not part of a primary key.

normalization

primary key

determinant

field

entity

nonkey

relation

tuple

relationship

attribute

Premises

A field that is not part of a primary key.

Responses

normalization

primary key

determinant

field

entity

nonkey

relation

tuple

relationship

attribute

Show Answer

Correct Answer

Premises

Responses

normalization

primary key

determinant

field

entity

nonkey

relation

tuple

relationship

attribute

Premises

normalization

primary key

determinant

field

entity

nonkey

relation

tuple

relationship

attribute

Responses

Question 22

Short Answer

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

A(n) _____ is an association between entities.

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

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) _____ 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.

A(n) ____________________ is an association between entities.

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

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

Rows in a table often are called records or _____.

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.

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.

What is functional dependence?

Identify the letter of the choice that best matches the phrase or definition.

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

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.

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.

Identify the letter of the choice that best matches the phrase or definition.

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.

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