Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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

Question 3

To represent an IS-A relationship in a relational database design,the IS-A relationship must be converted into a HAS-A relationship.

Accepted Answer

A) True 
 B)False  False

Question 4

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 5

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

Question 6

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

Accepted Answer

A) True 
 B)False

Question 7

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 8

The values of a surrogate key have no meaning to the users.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

Which of the following is not true about a NULL attribute?

Accepted Answer

A) On insertion,entering the data for that field is optional. 
B) It is an important property of an attribute. 
C) It must have a default value specified. 
D) A primary key can't be NULL. 
A) On insertion,entering the data for that field is optional. 
B) It is an important property of an attribute. 
C) It must have a default value specified. 
D) A primary key can't be NULL.

Question 12

When the child entity is required (M)in a relationship,there needs to be at least one child row for each parent row at all times.

Accepted Answer

A) True 
 B)False

Question 13

All identifying relationships are 1:N.

Accepted Answer

A) True 
 B)False

Question 14

Write the database table design to represent the data model below,including tables,the proper placement of the foreign key,and referential integrity constraint.

Accepted Answer

STUDENT (StudentID,StuN

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

In many-to-many relationships 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) the keys of both tables are placed in a third table 
D) the keys of both entity tables are placed in each other 
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) the keys of both tables are placed in a third table 
D) the keys of both entity tables are placed in each other

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

What is an association relationship and how does it differ from an N:M relationship?

Accepted Answer

An association relationship is very simi

Question 20

In 1:N relationships,the table on the "many" side is called the child.

Accepted Answer

A) True 
 B)False

Exam 6: Transforming Data Models Into Database Designs

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

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

To represent an IS-A relationship in a relational database design,the IS-A relationship must be converted into a HAS-A relationship.

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.

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

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

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

The values of a surrogate key have no meaning to the users.

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

When representing a 1:1 relationship in a relational database design,________.

Which of the following is not true about a NULL attribute?

When the child entity is required (M)in a relationship,there needs to be at least one child row for each parent row at all times.

All identifying relationships are 1:N.

Write the database table design to represent the data model below,including tables,the proper placement of the foreign key,and referential integrity constraint.

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

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.

In many-to-many relationships in a relational database design,________.

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

What is an association relationship and how does it differ from an N:M relationship?

In 1:N relationships,the table on the "many" side is called the child.

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