Question 1

The first step in the database design process is to create tables and columns from entities and attributes.

Accepted Answer

A) True 
 B)False

Question 2

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 3

Briefly describe the process of converting an extended E-R model into a relational database design.

Accepted Answer

To convert an extended E-R model into a

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Whether or not an attribute is required is determined during the database modeling phase.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

A) the parent entity must also use a surrogate key 
B) the relationship remains an ID-dependent relationship 
C) the relationship changes to a non-ID-dependent relationship 
D) A and B 
E) A and C 
A) the parent entity must also use a surrogate key 
B) the relationship remains an ID-dependent relationship 
C) the relationship changes to a non-ID-dependent relationship 
D) A and B 
E) A and C

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

In a supertype-subtype structure,discriminator attributes ________.

Accepted Answer

A) are easily represented in a relational design 
B) cannot be represented in a relational design 
C) require application logic to determine which subtypes correspond to a specific supertype instance 
D) A and C 
E) B and C 
A) are easily represented in a relational design 
B) cannot be represented in a relational design 
C) require application logic to determine which subtypes correspond to a specific supertype instance 
D) A and C 
E) B and C

Question 10

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 11

Recursive M:N relationships are represented with an intersection table that shows pairs of related rows from a single table.

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

All identifying relationships are 1:N.

Accepted Answer

A) True 
 B)False

Question 14

Referential integrity constraints should disallow adding a new row to a child table when the foreign key does not match a primary key value in the parent table.

Accepted Answer

A) True 
 B)False

Question 15

Explain the pragmatic reason for using surrogate keys.

Accepted Answer

Primary keys are commonly included in in

Question 16

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) A subtype and its supertype are representations of the same underlying table. 
E) 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) A subtype and its supertype are representations of the same underlying table. 
E) An instance of the supertype may be related to one instance each of several subtypes.

Question 17

To represent a one-to-many relationship in a relational database design the key of the child table is placed as a foreign key into the other table.

Accepted Answer

A) True 
 B)False

Question 18

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) controlled key adjustments 
D) cascading updates 
E) cascading deletes 
A) incremental updates 
B) incremental deletes 
C) controlled key adjustments 
D) cascading updates 
E) cascading deletes

Question 19

When transforming an extended E-R model into a relational database design,recursive relationships are treated fundamentally the same as other HAS-A relationships.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 6: Transforming Data Models Into Database Designs

The first step in the database design process is to create tables and columns from entities and attributes.

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

Briefly describe the process of converting an extended E-R model into a relational database design.

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

Whether or not an attribute is required is determined during the database modeling phase.

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 child entity is designed to use a surrogate key,then ________.

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

In a supertype-subtype structure,discriminator attributes ________.

The binary constraint MUST COVER indicates that ________.

Recursive M:N relationships are represented with an intersection table that shows pairs of related rows from a single table.

A data constraint is a limitation on data values.

All identifying relationships are 1:N.

Referential integrity constraints should disallow adding a new row to a child table when the foreign key does not match a primary key value in the parent table.

Explain the pragmatic reason for using surrogate keys.

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

To represent a one-to-many relationship in a relational database design the key of the child table is placed as a foreign key into the other table.

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

When transforming an extended E-R model into a relational database design,recursive relationships are treated fundamentally the same as other HAS-A relationships.

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.

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