Question 1

A key consisting of one or more columns that is a primary key in another relation 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 2

A relation is in 3NF if and only if it is in 2NF and there are no non-key attributes determined by another non-key attribute.

Accepted Answer

A) True 
 B)False

Question 3

A combination key is a group of attributes that uniquely identifies a row.

Accepted Answer

A) True 
 B)False

Question 4

Referential integrity constraints are used to limit the possible values of 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 5

A candidate key is one of a group of keys that may serve as the primary key in a relation.

Accepted Answer

A) True 
 B)False

Question 6

A relation is a table composed of columns and rows.

Accepted Answer

A) True 
 B)False

Question 7

A tuple is a group of one or more columns that uniquely identifies a row.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) A and B together → C 
B) A → C 
C) B → A 
D) Both A and B are correct 
A) A and B together → C 
B) A → C 
C) B → A 
D) Both A and B are correct

Question 10

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 11

Distinguish between the primary key and a candidate key.

Accepted Answer

Both the primary key and a candidate key

Question 12

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

Accepted Answer

The essence of normalization is to creat

Question 13

Briefly describe the various tasks of the primary key.

Accepted Answer

The primary key is used for four primary

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Surrogate keys are normally not shown on forms or reports.

Accepted Answer

A) True 
 B)False

Question 16

Undesirable consequences of changing the data in a relation are called modification anomalies.

Accepted Answer

A) True 
 B)False

Question 17

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 
A) normalization anomaly 
B) insertion anomaly 
C) update anomaly 
D) deletion anomaly

Question 18

A relation is in Boyce-Codd Normal Form (BCNF)if and only if it is in 3NF and every determinant is a candidate key.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

The condition that a non-key attribute determines another non-key attribute is known as transitive dependency.

Accepted Answer

A) True 
 B)False

Exam 3: The Relational Model and Normalization

A key consisting of one or more columns that is a primary key in another relation is a ________.

A relation is in 3NF if and only if it is in 2NF and there are no non-key attributes determined by another non-key attribute.

A combination key is a group of attributes that uniquely identifies a row.

Referential integrity constraints are used to limit the possible values of a ________.

A candidate key is one of a group of keys that may serve as the primary key in a relation.

A relation is a table composed of columns and rows.

A tuple is a group of one or more columns that uniquely identifies a row.

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

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

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.

Distinguish between the primary key and a candidate key.

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

Briefly describe the various tasks of the primary key.

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

Surrogate keys are normally not shown on forms or reports.

Undesirable consequences of changing the data in a relation are called 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 relation is in Boyce-Codd Normal Form (BCNF)if and only if it is in 3NF and every determinant is a candidate key.

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

The condition that a non-key attribute determines another non-key attribute is known as transitive dependency.

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