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

When representing a 1:1 relationship in a relational database design,________.

Accepted Answer

A) the key of each table must be placed as foreign keys into the other 
B) the key of either table may be placed as a foreign key into the other 
C) the key of both tables must be the same 
D) the intersection table gets the key from both relations 
E) B and C 
A) the key of each table must be placed as foreign keys into the other 
B) the key of either table may be placed as a foreign key into the other 
C) the key of both tables must be the same 
D) the intersection table gets the key from both relations 
E) B and C

Question 3

A surrogate key is a unique,system-supplied identifier used as the primary key of a table.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) primary key 
B) foreign key 
C) supertype 
D) subtype 
E) either A or B 
A) primary key 
B) foreign key 
C) supertype 
D) subtype 
E) either A or B

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

When the parent entity has a surrogate key,the enforcement actions are the same for both parent and child.

Accepted Answer

A) True 
 B)False

Question 7

By default,the identifier of the entity becomes the foreign key of the corresponding table.

Accepted Answer

A) True 
 B)False

Question 8

Many-to-many relationships are represented by ________.

Accepted Answer

A) two tables with an M:N relationship 
B) two tables with a 1:N relationship 
C) an intersection table which has M:N relationships with the two tables 
D) an intersection table which has 1:N relationships with the two tables 
E) two intersection tables which each have 1:N relationships with the two tables 
A) two tables with an M:N relationship 
B) two tables with a 1:N relationship 
C) an intersection table which has M:N relationships with the two tables 
D) an intersection table which has 1:N relationships with the two tables 
E) two intersection tables which each have 1:N relationships with the two tables

Question 9

Each attribute of an entity becomes a(n)________ of a table.

Accepted Answer

A) column 
B) primary key 
C) foreign key 
D) alternate key 
E) B or D 
A) column 
B) primary key 
C) foreign key 
D) alternate key 
E) B or D

Question 10

When transforming supertype/subtype entities into a relational database design,all of the attributes for the supertype table are placed into the subtype relations.

Accepted Answer

A) True 
 B)False

Question 11

When transforming an ID-dependent E-R data model relationship into a relational database design and the parent entity has a surrogate primary key and the child entity has a data identifier,then the primary key of the child table should be ________.

Accepted Answer

A) the parent's surrogate key + the child's data key 
B) the parent's surrogate key + a surrogate key in the child 
C) either A or B will work,and neither way is preferable 
D) either A or B will work,but method A is preferable 
E) either A or B will work,but method B is preferable 
A) the parent's surrogate key + the child's data key 
B) the parent's surrogate key + a surrogate key in the child 
C) either A or B will work,and neither way is preferable 
D) either A or B will work,but method A is preferable 
E) either A or B will work,but method B is preferable

Question 12

The last step in creating a table is to verify table normalization.

Accepted Answer

A) True 
 B)False

Question 13

An intersection table is always ID-dependent on both of its parent tables.

Accepted Answer

A) True 
 B)False

Question 14

The key of an intersection table is always the combination of the keys of both parents.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

Many-to-many relationships cannot be dir

Question 16

An ID-dependent table can be used to represent multivalued attributes.

Accepted Answer

A) True 
 B)False

Question 17

What are MUST NOT and MUST COVER constraints?

Accepted Answer

Both MUST NOT and MUST COVER constraints

Question 18

When the key of one table is placed into a second table to represent a relationship,the key is called a "relational key" in the second table.

Accepted Answer

A) True 
 B)False

Question 19

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

Accepted Answer

A) True 
 B)False

Question 20

To represent a one-to-many relationship 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) an intersection table must be created 
D) the key of the table on the "many" side is placed in the table on the "one" side 
E) the keys of both tables are joined into a composite key 
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) an intersection table must be created 
D) the key of the table on the "many" side is placed in the table on the "one" side 
E) the keys of both tables are joined into a composite key

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.

When representing a 1:1 relationship in a relational database design,________.

A surrogate key is a unique,system-supplied identifier used as the primary key of a table.

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

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

When the parent entity has a surrogate key,the enforcement actions are the same for both parent and child.

By default,the identifier of the entity becomes the foreign key of the corresponding table.

Many-to-many relationships are represented by ________.

Each attribute of an entity becomes a(n)________ of a table.

When transforming supertype/subtype entities into a relational database design,all of the attributes for the supertype table are placed into the subtype relations.

When transforming an ID-dependent E-R data model relationship into a relational database design and the parent entity has a surrogate primary key and the child entity has a data identifier,then the primary key of the child table should be ________.

The last step in creating a table is to verify table normalization.

An intersection table is always ID-dependent on both of its parent tables.

The key of an intersection table is always the combination of the keys of both parents.

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

An ID-dependent table can be used to represent multivalued attributes.

What are MUST NOT and MUST COVER constraints?

When the key of one table is placed into a second table to represent a relationship,the key is called a "relational key" in the second table.

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

To represent a one-to-many relationship in a relational database design,________.

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