Question 1

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

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

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

Accepted Answer

A) True 
 B)False

Question 4

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

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

Accepted Answer

A) True 
 B)False

Question 6

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

Question 7

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

Accepted Answer

A) A → B 
B) A → C 
C) B → A 
D) B → C 
E) None of the above is correct. 
A) A → B 
B) A → C 
C) B → A 
D) B → C 
E) None of the above is correct.

Question 8

The columns of a relation are sometimes called tuples.

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

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 that entity,we can determine the value of one other entity 
D) the functional dependency will have to be removed through normalization 
E) All of the above. 
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 that entity,we can determine the value of one other entity 
D) the functional dependency will have to be removed through normalization 
E) All of the above.

Question 11

A defining requirement for Boyce-Codd Normal Form (BCNF)is that every candidate key must be a determinant.

Accepted Answer

A) True 
 B)False

Question 12

A table that meets the definition of a relation is in ________.

Accepted Answer

A) First Normal Form 
B) Second Normal Form 
C) Third Normal Form 
D) Boyce-Codd Normal Form 
E) Fourth Normal Form 
A) First Normal Form 
B) Second Normal Form 
C) Third Normal Form 
D) Boyce-Codd Normal Form 
E) Fourth Normal Form

Question 13

A relation is also known as a(n)________.

Accepted Answer

A) table 
B) tuple 
C) relationship 
D) attribute 
E) field 
A) table 
B) tuple 
C) relationship 
D) attribute 
E) field

Question 14

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) has no two identical rows 
E) All of the above. 
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) has no two identical rows 
E) All of the above.

Question 15

Given the functional dependency (A,B)→ C,(A,B)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

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 17

A functional dependency is a relationship between attributes such that if we know the value of one attribute,we can determine the value of the other attribute.

Accepted Answer

A) True 
 B)False

Question 18

A relation is in 2NF if and only if it is in 1NF and all non-key attributes are determined by the entire primary key.

Accepted Answer

A) True 
 B)False

Question 19

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 20

When designing a database,one of the candidate keys in a relation is selected as the ________.

Accepted Answer

A) composite key 
B) primary key 
C) foreign key 
D) surrogate key 
E) dependency 
A) composite key 
B) primary key 
C) foreign key 
D) surrogate key 
E) dependency

Exam 3: The Relational Model and Normalization

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

Explain the terms relation,tuple,and attribute.

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

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

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

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

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

The columns of a relation are sometimes called tuples.

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

Saying that two entities are functionally dependent means that ________.

A defining requirement for Boyce-Codd Normal Form (BCNF)is that every candidate key must be a determinant.

A table that meets the definition of a relation is in ________.

A relation is also known as a(n)________.

A relation ________.

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

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

A functional dependency is a relationship between attributes such that if we know the value of one attribute,we can determine the value of the other attribute.

A relation is in 2NF if and only if it is in 1NF and all non-key attributes are determined by the entire primary key.

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.

When designing a database,one of the candidate keys in a relation is selected as the ________.

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