Question 1

A relation is in 4NF if it is in BCNF and it has no multivalued dependencies.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

Any table that meets the definition of a relation is said to be in first normal form (1NF).

Accepted Answer

A) True 
 B)False

Question 5

A ________ is used to limit the possible values of a(n)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 6

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 7

Domain/key normal form requires that every constraint be a logical consequence of the definition of domains and keys.

Accepted Answer

A) True 
 B)False

Question 8

A defining requirement for Boyce-Codd Normal Form (BCNF)is that every candidate key must be a determinant.

Accepted Answer

A) True 
 B)False

Question 9

A combination of two or more columns used to identify particular rows in a relation is a ________.

Accepted Answer

A) record 
B) field 
C) composite key 
D) foreign key 
E) surrogate key 
A) record 
B) field 
C) composite key 
D) foreign key 
E) surrogate key

Question 10

A relation that is in domain/key normal form is assured to be free from all anomalies.

Accepted Answer

A) True 
 B)False

Question 11

If a table meets the minimum definition of a relation,it has an effective or appropriate structure.

Accepted Answer

A) True 
 B)False

Question 12

A functional dependency is a relationship between attributes such that if we know the value of one attribute,we can determine the value of the other attribute.

Accepted Answer

A) True 
 B)False

Question 13

A constraint that requires an instance of an entity to exist in one relation before it can be referenced in another relation is called an insertion anomaly.

Accepted Answer

A) True 
 B)False

Question 14

Given the functional dependency (A,B)→ C,the attributes (A,B)are referred to as a composite determinant.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Question 17

A table that meets the definition of a 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 18

In relational terms as defined by E.F.Codd,a column is called an attribute.

Accepted Answer

A) True 
 B)False

Question 19

A key can be composed of a group of attributes taken together.

Accepted Answer

A) True 
 B)False

Question 20

In functional dependencies,the attribute whose value is known or given is referred to as the determinant.

Accepted Answer

A) True 
 B)False

Exam 3: The Relational Model and Normalization

A relation is in 4NF if it is in BCNF and it has no multivalued dependencies.

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

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

Any table that meets the definition of a relation is said to be in first normal form (1NF).

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

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.

Domain/key normal form requires that every constraint be a logical consequence of the definition of domains and keys.

A defining requirement for Boyce-Codd Normal Form (BCNF)is that every candidate key must be a determinant.

A combination of two or more columns used to identify particular rows in a relation is a ________.

A relation that is in domain/key normal form is assured to be free from all anomalies.

If a table meets the minimum definition of a relation,it has an effective or appropriate structure.

A functional dependency is a relationship between attributes such that if we know the value of one attribute,we can determine the value of the other attribute.

A constraint that requires an instance of an entity to exist in one relation before it can be referenced in another relation is called an insertion anomaly.

Given the functional dependency (A,B)→ C,the attributes (A,B)are referred to as a composite determinant.

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

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

A table that meets the definition of a relation is in ________.

In relational terms as defined by E.F.Codd,a column is called an attribute.

A key can be composed of a group of attributes taken together.

In functional dependencies,the attribute whose value is known or given is referred to as the determinant.

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

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