Question 1

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 2

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. 
E) A determines B. 
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. 
E) A determines B.

Question 3

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 4

Every time we break up a relation during the normalization process,we may have to create a referential integrity constraint.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Describe the requirements that a table must meet to qualify as a relation.

Accepted Answer

In order for a table to meet the require

Question 7

A relation is a three-dimensional table.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

Surrogate keys usually slow performance.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

A relation can have only one candidate key.

Accepted Answer

A) True 
 B)False

Question 15

A relation is in second normal form (2NF)if and only if it is in 1NF 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 16

Which of the following is true about the functional dependency A → (X,Y)?

Accepted Answer

A) X is functionally dependent on A. 
B) A determines Y. 
C) A is a determinant. 
D) X and Y are functionally dependent on A. 
E) All of the above. 
A) X is functionally dependent on A. 
B) A determines Y. 
C) A is a determinant. 
D) X and Y are functionally dependent on A. 
E) All of the above.

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Normalization is a process used to deal with which of the following modification anomalies?

Accepted Answer

A) Insertion anomaly 
B) Update anomaly 
C) Deletion anomaly 
D) A and B 
E) A,B and C 
A) Insertion anomaly 
B) Update anomaly 
C) Deletion anomaly 
D) A and B 
E) A,B and C

Question 19

If the removal of facts about one entity results in the unintentional loss of data about another entity,this is referred to as 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 20

A deletion anomaly exists when deleting data about one entity results in the loss of data about another entity.

Accepted Answer

A) True 
 B)False

Exam 3: The Relational Model and Normalization

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

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

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

Every time we break up a relation during the normalization process,we may have to create a referential integrity constraint.

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

Describe the requirements that a table must meet to qualify as a relation.

A relation is a three-dimensional table.

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

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

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

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

Surrogate keys usually slow performance.

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

A relation can have only one candidate key.

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

Which of the following is true about the functional dependency A → (X,Y)?

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

Normalization is a process used to deal with which of the following modification anomalies?

If the removal of facts about one entity results in the unintentional loss of data about another entity,this is referred to as a(n)________.

A deletion anomaly exists when deleting data about one entity results in the loss of data about another entity.

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