Question 1

When creating a relational database design from E-R diagrams,first create a relation for each relationship.

Accepted Answer

A) True 
 B)False

Question 2

In a 1:N relationship,the term parent refers to the table on the "many" side of the relationship.

Accepted Answer

A) True 
 B)False

Question 3

When creating a table for an ID-dependent entity,both the key of the parent and the key of the entity itself must appear in the table.

Accepted Answer

A) True 
 B)False

Question 4

Cascading deletions are generally not used with relationships for weak child entities.

Accepted Answer

A) True 
 B)False

Question 5

When transforming an E-R data model into a relational database design,the key of the parent entity should be placed as part of the primary key into the child entity ________.

Accepted Answer

A) when the child entity is ID-dependent 
B) when the child entity is non-ID-dependent 
C) when the child entity has a 1:1 relationship with the parent entity 
D) when the child entity has a 1:N relationship with the parent entity 
A) when the child entity is ID-dependent 
B) when the child entity is non-ID-dependent 
C) when the child entity has a 1:1 relationship with the parent entity 
D) when the child entity has a 1:N relationship with the parent entity

Question 6

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

When transforming an ID-dependent E-R data model relationship into a relational database design,the referential integrity constraints should allow ________.

Accepted Answer

A) parent updates to cascade 
B) child updates to cascade 
C) child deletes to cascade 
D) Both A and B are correct 
A) parent updates to cascade 
B) child updates to cascade 
C) child deletes to cascade 
D) Both A and B are correct

Question 9

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 
A) creating a primary key 
B) creating a foreign key 
C) creating a supertype 
D) creating a subtype

Question 10

The first step in transforming an extended E-R model into a relational database design is to ________.

Accepted Answer

A) create a table for each relationship 
B) evaluate the entities against the normalization criteria 
C) create a table for each entity 
D) remove any recursive relationships 
A) create a table for each relationship 
B) evaluate the entities against the normalization criteria 
C) create a table for each entity 
D) remove any recursive relationships

Question 11

Explain the representation of a one-to-many strong entity relationship in a relational database design.

Accepted Answer

One-to-many relationships are represente

Question 12

When transforming an ID-dependent E-R data model relationship into a relational database design where the child entity is designed to use a surrogate key,the relationship changes to a weak but not ID-dependent relationship.

Accepted Answer

A) True 
 B)False

Question 13

The identifier of the entity becomes the ________ of the corresponding table.

Accepted Answer

A) primary key 
B) foreign key 
C) supertype 
D) subtype 
A) primary key 
B) foreign key 
C) supertype 
D) subtype

Question 14

Cascading deletions are generally not used with relationships between strong entities.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is not true about representing subtypes in a relational database design?

Accepted Answer

A) One table is created for the supertype and one for each subtype. 
B) All of the attributes of the supertype are added to the subtype relations. 
C) The key of the supertype is made the key of the subtypes. 
D) An instance of the supertype may be related to one instance each of several subtypes. 
A) One table is created for the supertype and one for each subtype. 
B) All of the attributes of the supertype are added to the subtype relations. 
C) The key of the supertype is made the key of the subtypes. 
D) An instance of the supertype may be related to one instance each of several subtypes.

Question 16

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

Accepted Answer

A) incremental updates 
B) incremental deletes 
C) cascading updates 
D) cascading deletes 
A) incremental updates 
B) incremental deletes 
C) cascading updates 
D) cascading deletes

Question 17

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

Accepted Answer

A) True 
 B)False

Question 18

A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.

Accepted Answer

A) incremental updates 
B) incremental deletes 
C) cascading updates 
D) cascading deletes 
A) incremental updates 
B) incremental deletes 
C) cascading updates 
D) cascading deletes

Question 19

Explain the pragmatic reason for using surrogate keys.

Accepted Answer

Primary keys are commonly included in in

Question 20

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 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 ternary relationship

Exam 6: Transforming Data Models Into Database Designs

When creating a relational database design from E-R diagrams,first create a relation for each relationship.

In a 1:N relationship,the term parent refers to the table on the "many" side of the relationship.

When creating a table for an ID-dependent entity,both the key of the parent and the key of the entity itself must appear in the table.

Cascading deletions are generally not used with relationships for weak child entities.

When transforming an E-R data model into a relational database design,the key of the parent entity should be placed as part of the primary key into the child entity ________.

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

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

When transforming an ID-dependent E-R data model relationship into a relational database design,the referential integrity constraints should allow ________.

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

The first step in transforming an extended E-R model into a relational database design is to ________.

Explain the representation of a one-to-many strong entity relationship in a relational database design.

When transforming an ID-dependent E-R data model relationship into a relational database design where the child entity is designed to use a surrogate key,the relationship changes to a weak but not ID-dependent relationship.

The identifier of the entity becomes the ________ of the corresponding table.

Cascading deletions are generally not used with relationships between strong entities.

Which of the following is not true about representing subtypes in a relational database design?

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

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.

Explain the pragmatic reason for using surrogate keys.

The binary constraint must not indicates that ________.

Introduction

Introduction to Structured Query Language

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

Managing Databases With SQL Server 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters