Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

A constraint that requires an instance of an entity to exist in one relation before it can be referenced in another relation is called an insertion anomaly.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

An attribute is also known as a ________.

Accepted Answer

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

Question 9

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

Functional dependencies can involve groups of attributes.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Accepted Answer

We say that a functional dependency exis

Exam 3: The Relational Model and Normalization

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

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

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

A constraint that requires an instance of an entity to exist in one relation before it can be referenced in another relation is called an insertion anomaly.

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

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.

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

An attribute is also known as a ________.

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

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

In a relation ________.

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

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

Functional dependencies can involve groups of attributes.

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

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

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

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

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

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

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

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters