Question 1

In a relational database design,all relationships are expressed by creating a foreign key.

Accepted Answer

A) True 
 B)False

Question 2

Discriminator attributes can be represented in relational designs.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 5

To represent a 1:1 binary relationship in a relational database design,the key of one table is placed into the second table.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Each entity in the extended E-R model is represented as a table in the relational database design.

Accepted Answer

A) True 
 B)False

Question 8

A default value is the value the user enters into the row the first time the user enters data.

Accepted Answer

A) True 
 B)False

Question 9

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 10

To represent an M:N relationship in a relational database design,an intersection table is created.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Which of the following is not true about surrogate keys?

Accepted Answer

A) They are identifiers that are supplied by the system,not the users. 
B) They have no meaning to the users. 
C) They are nonunique within a table. 
D) They can be problematic when combining databases. 
E) The DBMS will not allow their values to be changed. 
A) They are identifiers that are supplied by the system,not the users. 
B) They have no meaning to the users. 
C) They are nonunique within a table. 
D) They can be problematic when combining databases. 
E) The DBMS will not allow their values to be changed.

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

When transforming supertype/subtype entities into a relational database design,an entity is created for the supertype only.

Accepted Answer

A) True 
 B)False

Question 18

It is easy to enforce the referential integrity actions for M-M relationships.

Accepted Answer

A) True 
 B)False

Question 19

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 20

Which of the following is not true of ternary relationships?

Accepted Answer

A) Can be treated as a collection of binary relationships 
B) Are represented in the same way as binary relationships 
C) Must involve at least one M:N relationship 
D) Involve three entities of different logical types 
E) Often require documentation of special considerations as business rules 
A) Can be treated as a collection of binary relationships 
B) Are represented in the same way as binary relationships 
C) Must involve at least one M:N relationship 
D) Involve three entities of different logical types 
E) Often require documentation of special considerations as business rules

Exam 6: Transforming Data Models Into Database Designs

In a relational database design,all relationships are expressed by creating a foreign key.

Discriminator attributes can be represented in relational designs.

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.

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.

To represent a 1:1 binary relationship in a relational database design,the key of one table is placed into the second table.

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

Each entity in the extended E-R model is represented as a table in the relational database design.

A default value is the value the user enters into the row the first time the user enters data.

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

To represent an M:N relationship in a relational database design,an intersection table is created.

In a supertype-subtype structure,discriminator attributes ________.

Which of the following is not true about surrogate keys?

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.

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

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 supertype/subtype entities into a relational database design,an entity is created for the supertype only.

It is easy to enforce the referential integrity actions for M-M relationships.

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

Which of the following is not true of ternary relationships?

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