Question 1

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

Question 2

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  False

Question 3

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 cascading changes.

Accepted Answer

A) True 
 B)False  False

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

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 
E) when the child entity has a recursive 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 
E) when the child entity has a recursive relationship with the parent entity

Question 9

What are the four sets of minimum cardinalities that can be present in a 1:N binary relationship?

Accepted Answer

If we use the labels parent and child to

Question 10

The design transformation for all IS-A relationships can be summarized by the phrase "place the key of the parent table in the child table."

Accepted Answer

A) True 
 B)False

Question 11

When the parent entity is required (M)in a relationship,every row of the child table must have a valid,non-null value of the foreign key.

Accepted Answer

A) True 
 B)False

Question 12

One of the important properties of an attribute is whether or not it is required.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

To which of the following actions are referential integrity constraints not applied?

Accepted Answer

A) create 
B) insert 
C) modify 
D) delete 
E) referential integrity constraints are applied to all of the listed actions 
A) create 
B) insert 
C) modify 
D) delete 
E) referential integrity constraints are applied to all of the listed actions

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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,and 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,and method A is preferable 
E) either A or B will work,but method B is preferable

Question 18

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

Question 19

In many-to-many relationships in a relational database design the primary keys of both tables are joined into a composite primary key in the intersection table.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 6: Transforming Data Models Into Database Designs

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

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

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 cascading changes.

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.

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

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

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

What are the four sets of minimum cardinalities that can be present in a 1:N binary relationship?

The design transformation for all IS-A relationships can be summarized by the phrase "place the key of the parent table in the child table."

When the parent entity is required (M)in a relationship,every row of the child table must have a valid,non-null value of the foreign key.

One of the important properties of an attribute is whether or not it is required.

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

To which of the following actions are referential integrity constraints not applied?

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

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

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

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

In many-to-many relationships in a relational database design the primary keys of both tables are joined into a composite primary key in the intersection table.

Explain the representation of a many-to-many strong entity 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

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