Question 1

A referential integrity constraint policy that guarantees that a row in a parent table always has a required entry in a child table ________.

Accepted Answer

A) is known as a minimum cardinality enforcement action 
B) needs to be documented by the database development team 
C) is enforced in most DBMS products 
D) A and B 
E) A,B,and C 
A) is known as a minimum cardinality enforcement action 
B) needs to be documented by the database development team 
C) is enforced in most DBMS products 
D) A and B 
E) A,B,and C

Question 2

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

Accepted Answer

STUDENT (StudentID,StuName,Stu

Question 3

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 4

In a 1:N relationship,the term "parent" refers to the table on the "many" side of the relationship.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

The ideal primary key is short,numeric,and fixed.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

The obvious part of the database design

Question 10

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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

In a 1:1 relationship,the foreign key is defined as an alternate key to make the DBMS enforce uniqueness.

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

All identifying relationships are 1:N.

Accepted Answer

A) True 
 B)False

Question 16

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 17

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 18

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 19

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

Accepted Answer

One-to-one recursive relationships are a

Question 20

A null value is an attribute value that has been set to zero.

Accepted Answer

A) True 
 B)False

Exam 6: Transforming Data Models Into Database Designs

A referential integrity constraint policy that guarantees that a row in a parent table always has a required entry in a child table ________.

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

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

In a 1:N relationship,the term "parent" refers to the table on the "many" side of the relationship.

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

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

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

The ideal primary key is short,numeric,and fixed.

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

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.

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

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

In a 1:1 relationship,the foreign key is defined as an alternate key to make the DBMS enforce uniqueness.

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.

All identifying relationships are 1:N.

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.

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

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

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

A null value is an attribute value that has been set to zero.

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