Question 1

A row can be uniquely identified by a key.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

We say that a functional dependency exis

Question 3

A relation can have only one candidate key.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Explain the concept of a foreign key.

Accepted Answer

To implement a relationship within a rel

Question 6

Which of the following is not true about 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) Can have two identical rows 
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) Can have two identical rows

Question 7

Explain the concept of a surrogate key.

Accepted Answer

A surrogate key is an artificial key tha

Question 8

Candidate keys are called interlocking candidate keys when they share one or more attributes.

Accepted Answer

A) True 
 B)False

Question 9

A key can be composed of a group of attributes taken together.

Accepted Answer

A) True 
 B)False

Question 10

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 a(n)________.

Accepted Answer

A) normalization anomaly 
B) insertion anomaly 
C) update anomaly 
D) deletion anomaly 
A) normalization anomaly 
B) insertion anomaly 
C) update anomaly 
D) deletion anomaly

Question 11

Having to enter facts about two entities when we want to enter facts about only one is an example of ________.

Accepted Answer

A) insertion anomaly 
B) update anomaly 
C) deletion anomaly 
D) normalization anomaly 
A) insertion anomaly 
B) update anomaly 
C) deletion anomaly 
D) normalization anomaly

Question 12

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

Question 13

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

A) X is functionally dependent on A. 
B) A determines Y. 
C) X and Y together determine A. 
D) X and Y are functionally dependent on A. 
A) X is functionally dependent on A. 
B) A determines Y. 
C) X and Y together determine A. 
D) X and Y are functionally dependent on A.

Question 18

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 19

When designing or normalizing relations,each relation should have only one theme.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 3: The Relational Model and Normalization

A row can be uniquely identified by a key.

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

A relation can have only one candidate key.

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

Explain the concept of a foreign key.

Which of the following is not true about a relation?

Explain the concept of a surrogate key.

Candidate keys are called interlocking candidate keys when they share one or more attributes.

A key can be composed of a group of attributes taken together.

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 a(n)________.

Having to enter facts about two entities when we want to enter facts about only one is an example of ________.

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

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

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

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

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

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

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

When designing or normalizing relations,each relation should have only one theme.

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

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