Question 1

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 key.F) D) and E)
G) A) and C)

Question 2

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

Question 3

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 4

Null values can cause problems because they are ambiguous.

Accepted Answer

A) True 
 B)False

Question 5

To be a well-formed relation,every ________ in the relation must be a candidate key.

Accepted Answer

The answer of To be a well-formed relation,every ________ in...

Question 6

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

Question 7

In Microsoft Access,referential integrity constraints are created:

Accepted Answer

A)   by setting a property value on the primary key in the table which contains it.
B)   by setting a property value on the foreign key in the table which contains it.
C)   by setting a property value on the primary key in the Relationships window.
D)   by setting a property value on the foreign key in the Relationships window.
E)   by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box.F) B) and E)
G) A) and E)

Question 8

Which of the following functional dependency diagrams accurately represents the following situation: • A campus has many buildings.
• Each building has a unique name.
• Each building has many rooms.
• All rooms in any given building are numbered sequentially starting at "101."
• Each room has a certain capacity,although many rooms in the same building or different buildings may have the same capacity.
• Each room is assigned to a single department.
• A department may have many rooms in one or more buildings,each with the same or different capacities.

Accepted Answer

A)   BuildingName → (RoomNumber, Capacity, Department) 
B)   RoomNumber → (BuildingName, Department, Capacity) 
C)   (Department, Capacity)  → (BuildingName, RoomNumber) 
D)   (BuildingName, Capacity)  → (Department, RoomNumber) 
E)   (BuildingName, RoomNumber)  → (Capacity, Department) F) B) and D)
G) None of the above

Question 9

When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.

Accepted Answer

A) True 
 B)False

Question 10

Explain the possible interpretations of a null value.

Accepted Answer

The problem with allowing null values in...

Question 11

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

Accepted Answer

A)   Attribute
B)   Table
C)   Field
D)   Row
E)   RelationF) B) and E)
G) All of the above

Question 12

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 list.F) None of the above
G) A) and C)

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Although Microsoft Access is a personal database,the database tables in Access are still subject to ________ if they are not well-formed.

Accepted Answer

modificati...

Question 15

In the normalization process,if you find a candidate key that is not a determinant 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)   All of the above
E)   None of the aboveF) B) and E)
G) A) and E)

Question 16

The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values.

Accepted Answer

A) True 
 B)False

Question 17

Distinguish between the primary key and a candidate key.

Accepted Answer

Both the primary key and a candidate key...

Question 18

In the normalization process,it is not necessary 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)   determine if every determinant is a candidate key.F) B) and C)
G) None of the above

Question 19

Explain how to create a relationship in Microsoft Access.

Accepted Answer

In Microsoft Access,relationships are cr...

Question 20

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 window.F) B) and E)
G) A) and B)

Exam 2: The Relational Model

The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values.

Correct Answer
verified

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

Correct Answer
verified

Although Microsoft Access is a personal database,the database tables in Access are still subject to ________ if they are not well-formed.

Correct Answer
verified
modificati...
View Answer

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

Correct Answer
verified

Null values can cause problems because they are ambiguous.

Correct Answer
verified

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

Correct Answer
verified
referentia...
View Answer

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

Correct Answer
verified

In Microsoft Access,a relationship between two tables is created:

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Explain how to create a relationship in Microsoft Access.

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

To be a well-formed relation,every ________ in the relation must be a candidate key.

Correct Answer
verified

Correct Answer
verified

Distinguish between the primary key and a candidate key.

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

When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.

Correct Answer
verified

Explain the possible interpretations of a null value.

Correct Answer
verified
The problem with allowing null values in...
View Answer

In the normalization process,it is not necessary to:

Correct Answer
verified

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

Correct Answer
verified

In Microsoft Access,referential integrity constraints are created:

Correct Answer
verified

Exam 2: The Relational Model

The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Although Microsoft Access is a personal database,the database tables in Access are still subject to ________ if they are not well-formed.

Correct Answerverifiedmodificati...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Null values can cause problems because they are ambiguous.

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 into a second relation,it is called a:

Correct AnswerverifiedShow Answer

In Microsoft Access,a relationship between two tables is created:

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

Explain how to create a relationship in Microsoft Access.

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

To be a well-formed relation,every ________ in the relation must be a candidate key.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Distinguish between the primary key and a candidate key.

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

When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.

Correct AnswerverifiedShow Answer

Explain the possible interpretations of a null value.

Correct AnswerverifiedThe problem with allowing null values in...View AnswerShow Answer

In the normalization process,it is not necessary to:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In Microsoft Access,referential integrity constraints are created:

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
modificati...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
referentia...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

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
The problem with allowing null values in...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified