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

Matching

Review LaterAdd Note

Review Later

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

Premises

Responses

A process that involves converting tables into various types of normal forms.

entity

primary key

nonkey

relation

attribute

tuple

normalization

relationship

determinant

field

Premises

A process that involves converting tables into various types of normal forms.

Responses

entity

primary key

nonkey

relation

attribute

tuple

normalization

relationship

determinant

field

Show Answer

Correct Answer

Premises

Responses

entity

primary key

nonkey

relation

attribute

tuple

normalization

relationship

determinant

field

Premises

entity

primary key

nonkey

relation

attribute

tuple

normalization

relationship

determinant

field

Responses

Question 23

True/False

Review LaterAdd Note

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

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.

A(n) ____________________ is an association between entities.

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

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

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.

Rows in a table often are called records or _____.

What is functional dependence?

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

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) ____________________ key is a field in one table whose values are required to match the primary key of another table.

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.

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.

A(n) _____ is an association between entities.

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 ____________________.

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