Question 1

Functional dependencies can involve groups of attributes.

Accepted Answer

A) True 
 B)False

Question 2

Explain the terms relation,tuple,and attribute.

Accepted Answer

The terms relation,tuple,and attribute a

Question 3

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

Question 4

If by knowing the value of A we can find the value of B,then we would say that B is functionally dependent on A.

Accepted Answer

A) True 
 B)False

Question 5

A primary key is a candidate key that has been selected to uniquely identify rows in a relation.

Accepted Answer

A) True 
 B)False

Question 6

An attribute is also known as a ________.

Accepted Answer

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

Question 7

Which of the following is true for a relation?

Accepted Answer

A) Entities in a column vary as to kind. 
B) The order of the columns is important. 
C) The order of the rows is unimportant. 
D) More than one column can use the same name. 
A) Entities in a column vary as to kind. 
B) The order of the columns is important. 
C) The order of the rows is unimportant. 
D) More than one column can use the same name.

Question 8

A determinant of a functional dependency may or may not be unique in a relation.

Accepted Answer

A) True 
 B)False

Question 9

Domain/key normal form requires that every constraint be a logical consequence of the definition of domains and keys.

Accepted Answer

A) True 
 B)False

Question 10

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 
A) transitive dependencies 
B) multivalued dependencies 
C) partial dependencies 
D) deletion dependencies

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Question 13

A relation is in domain/key normal form if ________.

Accepted Answer

A) every key of the relation is a logical consequence of the definition of constraints and determinants 
B) every key of the relation is a logical consequence of the definition of constraints and domains 
C) every constraint on the relation is a logical consequence of the definition of keys and determinants 
D) every constraint on the relation is a logical consequence of the definition of keys and domains 
A) every key of the relation is a logical consequence of the definition of constraints and determinants 
B) every key of the relation is a logical consequence of the definition of constraints and domains 
C) every constraint on the relation is a logical consequence of the definition of keys and determinants 
D) every constraint on the relation is a logical consequence of the definition of keys and domains

Question 14

Explain the relationships among primary keys and functional dependencies.

Accepted Answer

Relations store instances of functional

Question 15

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 
A) First Normal Form 
B) Second Normal Form 
C) Third Normal Form 
D) Boyce-Codd Normal Form

Question 16

Explain the steps in the process of putting a relation straight into Boyce-Codd Normal Form (BCNF).

Accepted Answer

The steps are:
(1) Identify all function

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) dependent variable 
B) determinant 
C) composite determinant 
D) Both B and C are correct 
A) dependent variable 
B) determinant 
C) composite determinant 
D) Both B and C are correct

Exam 3: The Relational Model and Normalization

Functional dependencies can involve groups of attributes.

Explain the terms relation,tuple,and attribute.

Saying that two entities are functionally dependent means that ________.

If by knowing the value of A we can find the value of B,then we would say that B is functionally dependent on A.

A primary key is a candidate key that has been selected to uniquely identify rows in a relation.

An attribute is also known as a ________.

Which of the following is true for a relation?

A determinant of a functional dependency may or may not be unique in a relation.

Domain/key normal form requires that every constraint be a logical consequence of the definition of domains and keys.

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

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

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

A relation is in domain/key normal form if ________.

Explain the relationships among primary keys and functional dependencies.

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

Explain the steps in the process of putting a relation straight into Boyce-Codd Normal Form (BCNF).

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

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

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

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

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