Question 1

Association tables sometimes connect more than two entities.

Accepted Answer

A) True 
 B)False  True

Question 2

In many-to-many relationships in a relational database design,________.

Accepted Answer

A) the key of the child is placed as a foreign key into the parent 
B) the key of the parent is placed as a foreign key into the child 
C) the keys of both tables are placed in a third table 
D) the keys of both tables are joined into a composite key 
E) C and D 
A) the key of the child is placed as a foreign key into the parent 
B) the key of the parent is placed as a foreign key into the child 
C) the keys of both tables are placed in a third table 
D) the keys of both tables are joined into a composite key 
E) C and D E

Question 3

To represent an M:N relationship in a relational database design,in essence it is reduced to two 1:N relationships.

Accepted Answer

A) True 
 B)False  True

Question 4

The binary constraint MUST COVER indicates that ________.

Accepted Answer

A) a specific binary relationship must be included in a ternary relationship 
B) a table includes values that must occur in a binary relationship 
C) a table includes values that must occur in a ternary relationship 
D) a binary relationship includes value combinations that must occur in a binary relationship 
E) a binary relationship includes a set of value combinations that must all occur in a ternary relationship 
A) a specific binary relationship must be included in a ternary relationship 
B) a table includes values that must occur in a binary relationship 
C) a table includes values that must occur in a ternary relationship 
D) a binary relationship includes value combinations that must occur in a binary relationship 
E) a binary relationship includes a set of value combinations that must all occur in a ternary relationship

Question 5

A surrogate key should be considered when ________.

Accepted Answer

A) a relationship is M:N 
B) a composite key is required 
C) the key contains a lengthy text field 
D) the key contains a number 
E) an index needs to be created 
A) a relationship is M:N 
B) a composite key is required 
C) the key contains a lengthy text field 
D) the key contains a number 
E) an index needs to be created

Question 6

Which of the following is not a step in the database design process?

Accepted Answer

A) Create tables and columns from entities and attributes 
B) Select primary keys 
C) Represent relationships 
D) Create constraints and triggers 
E) All of the above are steps in the database design process. 
A) Create tables and columns from entities and attributes 
B) Select primary keys 
C) Represent relationships 
D) Create constraints and triggers 
E) All of the above are steps in the database design process.

Question 7

In a relational database design,all relationships are expressed by ________.

Accepted Answer

A) creating a primary key 
B) creating a foreign key 
C) creating a supertype 
D) creating a subtype 
E) creating a line between entities 
A) creating a primary key 
B) creating a foreign key 
C) creating a supertype 
D) creating a subtype 
E) creating a line between entities

Question 8

To represent an IS-A relationship in a relational database design,the IS-A relationship must be converted into a HAS-A relationship.

Accepted Answer

A) True 
 B)False

Question 9

When representing a one-to-many relationship in a relational database design,________.

Accepted Answer

A) the parent is always on the one side of the "one-to-many" relationship 
B) the child is always on the one side of the "one-to-many" relationship 
C) either parent or child can be on the one side of the "one-to-many" relationship,and the choice is arbitrary 
D) either parent or child can be on the one side of the "one-to-many" relationship,and special criteria indicate which table should be on the one side 
E) None of the above is correct. 
A) the parent is always on the one side of the "one-to-many" relationship 
B) the child is always on the one side of the "one-to-many" relationship 
C) either parent or child can be on the one side of the "one-to-many" relationship,and the choice is arbitrary 
D) either parent or child can be on the one side of the "one-to-many" relationship,and special criteria indicate which table should be on the one side 
E) None of the above is correct.

Question 10

An intersection table can have additional attributes besides the keys of its parent tables.

Accepted Answer

A) True 
 B)False

Question 11

Data types are consistent across all DBMS products.

Accepted Answer

A) True 
 B)False

Question 12

A data constraint is a limitation on data values.

Accepted Answer

A) True 
 B)False

Question 13

The binary constraint MUST NOT indicates that ________.

Accepted Answer

A) a specific binary relationship must not be included in a ternary relationship 
B) a table includes values that must not occur in a binary relationship 
C) a table includes values that must not occur in a ternary relationship 
D) a binary relationship includes value combinations that must not occur in a binary relationship 
E) a binary relationship includes value combinations that must not occur in a ternary relationship 
A) a specific binary relationship must not be included in a ternary relationship 
B) a table includes values that must not occur in a binary relationship 
C) a table includes values that must not occur in a ternary relationship 
D) a binary relationship includes value combinations that must not occur in a binary relationship 
E) a binary relationship includes value combinations that must not occur in a ternary relationship

Question 14

A referential integrity constraint policy that insures that all rows containing a particular foreign key value in a table are eliminated from the table when the row containing the corresponding primary key value in a parent table is eliminated from the database is called cascading deletes.

Accepted Answer

A) True 
 B)False

Question 15

One of the important properties of a column is whether or not it is ________.

Accepted Answer

A) found in more than one entity 
B) required 
C) character or numeric 
D) subject to normalization 
E) subject to denormalization 
A) found in more than one entity 
B) required 
C) character or numeric 
D) subject to normalization 
E) subject to denormalization

Question 16

A surrogate key should be considered when the key contains a lengthy text field.

Accepted Answer

A) True 
 B)False

Question 17

In relational database design,ID-dependent entities are used to ________.

Accepted Answer

A) represent N:M relationships 
B) handle associative relationships 
C) handle multivalued attributes 
D) handle archetype/instance relationships 
E) All of the above. 
A) represent N:M relationships 
B) handle associative relationships 
C) handle multivalued attributes 
D) handle archetype/instance relationships 
E) All of the above.

Question 18

When placing a foreign key for a 1:1 relationship,the key of either table can be used as the foreign key in the other table.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is not true of recursive relationships?

Accepted Answer

A) When the recursive relationship is M:N,an intersection table is created. 
B) The rows of a single table can play two different roles. 
C) The techniques for representing the tables are the same as for non-recursive relationships except the rows are in the same table. 
D) Recursive relationships can be 1:1,1:N,or M:N relationships. 
E) Even when the relationship is 1:N,a new table must be defined to represent the relationship. 
A) When the recursive relationship is M:N,an intersection table is created. 
B) The rows of a single table can play two different roles. 
C) The techniques for representing the tables are the same as for non-recursive relationships except the rows are in the same table. 
D) Recursive relationships can be 1:1,1:N,or M:N relationships. 
E) Even when the relationship is 1:N,a new table must be defined to represent the relationship.

Question 20

The values of a surrogate key have no meaning to the users.

Accepted Answer

A) True 
 B)False

Exam 6: Transforming Data Models Into Database Designs

Association tables sometimes connect more than two entities.

In many-to-many relationships in a relational database design,________.

To represent an M:N relationship in a relational database design,in essence it is reduced to two 1:N relationships.

The binary constraint MUST COVER indicates that ________.

A surrogate key should be considered when ________.

Which of the following is not a step in the database design process?

In a relational database design,all relationships are expressed by ________.

To represent an IS-A relationship in a relational database design,the IS-A relationship must be converted into a HAS-A relationship.

When representing a one-to-many relationship in a relational database design,________.

An intersection table can have additional attributes besides the keys of its parent tables.

Data types are consistent across all DBMS products.

A data constraint is a limitation on data values.

The binary constraint MUST NOT indicates that ________.

A referential integrity constraint policy that insures that all rows containing a particular foreign key value in a table are eliminated from the table when the row containing the corresponding primary key value in a parent table is eliminated from the database is called cascading deletes.

One of the important properties of a column is whether or not it is ________.

A surrogate key should be considered when the key contains a lengthy text field.

In relational database design,ID-dependent entities are used to ________.

When placing a foreign key for a 1:1 relationship,the key of either table can be used as the foreign key in the other table.

Which of the following is not true of recursive relationships?

The values of a surrogate key have no meaning to the users.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Sql for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters