Question 1

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

Accepted Answer

A) True 
 B)False

Question 2

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

Accepted Answer

A) True 
 B)False

Question 3

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

Accepted Answer

A) True 
 B)False

Question 4

In Microsoft Access,the Relationships window is accessed by using the ________ button on the Database tools command tab.

Accepted Answer

The answer of In Microsoft Access,the Relationships window is accessed...

Question 5

Candidate keys may or may not be unique.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is not true about null values?

Accepted Answer

A)   A null value can mean that the value is unknown.
B)   A null value is ambiguous.
C)   A null value can mean that the value is known to be blank.
D)   A null value can mean that no value for the field is appropriate.
E)   Null values cannot be avoided.F) D) and E)
G) B) and D)

Question 7

A key that contains more than one attribute is called a(n) ________.

Accepted Answer

A)   composite key
B)   complex key
C)   multi-key
D)   n-key
E)   candidate keyF) B) and D)
G) A) and B)

Question 8

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

Question 9

Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of a referential integrity constraint.

Accepted Answer

A) True 
 B)False

Question 10

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

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)   rename the determinant to another attribute description
E)   create a referential integrity constraint between the original relation and the new relationF) B) and E)
G) All of the above

Question 11

Distinguish between the primary key and a candidate key.

Accepted Answer

Both the primary key and a candidate key...

Question 12

A primary key is ________.

Accepted Answer

A)   not required to be unique
B)   used to represent columns in relationships
C)   a candidate key
D)   always automatically generated by the DBMS
E)   comprised of exactly one attributeF) B) and E)
G) A) and D)

Question 13

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

Question 14

Which of the following terms is synonymous with "tuple"?

Accepted Answer

A)   Attribute
B)   Table
C)   Field
D)   Row
E)   RelationF) D) and E)
G) B) and D)

Question 15

In Microsoft Access,relationships between tables are created ________.

Accepted Answer

A)   by the Relationships button on the Create command tab
B)   by the Relationships button on the Home command tab
C)   in the Relationships window
D)   in the Table window of the table containing the primary key
E)   in the Table window of the table containing the foreign keyF) B) and C)
G) A) and B)

Question 16

A surrogate key may be appropriate under which of the following circumstances?

Accepted Answer

A)   The primary key is not unique.
B)   The primary key is numeric.
C)   The available candidate keys would be prone to typographical errors.
D)   The available candidate keys have little meaning to the users.
E)   The relation only has one attribute.F) A) and E)
G) A) and B)

Question 17

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

Accepted Answer

A) True 
 B)False

Question 18

During the normalization process,the remedy for a relation that is not well formed is to ________.

Accepted Answer

A)   create a surrogate key
B)   create a functional dependency
C)   break it into two or more relations that are well formed
D)   combine it with another relation that is well formed
E)   convert it into a listF) C) and E)
G) A) and B)

Question 19

Given the relations:
STUDENT (SID,StudentName,Major,AdvisorID) 
ADVISOR (AdvisorID,AdvisorName,Office,Phone) 
Such that each student is assigned to one advisor,which of the following is true?

Accepted Answer

A)   SID is both a primary key and a foreign key.
B)   AdvisorName is a determinant.
C)   AdvisorID is a foreign key.
D)   Phone is a candidate key.
E)   Major is a candidate key.F) C) and E)
G) A) and B)

Question 20

A key that contains two or more attributes is called a(n)________ key.

Accepted Answer

The answer of A key that contains two or more...

Exam 2: The Relational Model

A primary key is ________.

Correct AnswerverifiedShow Answer

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A key that contains more than one attribute is called a(n) ________.

Correct AnswerverifiedShow Answer

Candidate keys may or may not be unique.

Correct AnswerverifiedShow Answer

During the normalization process,the remedy for a relation that is not well formed is to ________.

Correct AnswerverifiedShow Answer

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

Correct AnswerverifiedShow Answer

A surrogate key may be appropriate under which of the following circumstances?

Correct AnswerverifiedShow Answer

Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of a referential integrity constraint.

Correct AnswerverifiedShow Answer

Which of the following terms is synonymous with "tuple"?

Correct AnswerverifiedShow Answer

In Microsoft Access,relationships between tables are created ________.

Correct AnswerverifiedShow Answer

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

Correct AnswerverifiedShow Answer

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

Correct AnswerverifiedShow Answer

In Microsoft Access,the Relationships window is accessed by using the ________ button on the Database tools command tab.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Distinguish between the primary key and a candidate key.

Correct AnswerverifiedBoth the primary key and a candidate key...View AnswerShow Answer

A key that contains two or more attributes is called a(n)________ key.

Correct AnswerverifiedShow Answer

Given the relations: STUDENT (SID,StudentName,Major,AdvisorID) ADVISOR (AdvisorID,AdvisorName,Office,Phone) Such that each student is assigned to one advisor,which of the following is true?

Correct AnswerverifiedShow Answer

Which of the following is not true about null values?

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Both the primary key and a candidate key...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified