Question 1

A multivalued dependency exists when a determinant is matched to a set of values.

Accepted Answer

A) True 
 B)False

Question 2

A relation is in 4NF when multivalued dependencies are isolated in their own relation.

Accepted Answer

A) True 
 B)False

Question 3

Given the functional dependency A → (B,C),A 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

Question 4

Suppose that you need to update one value of the column SalesCost in a relation.The way the relation is constructed,this value actually needs to be changed in three different rows.However,you only change the value in two of the rows.You have just created an 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 5

It is possible to have a relation that does not have a key.

Accepted Answer

A) True 
 B)False

Question 6

A relation ________.

Accepted Answer

A) has rows containing data about an entity 
B) has columns containing data about attributes of the entity 
C) has cells that hold only a single value 
D) has no two identical rows 
E) All of the above. 
A) has rows containing data about an entity 
B) has columns containing data about attributes of the entity 
C) has cells that hold only a single value 
D) has no two identical rows 
E) All of the above.

Question 7

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 8

A relation is a table composed of columns and rows.

Accepted Answer

A) True 
 B)False

Question 9

All relations are tables,but not all tables are relations.

Accepted Answer

A) True 
 B)False

Question 10

Surrogate keys are normally not shown on forms or reports.

Accepted Answer

A) True 
 B)False

Question 11

The essence of normalization is taking a relation that is not in BCNF and breaking it into multiple relations such that each one is in BCNF.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

A relation is a three-dimensional table.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Saying that two entities are functionally dependent means that ________.

Accepted Answer

A) the entities are always connected by a mathematical equation 
B) for one of the entities,if we are given the value of that entity,we can determine the value of one other entity 
C) for both of the entities,if we are given the value of one entity,we can determine the value of the other entity 
D) the functional dependency will have to be removed through normalization 
E) All of the above. 
A) the entities are always connected by a mathematical equation 
B) for one of the entities,if we are given the value of that entity,we can determine the value of one other entity 
C) for both of the entities,if we are given the value of one entity,we can determine the value of the other entity 
D) the functional dependency will have to be removed through normalization 
E) All of the above.

Question 17

A relation can have only one candidate key.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 
E) dependency 
A) composite key 
B) primary key 
C) foreign key 
D) surrogate key 
E) dependency

Question 20

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

Exam 3: The Relational Model and Normalization

A multivalued dependency exists when a determinant is matched to a set of values.

A relation is in 4NF when multivalued dependencies are isolated in their own relation.

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

Suppose that you need to update one value of the column SalesCost in a relation.The way the relation is constructed,this value actually needs to be changed in three different rows.However,you only change the value in two of the rows.You have just created an a(n)________.

It is possible to have a relation that does not have a key.

A relation ________.

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

A relation is a table composed of columns and rows.

All relations are tables,but not all tables are relations.

Surrogate keys are normally not shown on forms or reports.

The essence of normalization is taking a relation that is not in BCNF and breaking it into multiple relations such that each one is in BCNF.

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

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

A relation is a three-dimensional table.

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

Saying that two entities are functionally dependent means that ________.

A relation can have only one candidate key.

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

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

An attribute is also known as 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