Question 1

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 2

Given the functional dependency (A,B)→ C,then ________.

Accepted Answer

A) A → B 
B) A → C 
C) B → A 
D) B → C 
E) None of the above is correct. 
A) A → B 
B) A → C 
C) B → A 
D) B → C 
E) None of the above is correct.

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

The condition that a non-key attribute determines another non-key attribute is known as transitive dependency.

Accepted Answer

A) True 
 B)False

Question 5

A key is a combination of one or more columns that is used to identify particular rows in a relation.

Accepted Answer

A) True 
 B)False

Question 6

Referential integrity constraints are used to limit the possible values of 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 7

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

Question 8

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 9

A relation is in fourth normal form if it is in BCNF and it has no ________.

Accepted Answer

A) transitive dependencies 
B) multivalued dependencies 
C) partial dependencies 
D) deletion dependencies 
E) referential integrity conflicts 
A) transitive dependencies 
B) multivalued dependencies 
C) partial dependencies 
D) deletion dependencies 
E) referential integrity conflicts

Question 10

Surrogate keys usually slow performance.

Accepted Answer

A) True 
 B)False

Question 11

A row can be uniquely identified by a key.

Accepted Answer

A) True 
 B)False

Question 12

A foreign key is one or more columns in one relation that also is the primary key in another table.

Accepted Answer

A) True 
 B)False

Question 13

A relation is in third normal form (3NF)if and only if it is in 2NF 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 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 relation is also known as a(n)________.

Accepted Answer

A) table 
B) tuple 
C) relationship 
D) attribute 
E) field 
A) table 
B) tuple 
C) relationship 
D) attribute 
E) field

Question 16

In the functional dependency shown as A → B,B is the determinant.

Accepted Answer

A) True 
 B)False

Question 17

A tuple is also known as a(n)________.

Accepted Answer

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

Question 18

The multivalued dependency noted as A → → B,means that the value of A determines a set of values of B.

Accepted Answer

A) True 
 B)False

Question 19

What is a functional dependency? Give an example not used in the text.

Accepted Answer

We say that a functional dependency exis

Question 20

Given the functional dependency (A,B)→ C,(A,B)is a(n)________.

Accepted Answer

A) independent variable 
B) dependent variable 
C) determinant 
D) composite determinant 
E) C and D 
A) independent variable 
B) dependent variable 
C) determinant 
D) composite determinant 
E) C and D

Exam 3: The Relational Model and Normalization

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

Given the functional dependency (A,B)→ C,then ________.

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

The condition that a non-key attribute determines another non-key attribute is known as transitive dependency.

A key is a combination of one or more columns that is used to identify particular rows in a relation.

Referential integrity constraints are used to limit the possible values of a ________.

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

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

A relation is in fourth normal form if it is in BCNF and it has no ________.

Surrogate keys usually slow performance.

A row can be uniquely identified by a key.

A foreign key is one or more columns in one relation that also is the primary key in another table.

A relation is in third normal form (3NF)if and only if it is in 2NF and ________.

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

A relation is also known as a(n)________.

In the functional dependency shown as A → B,B is the determinant.

A tuple is also known as a(n)________.

The multivalued dependency noted as A → → B,means that the value of A determines a set of values of B.

What is a functional dependency? Give an example not used in the text.

Given the functional dependency (A,B)→ C,(A,B)is a(n)________.

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