Question 1

A cascading delete removes all records in other tables associated with the record to be deleted.

Accepted Answer

A) True 
 B)False

Question 2

A domain definition consists of all of the following components EXCEPT:

Accepted Answer

A)  domain name. 
B)  data type. 
C)  integrity constraints. 
D)  size. 
A)  domain name. 
B)  data type. 
C)  integrity constraints. 
D)  size.

Question 3

A nonkey attribute is also called a(n):

Accepted Answer

A)  column. 
B)  unimportant datum. 
C)  descriptor. 
D)  address. 
A)  column. 
B)  unimportant datum. 
C)  descriptor. 
D)  address.

Question 4

An anomaly is a type of flaw in the database server.

Accepted Answer

A) True 
 B)False

Question 5

When transforming a weak entity, one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.

Accepted Answer

A) True 
 B)False

Question 6

A partial functional dependency is a functional dependency in which one or more nonkey attributes are functionally dependent on part (but not all) of the primary key.

Accepted Answer

A) True 
 B)False

Question 7

The attribute on the left-hand side of the arrow in a functional dependency is the:

Accepted Answer

A)  candidate key. 
B)  determinant. 
C)  foreign key. 
D)  primary key. 
A)  candidate key. 
B)  determinant. 
C)  foreign key. 
D)  primary key.

Question 8

A candidate key must satisfy all of the following conditions EXCEPT:

Accepted Answer

A)  the key must uniquely identify the row. 
B)  the key must indicate the row's position in the table. 
C)  the key must be nonredundant. 
D)  each nonkey attribute is functionally dependent upon it. 
A)  the key must uniquely identify the row. 
B)  the key must indicate the row's position in the table. 
C)  the key must be nonredundant. 
D)  each nonkey attribute is functionally dependent upon it.

Question 9

Two or more attributes having different names but the same meaning are called:

Accepted Answer

A)  homonyms. 
B)  aliases. 
C)  synonyms. 
D)  alternate attributes. 
A)  homonyms. 
B)  aliases. 
C)  synonyms. 
D)  alternate attributes.

Question 10

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

Accepted Answer

A)  Sample data can be used to improve user communications. 
B)  Sample data can be used for prototype generation. 
C)  Sample data can reverse database implementation errors. 
D)  Sample data provide a convenient way to check the accuracy of your design. 
A)  Sample data can be used to improve user communications. 
B)  Sample data can be used for prototype generation. 
C)  Sample data can reverse database implementation errors. 
D)  Sample data provide a convenient way to check the accuracy of your design.

Question 11

________ database specification indicates all the parameters for data storage that are then input to database implementation.

Accepted Answer

A)  Logical 
B)  Physical 
C)  Schematic 
D)  Conceptual 
A)  Logical 
B)  Physical 
C)  Schematic 
D)  Conceptual

Question 12

In the figure below, what type of key is depicted?

Accepted Answer

A)  Primary 
B)  Recursive primary 
C)  Composite 
D)  Recursive foreign 
A)  Primary 
B)  Recursive primary 
C)  Composite 
D)  Recursive foreign

Question 13

Explain what a candidate key is and how it might be used.

Accepted Answer

A candidate key is an attribute or a com

Question 14

In the figure below, Customer_ID in the CUSTOMER Table is which type of key?

Accepted Answer

A)  Composite 
B)  Candidate 
C)  Standard 
D)  Grouped 
A)  Composite 
B)  Candidate 
C)  Standard 
D)  Grouped

Question 15

A referential integrity constraint is a rule that maintains consistency among the rows of two relations.

Accepted Answer

A) True 
 B)False

Question 16

When all multivalued attributes have been removed from a relation, it is said to be in:

Accepted Answer

A)  first normal form. 
B)  second normal form. 
C)  Boyce-Codd normal form. 
D)  third normal form. 
A)  first normal form. 
B)  second normal form. 
C)  Boyce-Codd normal form. 
D)  third normal form.

Question 17

A composite key consists of only one attribute.

Accepted Answer

A) True 
 B)False

Question 18

Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence.

Accepted Answer

A) True 
 B)False

Question 19

Data is represented in the form of:

Accepted Answer

A)  data trees. 
B)  tables. 
C)  data notes. 
D)  chairs. 
A)  data trees. 
B)  tables. 
C)  data notes. 
D)  chairs.

Question 20

Discuss the two possible scenarios when mapping an associative entity.

Accepted Answer

There are two possible cases for associa

A cascading delete removes all records in other tables associated with the record to be deleted.

A domain definition consists of all of the following components EXCEPT:

A nonkey attribute is also called a(n):

An anomaly is a type of flaw in the database server.

When transforming a weak entity, one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.

A partial functional dependency is a functional dependency in which one or more nonkey attributes are functionally dependent on part (but not all) of the primary key.

The attribute on the left-hand side of the arrow in a functional dependency is the:

A candidate key must satisfy all of the following conditions EXCEPT:

Two or more attributes having different names but the same meaning are called:

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

________ database specification indicates all the parameters for data storage that are then input to database implementation.

In the figure below, what type of key is depicted?

Explain what a candidate key is and how it might be used.

In the figure below, Customer_ID in the CUSTOMER Table is which type of key?

A referential integrity constraint is a rule that maintains consistency among the rows of two relations.

When all multivalued attributes have been removed from a relation, it is said to be in:

A composite key consists of only one attribute.

Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence.

Data is represented in the form of:

Discuss the two possible scenarios when mapping an associative entity.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 4: Logical Database Design and the Relational Model

A cascading delete removes all records in other tables associated with the record to be deleted.

A domain definition consists of all of the following components EXCEPT:

A nonkey attribute is also called a(n):

An anomaly is a type of flaw in the database server.

When transforming a weak entity, one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.

A partial functional dependency is a functional dependency in which one or more nonkey attributes are functionally dependent on part (but not all) of the primary key.

The attribute on the left-hand side of the arrow in a functional dependency is the:

A candidate key must satisfy all of the following conditions EXCEPT:

Two or more attributes having different names but the same meaning are called:

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

________ database specification indicates all the parameters for data storage that are then input to database implementation.

In the figure below, what type of key is depicted?

Explain what a candidate key is and how it might be used.

In the figure below, Customer_ID in the CUSTOMER Table is which type of key?

A referential integrity constraint is a rule that maintains consistency among the rows of two relations.

When all multivalued attributes have been removed from a relation, it is said to be in:

A composite key consists of only one attribute.

Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence.

Data is represented in the form of:

Discuss the two possible scenarios when mapping an associative entity.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters