Question 1

The functional dependency noted as A → B means that the value of A can be determined from the value of B.

Accepted Answer

A) True 
 B)False

Question 2

A characteristic of a relation is that the rows of a relation may hold identical values.

Accepted Answer

A) True 
 B)False

Question 3

The columns of a relation are sometimes called tuples.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

Any table that meets the definition of a relation is in 2NF.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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 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 determinant is a candidate key

Question 12

Which of the following is true about the functional dependency (A, B) → (C, D)?

Accepted Answer

A) A is the determinant of C. 
B) A and B together are determined by C and D together. 
C) A and B together determine D. 
D) C and D together determine A. 
A) A is the determinant of C. 
B) A and B together are determined by C and D together. 
C) A and B together determine D. 
D) C and D together determine A.

Question 13

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

Accepted Answer

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

Question 14

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 
A) composite key 
B) surrogate key 
C) functional dependency 
D) referential integrity constraint

Question 15

A tuple is also known as a ________.

Accepted Answer

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

Question 16

When designing a database,one of the candidate keys in a relation is selected as the ________.

Accepted Answer

A) composite key 
B) primary key 
C) foreign key 
D) surrogate key 
A) composite key 
B) primary key 
C) foreign key 
D) surrogate key

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

Attribute Y is functionally dependent on attribute X if the value of attribute X determines the value of Y.

Accepted Answer

A) True 
 B)False

Question 19

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) Third Normal Form 
B) Boyce-Codd Normal Form 
C) Fourth Normal Form 
D) Domain/key normal form 
A) Third Normal Form 
B) Boyce-Codd Normal Form 
C) Fourth Normal Form 
D) Domain/key normal form

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 3: The Relational Model and Normalization

The functional dependency noted as A → B means that the value of A can be determined from the value of B.

A characteristic of a relation is that the rows of a relation may hold identical values.

The columns of a relation are sometimes called tuples.

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

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

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

Any table that meets the definition of a relation is in 2NF.

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

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

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

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

Which of the following is true about the functional dependency (A, B) → (C, D)?

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

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

A tuple is also known as a ________.

When designing a database,one of the candidate keys in a relation is selected as the ________.

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

Attribute Y is functionally dependent on attribute X if the value of attribute X determines the value of Y.

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 defining requirement for Boyce-Codd Normal Form (BCNF)is that every candidate key must be a determinant.

Introduction

Introduction to Structured Query Language

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