Question 1

A referential integrity constraint is used to make sure the values of a foreign key match a valid value of a primary key.

Accepted Answer

A) True 
 B)False  True

Question 2

A relation is in 4NF when multivalued dependencies are isolated in their own relation.

Accepted Answer

A) True 
 B)False  True

Question 3

A candidate key is one of a group of keys that may serve as the primary key in a relation.

Accepted Answer

A) True 
 B)False  True

Question 4

A relation is in 3NF if and only if it is in 2NF and there are no non-key attributes determined by another non-key attribute.

Accepted Answer

A) True 
 B)False

Question 5

Explain the essence of normalization that is implemented through the use of normal forms.

Accepted Answer

The essence of normalization is to creat

Question 6

Briefly describe the various tasks of the primary key.

Accepted Answer

The primary key is used for four primary

Question 7

A row can be uniquely identified by a key.

Accepted Answer

A) True 
 B)False

Question 8

A relation is in Boyce-Codd normal form (BCNF)if and only if it is in 3NF and ________.

Accepted Answer

A) all non-key attributes are determined by the entire primary key 
B) there are no non-key attributes determined by another non-key attribute 
C) every attribute is a candidate key 
D) every candidate key is a determinant 
E) every determinant is a candidate key 
A) all non-key attributes are determined by the entire primary key 
B) there are no non-key attributes determined by another non-key attribute 
C) every attribute is a candidate key 
D) every candidate key is a determinant 
E) every determinant is a candidate key

Question 9

Suppose that you need to update one value of the column SalesCost in a relation.The way the relation is constructed,this value actually needs to be changed in three different rows.However,you only change the value in two of the rows.You have just created a(n)________.

Accepted Answer

A) normalization anomaly 
B) insertion anomaly 
C) update anomaly 
D) deletion anomaly 
E) removal anomaly 
A) normalization anomaly 
B) insertion anomaly 
C) update anomaly 
D) deletion anomaly 
E) removal anomaly

Question 10

A ________ is used to limit the possible values of a foreign key.

Accepted Answer

A) composite key 
B) surrogate key 
C) functional dependency 
D) referential integrity constraint 
E) normal form 
A) composite key 
B) surrogate key 
C) functional dependency 
D) referential integrity constraint 
E) normal form

Question 11

A key consisting of one or more columns that is a primary key in another relation is a ________.

Accepted Answer

A) composite key 
B) candidate key 
C) foreign key 
D) surrogate key 
E) dependency 
A) composite key 
B) candidate key 
C) foreign key 
D) surrogate key 
E) dependency

Question 12

Undesirable consequences of changing the data in a relation are called "modification anomalies."

Accepted Answer

A) True 
 B)False

Question 13

A multivalued dependency exists when a determinant is matched to a set of values.

Accepted Answer

A) True 
 B)False

Question 14

If a table is designed so that every determinant is a candidate key,then that relation is in ________.

Accepted Answer

A) First Normal Form 
B) Second Normal Form 
C) Third Normal Form 
D) Boyce-Codd Normal Form 
E) Fourth Normal Form 
A) First Normal Form 
B) Second Normal Form 
C) Third Normal Form 
D) Boyce-Codd Normal Form 
E) Fourth Normal Form

Question 15

A tuple is also known as a ________.

Accepted Answer

A) table 
B) relation 
C) row 
D) field 
E) file 
A) table 
B) relation 
C) row 
D) field 
E) file

Question 16

Explain the concept of a surrogate key.

Accepted Answer

A surrogate key is an artificial key tha

Question 17

Given the functional dependency (A,B)→ C,then it is true that A → C and B → C.

Accepted Answer

A) True 
 B)False

Question 18

A referential integrity constraint limits the values of a foreign key.

Accepted Answer

A) True 
 B)False

Question 19

It is possible to have a relation that does not have a key.

Accepted Answer

A) True 
 B)False

Question 20

Relations are classified into "normal forms" based on the types of modification anomalies that they are vulnerable to.

Accepted Answer

A) True 
 B)False

Exam 3: The Relational Model and Normalization

A referential integrity constraint is used to make sure the values of a foreign key match a valid value of a primary key.

A relation is in 4NF when multivalued dependencies are isolated in their own relation.

A candidate key is one of a group of keys that may serve as the primary key in a relation.

A relation is in 3NF if and only if it is in 2NF and there are no non-key attributes determined by another non-key attribute.

Explain the essence of normalization that is implemented through the use of normal forms.

Briefly describe the various tasks of the primary key.

A row can be uniquely identified by a key.

A relation is in Boyce-Codd normal form (BCNF)if and only if it is in 3NF and ________.

Suppose that you need to update one value of the column SalesCost in a relation.The way the relation is constructed,this value actually needs to be changed in three different rows.However,you only change the value in two of the rows.You have just created a(n)________.

A ________ is used to limit the possible values of a foreign key.

A key consisting of one or more columns that is a primary key in another relation is a ________.

Undesirable consequences of changing the data in a relation are called "modification anomalies."

A multivalued dependency exists when a determinant is matched to a set of values.

If a table is designed so that every determinant is a candidate key,then that relation is in ________.

A tuple is also known as a ________.

Explain the concept of a surrogate key.

Given the functional dependency (A,B)→ C,then it is true that A → C and B → C.

A referential integrity constraint limits the values of a foreign key.

It is possible to have a relation that does not have a key.

Relations are classified into "normal forms" based on the types of modification anomalies that they are vulnerable to.

Introduction

Introduction to Structured Query Language SQL

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

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