Question 1

In 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 
E) All of the above. 
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 
E) All of the above.

Question 2

A referential integrity constraint limits the values of a foreign key.

Accepted Answer

A) True 
 B)False

Question 3

Functional dependencies can involve groups of attributes.

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

Explain the terms relation,tuple,and attribute.

Accepted Answer

The terms relation,tuple,and attribute a

Question 7

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 
E) every domain of the relation is a logical consequence of the definition of keys and constraints 
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 
E) every domain of the relation is a logical consequence of the definition of keys and constraints

Question 8

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

A surrogate key is an artificial column that is added to a relation to be its primary key.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) record 
B) field 
C) key 
D) tuple 
E) dependency 
A) record 
B) field 
C) key 
D) tuple 
E) dependency

Question 13

In general,each relation should have ________.

Accepted Answer

A) one and only one theme 
B) one or more themes 
C) exactly two themes 
D) one or two themes 
E) exactly three themes 
A) one and only one theme 
B) one or more themes 
C) exactly two themes 
D) one or two themes 
E) exactly three themes

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Explain the concept of a surrogate key.

Accepted Answer

A surrogate key is an artificial key tha

Question 18

Explain the essence of normalization that is implemented through the use of normal forms.

Accepted Answer

The essence of normalization is to creat

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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 functiona

Exam 3: The Relational Model and Normalization

In a relation ________.

A referential integrity constraint limits the values of a foreign key.

Functional dependencies can involve groups of attributes.

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

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

Explain the terms relation,tuple,and attribute.

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

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

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

A surrogate key is an artificial column that is added to a relation to be its primary key.

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

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

In general,each relation should have ________.

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 characteristic of a relation is that the cells of the relation hold a single value.

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

Explain the concept of a surrogate key.

Explain the essence of normalization that is implemented through the use of normal forms.

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

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

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