Question 1

To represent a relationship in the relational model,the primary key of one relation is placed into a second relation.

Accepted Answer

A) True 
 B)False

Question 2

In Microsoft Access,relationships between tables are built in the ________.

Accepted Answer

Relationsh

Question 3

The first step of the normalization process is to:

Accepted Answer

A)  identify all the candidate keys of a relation. 
B)  identify all the foreign keys of a relation. 
C)  identify all the functional dependencies of a relation. 
D)  identify all the determinants of a relation. 
E)  split the relation into two or more new relations. 
A)  identify all the candidate keys of a relation. 
B)  identify all the foreign keys of a relation. 
C)  identify all the functional dependencies of a relation. 
D)  identify all the determinants of a relation. 
E)  split the relation into two or more new relations.

Question 4

Surrogate key values have no meaning to the users.

Accepted Answer

A) True 
 B)False

Question 5

Normalization is the process of removing all functional dependencies from a relation.

Accepted Answer

A) True 
 B)False

Question 6

A table that meets the requirements of a relation is said to be in which normal form?

Accepted Answer

A)  Relational normal form (RNF) 
B)  First normal form 
C)  Second normal form 
D)  Boyce-Codd normal form 
E)  Domain/key normal form 
A)  Relational normal form (RNF) 
B)  First normal form 
C)  Second normal form 
D)  Boyce-Codd normal form 
E)  Domain/key normal form

Question 7

A candidate key is:

Accepted Answer

A)  required to be unique. 
B)  used to represent rows in relationships. 
C)  a candidate to be the primary key. 
D)  Both A and B 
E)  All of the above 
A)  required to be unique. 
B)  used to represent rows in relationships. 
C)  a candidate to be the primary key. 
D)  Both A and B 
E)  All of the above

Question 8

What are the basic steps of the normalization process?

Accepted Answer

Before starting the normalization proces

Question 9

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

Accepted Answer

functional

Question 10

In the normalization process,if you find that every determinant in a relation is a candidate key,then you have determined that the relation is well formed.

Accepted Answer

A) True 
 B)False

Question 11

Candidate keys may or may not be unique.

Accepted Answer

A) True 
 B)False

Question 12

What is normalization?

Accepted Answer

Normalization is a process whereby relat

Question 13

What requirements must a two-dimensional table satisfy in order to be a relation?

Accepted Answer

For a table to be considered a relation,

Question 14

Since Microsoft Access is a personal database,it is not subject to the modification problems that occur in other relational databases.

Accepted Answer

A) True 
 B)False

Question 15

When the primary key of one relation is placed in a second relation to represent a relationship,the attribute in the second relation is called a(n)________ key.

Accepted Answer

The answer of When the primary key of one relation...

Question 16

One important relational design principle is that:

Accepted Answer

A)  every determinant must be a candidate key. 
B)  every candidate key must not be a determinant. 
C)  every primary key must be a surrogate key. 
D)  every determinant must be functionally dependent on the primary key. 
E)  every primary key must be functionally dependent on every determinant. 
A)  every determinant must be a candidate key. 
B)  every candidate key must not be a determinant. 
C)  every primary key must be a surrogate key. 
D)  every determinant must be functionally dependent on the primary key. 
E)  every primary key must be functionally dependent on every determinant.

Question 17

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called:

Accepted Answer

A)  normalization. 
B)  a referential integrity constraint. 
C)  a key matching constraint. 
D)  a functional dependency. 
E)  synchronization. 
A)  normalization. 
B)  a referential integrity constraint. 
C)  a key matching constraint. 
D)  a functional dependency. 
E)  synchronization.

Question 18

A key must be unique.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is true about a relation?

Accepted Answer

A)  The order of the columns in a relation must go from largest to smallest. 
B)  All entries in any column must be of the same kind. 
C)  A relation may have duplicate column names. 
D)  A relation may have duplicate rows. 
E)  A relation may have multiple names. 
A)  The order of the columns in a relation must go from largest to smallest. 
B)  All entries in any column must be of the same kind. 
C)  A relation may have duplicate column names. 
D)  A relation may have duplicate rows. 
E)  A relation may have multiple names.

Question 20

In Microsoft Access,the relationship between two tables is not actually created until:

Accepted Answer

A)  the OK button in the Create Relationships dialog box is clicked. 
B)  the Create button in the Create Relationships dialog box is clicked. 
C)  the OK button in the Edit Relationships dialog box is clicked. 
D)  the Create button in the Edit Relationships dialog box is clicked. 
E)  the Join button in the Edit Relationships dialog box is clicked. 
A)  the OK button in the Create Relationships dialog box is clicked. 
B)  the Create button in the Create Relationships dialog box is clicked. 
C)  the OK button in the Edit Relationships dialog box is clicked. 
D)  the Create button in the Edit Relationships dialog box is clicked. 
E)  the Join button in the Edit Relationships dialog box is clicked.

To represent a relationship in the relational model,the primary key of one relation is placed into a second relation.

In Microsoft Access,relationships between tables are built in the ________.

The first step of the normalization process is to:

Surrogate key values have no meaning to the users.

Normalization is the process of removing all functional dependencies from a relation.

A table that meets the requirements of a relation is said to be in which normal form?

A candidate key is:

What are the basic steps of the normalization process?

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

In the normalization process,if you find that every determinant in a relation is a candidate key,then you have determined that the relation is well formed.

Candidate keys may or may not be unique.

What is normalization?

What requirements must a two-dimensional table satisfy in order to be a relation?

Since Microsoft Access is a personal database,it is not subject to the modification problems that occur in other relational databases.

When the primary key of one relation is placed in a second relation to represent a relationship,the attribute in the second relation is called a(n)________ key.

One important relational design principle is that:

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called:

A key must be unique.

Which of the following is true about a relation?

In Microsoft Access,the relationship between two tables is not actually created until:

Getting Started

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 2: The Relational Model

To represent a relationship in the relational model,the primary key of one relation is placed into a second relation.

In Microsoft Access,relationships between tables are built in the ________.

The first step of the normalization process is to:

Surrogate key values have no meaning to the users.

Normalization is the process of removing all functional dependencies from a relation.

A table that meets the requirements of a relation is said to be in which normal form?

A candidate key is:

What are the basic steps of the normalization process?

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

In the normalization process,if you find that every determinant in a relation is a candidate key,then you have determined that the relation is well formed.

Candidate keys may or may not be unique.

What is normalization?

What requirements must a two-dimensional table satisfy in order to be a relation?

Since Microsoft Access is a personal database,it is not subject to the modification problems that occur in other relational databases.

When the primary key of one relation is placed in a second relation to represent a relationship,the attribute in the second relation is called a(n)________ key.

One important relational design principle is that:

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called:

A key must be unique.

Which of the following is true about a relation?

In Microsoft Access,the relationship between two tables is not actually created until:

Getting Started

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters