Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

A characteristic of a relation is that the cells of the relation hold a single value.

Accepted Answer

A) True 
 B)False

Question 3

If a relation is in BCNF,and each multivalued dependency has been moved to a relation of its own,then the first 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 4

A relation is in Boyce-Codd Normal Form (BCNF)if and only if it is in 3NF and every determinant is a candidate key.

Accepted Answer

A) True 
 B)False

Question 5

In general,each relation should have ________.

Accepted Answer

A) one and only one theme 
B) one or more themes 
C) exactly two themes 
D) one or two themes 
E) exactly three themes 
A) one and only one theme 
B) one or more themes 
C) exactly two themes 
D) one or two themes 
E) exactly three themes

Question 6

A relation is a table composed of columns and rows.

Accepted Answer

A) True 
 B)False

Question 7

In relational terms as defined by E.F.Codd,a row is called a tuple.

Accepted Answer

A) True 
 B)False

Question 8

Explain the relationships among primary keys and functional dependencies.

Accepted Answer

Relations store instances of functional

Question 9

Explain the concept of a foreign key.

Accepted Answer

To implement a relationship within a rel

Question 10

Surrogate keys are normally not shown on forms or reports.

Accepted Answer

A) True 
 B)False

Question 11

A determinant that determines all the other columns in a relation is a ________.

Accepted Answer

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

Question 12

Given the functional dependency A → B,then it is necessarily true that B → A.

Accepted Answer

A) True 
 B)False

Question 13

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 14

An artificial column added to a relation to serve as the primary key 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 15

Distinguish between the primary key and a candidate key.

Accepted Answer

Both the primary key and a candidate key

Question 16

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 17

An attribute is considered to be a non-key attribute when it is a non-prime attribute,which means that the attribute is not contained in any candidate key.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The only reason(s)for having relations is to ________.

Accepted Answer

A) store instances of functional dependencies 
B) store equation components 
C) store equation results 
D) B and C 
E) A,B and C 
A) store instances of functional dependencies 
B) store equation components 
C) store equation results 
D) B and C 
E) A,B and C

Question 20

A relation is in domain/key normal form if ________.

Accepted Answer

A) every key of the relation is a logical consequence of the definition of constraints and determinants 
B) every key of the relation is a logical consequence of the definition of constraints and domains 
C) every constraint on the relation is a logical consequence of the definition of keys and determinants 
D) every constraint on the relation is a logical consequence of the definition of keys and domains 
E) every domain of the relation is a logical consequence of the definition of keys and constraints 
A) every key of the relation is a logical consequence of the definition of constraints and determinants 
B) every key of the relation is a logical consequence of the definition of constraints and domains 
C) every constraint on the relation is a logical consequence of the definition of keys and determinants 
D) every constraint on the relation is a logical consequence of the definition of keys and domains 
E) every domain of the relation is a logical consequence of the definition of keys and constraints

Exam 3: The Relational Model and Normalization

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

A characteristic of a relation is that the cells of the relation hold a single value.

If a relation is in BCNF,and each multivalued dependency has been moved to a relation of its own,then the first relation is in ________.

A relation is in Boyce-Codd Normal Form (BCNF)if and only if it is in 3NF and every determinant is a candidate key.

In general,each relation should have ________.

A relation is a table composed of columns and rows.

In relational terms as defined by E.F.Codd,a row is called a tuple.

Explain the relationships among primary keys and functional dependencies.

Explain the concept of a foreign key.

Surrogate keys are normally not shown on forms or reports.

A determinant that determines all the other columns in a relation is a ________.

Given the functional dependency A → B,then it is necessarily true that B → A.

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

An artificial column added to a relation to serve as the primary key is a ________.

Distinguish between the primary key and a candidate key.

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

An attribute is considered to be a non-key attribute when it is a non-prime attribute,which means that the attribute is not contained in any candidate key.

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

The only reason(s)for having relations is to ________.

A relation is in domain/key normal form if ________.

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