Question 1

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 2

When the primary key of one relation is placed into a second relation,it is called a ________.

Accepted Answer

A)   field key
B)   referential integrity
C)   foreign key
D)   candidate key
E)   relocated keyF) C) and E)
G) A) and C)

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 relationsF) A) and C)
G) B) and C)

Question 4

Briefly describe the various tasks of the primary key.

Accepted Answer

The primary key is used for four primary...

Question 5

In SQL Server,the starting value of a surrogate key is called the ________.

Accepted Answer

A)   identity
B)   identity increment
C)   identity Start
D)   identity Seed
E)   identity propertyF) C) and D)
G) D) and E)

Question 6

The primary key is used both to identify unique rows in a relation and to represent rows in relationships.

Accepted Answer

A) True 
 B)False

Question 7

In Microsoft Access,referential integrity constraints are created in the ________.

Accepted Answer

Edit Relat...

Question 8

In Microsoft Access,a relationship between two tables is created ________.

Accepted Answer

A)   by entering the name of the foreign key in the appropriate table in Design View
B)   by entering the name of the primary key in the appropriate table in Design View
C)   by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window
D)   by dragging the foreign key column of one table onto the primary key column of the other table in the Relationships window
E)   by dragging the primary key column of one table onto the primary key column of the other table in the Relationships windowF) D) and E)
G) B) and E)

Question 9

What are the basic steps of the normalization process?

Accepted Answer

Before starting the normalization proces...

Question 10

Every table is a relation,but not every relation is a table.

Accepted Answer

A) True 
 B)False

Question 11

In Microsoft Access,relationships between tables are created in the Relationships window.

Accepted Answer

A) True 
 B)False

Question 12

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 13

Explain how to create a relationship in Microsoft Access.

Accepted Answer

In Microsoft Access,relationships are cr...

Question 14

In the normalization process,if you find a candidate key that is not a primary key then you should ________.

Accepted Answer

A)   place the columns of the functional dependency in a new relation
B)   make the determinant of the functional dependency the primary key of the new relation
C)   leave a copy of the determinant as a foreign key in the original relation
D)   remove the determinant from the original relation
E)   None of the aboveF) B) and E)
G) A) and C)

Question 15

A(n)________ is a unique,numeric value that is appended to the relation to serve as the primary key.

Accepted Answer

The answer of A(n)________ is a unique,numeric value that is...

Question 16

Null values can cause problems because they are ambiguous.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not true about a relation?

Accepted Answer

A)   A relation is a two-dimensional table.
B)   The cells of a relation must hold a single value.
C)   A relation may have duplicate column names.
D)   A relation may not have duplicate rows.
E)   The order of the rows of a relation is insignificant.F) B) and D)
G) A) and E)

Question 18

The first step of the normalization process is to identify all the candidate keys of a relation.

Accepted Answer

A) True 
 B)False

Question 19

In the relational model,each row of a table contains data that represents an attribute of the entity.

Accepted Answer

A) True 
 B)False

Question 20

A rule that requires every value in a foreign key to match values in the corresponding primary key is called a(n)________ constraint.

Accepted Answer

referentia...

Exam 2: The Relational Model

In Microsoft Access,relationships between tables are created in the Relationships window.

Correct AnswerverifiedShow Answer

Explain how to create a relationship in Microsoft Access.

Correct AnswerverifiedIn Microsoft Access,relationships are cr...View AnswerShow Answer

In Microsoft Access,referential integrity constraints are created in the ________.

Correct AnswerverifiedEdit Relat...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

In the relational model,each row of a table contains data that represents an attribute of the entity.

Correct AnswerverifiedShow Answer

The first step of the normalization process is to identify all the candidate keys of a relation.

Correct AnswerverifiedShow Answer

What are the basic steps of the normalization process?

Correct AnswerverifiedBefore starting the normalization proces...View AnswerShow Answer

A(n)________ is a unique,numeric value that is appended to the relation to serve as the primary key.

Correct AnswerverifiedShow Answer

The primary key is used both to identify unique rows in a relation and to represent rows in relationships.

Correct AnswerverifiedShow Answer

In Microsoft Access,a relationship between two tables is created ________.

Correct AnswerverifiedShow Answer

Null values can cause problems because they are ambiguous.

Correct AnswerverifiedShow Answer

When the primary key of one relation is placed into a second relation,it is called a ________.

Correct AnswerverifiedShow Answer

The first step of the normalization process is to ________.

Correct AnswerverifiedShow Answer

In the normalization process,if you find a candidate key that is not a primary key then you should ________.

Correct AnswerverifiedShow Answer

In SQL Server,the starting value of a surrogate key is called the ________.

Correct AnswerverifiedShow Answer

A rule that requires every value in a foreign key to match values in the corresponding primary key is called a(n)________ constraint.

Correct Answerverifiedreferentia...View AnswerShow Answer

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.

Correct AnswerverifiedShow Answer

Which of the following is not true about a relation?

Correct AnswerverifiedShow Answer

Briefly describe the various tasks of the primary key.

Correct AnswerverifiedThe primary key is used for four primary...View AnswerShow Answer

Every table is a relation,but not every relation is a table.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
In Microsoft Access,relationships are cr...
View Answer

Correct Answer
verified
Edit Relat...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Before starting the normalization proces...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
referentia...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The primary key is used for four primary...
View Answer

Correct Answer
verified