Question 1

How are one-to-one recursive relationships addressed using the relational model?

Accepted Answer

One-to-one recursive relationships are a

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Discriminator attributes can be represented in relational designs.

Accepted Answer

A) True 
 B)False

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

Accepted Answer

A) True 
 B)False

Question 7

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 8

When transforming supertype/subtype entities into a relational database design,the key of the supertype table is placed into the subtype table typically as the key.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) the intersection table is ID-dependent on one of the parents 
B) the intersection table is ID-dependent on both of the parents 
C) the minimum cardinality from the intersection table to the parents is always M 
D) A and B 
E) B and C 
A) the intersection table is ID-dependent on one of the parents 
B) the intersection table is ID-dependent on both of the parents 
C) the minimum cardinality from the intersection table to the parents is always M 
D) A and B 
E) B and C

Question 10

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) A and B 
E) A,B and C 
A) parent updates to cascade 
B) child updates to cascade 
C) child deletes to cascade 
D) A and B 
E) A,B and C

Question 11

A foreign key is a key that does not belong in any table.

Accepted Answer

A) True 
 B)False

Question 12

Briefly describe what a final database design consists of.

Accepted Answer

The obvious part of the database design

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 
E) either A or B 
A) primary key 
B) foreign key 
C) supertype 
D) subtype 
E) either A or B

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 
E) document referential integrity constraints 
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 
E) document referential integrity constraints

Question 17

In representing a 1:N relationship in a relational database design,the key of the table representing the parent entity is placed as a foreign key in the table representing the child entity.

Accepted Answer

A) True 
 B)False

Question 18

What is an association relationship and how does it differ from an N:M relationship?

Accepted Answer

An association relationship is very simi

Question 19

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 20

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

Exam 6: Transforming Data Models Into Database Designs

How are one-to-one recursive relationships addressed using the relational model?

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

Discriminator attributes can be represented in relational designs.

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

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

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

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.

When transforming supertype/subtype entities into a relational database design,the key of the supertype table is placed into the subtype table typically as the key.

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

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

A foreign key is a key that does not belong in any table.

Briefly describe what a final database design consists of.

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

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

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

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

In representing a 1:N relationship in a relational database design,the key of the table representing the parent entity is placed as a foreign key in the table representing the child entity.

What is an association relationship and how does it differ from an N:M relationship?

Many-to-many relationships are represented by ________.

A surrogate key should be considered when ________.

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

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters