Question 1

If the primary key of a table contains only a single column, the table is automatically in ____________________ normal form.

Accepted Answer

The answer of If the primary key of a table...

Question 2

____ is one of the categories of update anomalies.

Accepted Answer

A)  Functional dependence 
B)  Functional splitting 
C)  Inconsistent data 
D)  Qualification

Question 3

A table's design should be as simple as possible; you should restrict each position in a table to a single entry by not allowing multiple entries (called a(n) ____________________ group) in an individual location in the table.

Accepted Answer

The answer of A table's design should be as simple...

Question 4

A(n) ____ is a characteristic or property of an entity.

Accepted Answer

A)  field 
B)  attribute 
C)  column 
D)  All of the above

Question 5

The same column name can appear in two different tables in a relational database.

Accepted Answer

A) True 
 B)False

Question 6

A relation is in ____________________ normal form if it does not contain any repeating groups.

Accepted Answer

The answer of A relation is in ____________________ normal form...

Question 7

Qualification is an update anomaly.

Accepted Answer

A) True 
 B)False

Question 8

A determinant is any column (or collection of columns) that determines another table.

Accepted Answer

A) True 
 B)False

Question 9

In one style of entity-relationship (E-R) diagrams, a crow's foot is used to represent the ____________________ side of a relationship.

Accepted Answer

The answer of In one style of entity-relationship (E-R) diagrams,...

Question 10

The definition for a primary key really defines a candidate key as well.

Accepted Answer

A) True 
 B)False

Question 11

In a relational database, each entity has its own table.

Accepted Answer

A) True 
 B)False

Question 12

In one style of entity-relationship (E-R) diagrams, the letter n is used to represent the ____________________ side of a relationship.

Accepted Answer

The answer of In one style of entity-relationship (E-R) diagrams,...

Question 13

What is the precise definition of a primary key?

Accepted Answer

The answer of What is the precise definition of a...

Question 14

The ____________________ key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.

Accepted Answer

The answer of The ____________________ key of a table (relation)...

Question 15

A ____ column is a column that is not part of the primary key.

Accepted Answer

A)  determinant 
B)  candidate 
C)  functional 
D)  nonkey

Question 16

If a table contained both employee numbers and Social Security numbers, both columns would be referred to as candidate keys.

Accepted Answer

A) True 
 B)False

Question 17

In a relation, the order of the rows and columns is immaterial.

Accepted Answer

A) True 
 B)False

Question 18

______________________________ is another name given to third normal form in this text.

Accepted Answer

The answer of ______________________________ is another name given to third...

Question 19

Any column (or collection of columns) that determines another column is called a(n) ____.

Accepted Answer

A)  nonkey column 
B)  primary key 
C)  dependency 
D)  determinant

Question 20

____ can occur when there is a column in a table that is dependent on only a portion of the primary key.

Accepted Answer

A)  Qualification 
B)  Update anomalies 
C)  Function splitting 
D)  Determination

Exam 2: Database Design Fundamentals

If the primary key of a table contains only a single column, the table is automatically in ____________________ normal form.

____ is one of the categories of update anomalies.

A table's design should be as simple as possible; you should restrict each position in a table to a single entry by not allowing multiple entries (called a(n) ____________________ group) in an individual location in the table.

A(n) ____ is a characteristic or property of an entity.

The same column name can appear in two different tables in a relational database.

A relation is in ____________________ normal form if it does not contain any repeating groups.

Qualification is an update anomaly.

A determinant is any column (or collection of columns) that determines another table.

In one style of entity-relationship (E-R) diagrams, a crow's foot is used to represent the ____________________ side of a relationship.

The definition for a primary key really defines a candidate key as well.

In a relational database, each entity has its own table.

In one style of entity-relationship (E-R) diagrams, the letter n is used to represent the ____________________ side of a relationship.

What is the precise definition of a primary key?

The ____________________ key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.

A ____ column is a column that is not part of the primary key.

If a table contained both employee numbers and Social Security numbers, both columns would be referred to as candidate keys.

In a relation, the order of the rows and columns is immaterial.

______________________________ is another name given to third normal form in this text.

Any column (or collection of columns) that determines another column is called a(n) ____.

____ can occur when there is a column in a table that is dependent on only a portion of the primary key.