Question 1

Which of the following is not true of recursive relationships?

Accepted Answer

A) When the recursive relationship is M:N,an intersection table is created. 
B) The rows of a single table can play two different roles. 
C) Recursive relationships can be 1:1,1:N,or M:N relationships. 
D) When the relationship is 1:N,a new table must be defined to represent the relationship. 
A) When the recursive relationship is M:N,an intersection table is created. 
B) The rows of a single table can play two different roles. 
C) Recursive relationships can be 1:1,1:N,or M:N relationships. 
D) When the relationship is 1:N,a new table must be defined to represent the relationship.

Question 2

Using the VRG database as an example,briefly describe what a final database design consists of.

Accepted Answer

A final database design consists of a we

Question 3

Discriminator attributes can be represented in relational designs.

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

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 7

Which of the following is not true for an ideal primary key?

Accepted Answer

A) a composite of several long attributes 
B) numeric 
C) fixed 
D) short 
A) a composite of several long attributes 
B) numeric 
C) fixed 
D) short

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

Which of the following is not true about N:M recursive relationships?

Accepted Answer

A) Both foreign keys in the intersection table refer to the same table. 
B) Since it is a recursive relationship,an intersection table is not needed. 
C) The foreign keys in the intersection table can't refer to the same attribute in the parent table. 
D) Both B and C are correct. 
A) Both foreign keys in the intersection table refer to the same table. 
B) Since it is a recursive relationship,an intersection table is not needed. 
C) The foreign keys in the intersection table can't refer to the same attribute in the parent table. 
D) Both B and C are correct.

Question 10

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

Question 11

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

Question 12

Which of the following is not a step in the database design process?

Accepted Answer

A) Create tables and columns from entities and attributes 
B) Select primary keys 
C) Represent relationships 
D) Create constraints and triggers 
A) Create tables and columns from entities and attributes 
B) Select primary keys 
C) Represent relationships 
D) Create constraints and triggers

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Like all ID-dependent relationships,the parents of an association table are required.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

One of the important properties of a column is whether or not it can have a NULL value.

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

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

Accepted Answer

A) True 
 B)False

Question 20

An intersection table can have additional attributes besides the keys of its parent tables.

Accepted Answer

A) True 
 B)False

Exam 6: Transforming Data Models Into Database Designs

Which of the following is not true of recursive relationships?

Using the VRG database as an example,briefly describe what a final database design consists of.

Discriminator attributes can be represented in relational designs.

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

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.

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

Which of the following is not true for an ideal primary key?

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.

Which of the following is not true about N:M recursive relationships?

Many-to-many relationships are represented by ________.

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

Which of the following is not a step in the database design process?

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

Like all ID-dependent relationships,the parents of an association table are required.

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.

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

One of the important properties of a column is whether or not it can have a NULL value.

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

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

An intersection table can have additional attributes besides the keys of its parent tables.

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters