Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

An ID-dependent table can be used to represent multivalued attributes.

Accepted Answer

A) True 
 B)False

Question 4

A data constraint is a limitation on data values.

Accepted Answer

A) True 
 B)False

Question 5

When transforming supertype/subtype entities into a relational database design,all of the attributes for the supertype table are placed into the subtype relations.

Accepted Answer

A) True 
 B)False

Question 6

In 1:N relationships,the table on the "one" side is called the parent.

Accepted Answer

A) True 
 B)False

Question 7

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 8

To represent an N:M relationship in a relational database design,in essence it is reduced to two 1:N relationships.

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

One-to-one recursive relationships are a

Question 11

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 non-unique within a table. 
D) They can be problematic when combining databases. 
A) They are identifiers that are supplied by the system,not the users. 
B) They have no meaning to the users. 
C) They are non-unique within a table. 
D) They can be problematic when combining databases.

Question 12

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 13

Data types are consistent across all DBMS products.

Accepted Answer

A) True 
 B)False

Question 14

Association tables sometimes connect more than two entities.

Accepted Answer

A) True 
 B)False

Question 15

In representing a 1:N relationship in a relational database design,the key of the table representing the entity on the "many" side is placed as a foreign key in the table representing the entity on the "one" side of the relationship.

Accepted Answer

A) True 
 B)False

Question 16

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) Both A and B are correct 
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) Both A and B are correct

Question 17

Recursive M:N relationships are represented with an intersection table that shows pairs of related rows from a single table.

Accepted Answer

A) True 
 B)False

Question 18

The last step in creating a table is to verify table normalization.

Accepted Answer

A) True 
 B)False

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

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

Accepted Answer

A) True 
 B)False

Exam 6: Transforming Data Models Into Database Designs

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

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

An ID-dependent table can be used to represent multivalued attributes.

A data constraint is a limitation on data values.

When transforming supertype/subtype entities into a relational database design,all of the attributes for the supertype table are placed into the subtype relations.

In 1:N relationships,the table on the "one" side is called the parent.

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

To represent an N:M relationship in a relational database design,in essence it is reduced to two 1:N relationships.

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

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

Which of the following is not true about surrogate keys?

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

Data types are consistent across all DBMS products.

Association tables sometimes connect more than two entities.

In representing a 1:N relationship in a relational database design,the key of the table representing the entity on the "many" side is placed as a foreign key in the table representing the entity on the "one" side of the relationship.

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

Recursive M:N relationships are represented with an intersection table that shows pairs of related rows from a single table.

The last step in creating a table is to verify table normalization.

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.

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

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