Question 1

Explain the pragmatic reason for using surrogate keys.

Accepted Answer

Primary keys are commonly included in in...

Question 2

After a 1:1 relationship has been created between two tables in Microsoft Access,the Relationship Type of One-To-One appears ________.

Accepted Answer

A)   in the Relationship Type property of the primary key column in table Design View
B)   in the Relationship Type property of the foreign key column in table Design View
C)   in the table object in the Relationships window
D)   in the Show Table dialog box
E)   in the Edit Relationships dialog box

Question 3

Which of the following is true when representing a 1:1 binary relationship using the relational model?

Accepted Answer

A)   The key of the entity with the highest minimum cardinality must be placed in the other entity as a foreign key.
B)   The key of each entity must be placed in the other as a foreign key.
C)   The key of either entity is placed in the other as a foreign key.
D)   The key of the entity with the most attributes must be placed in the other entity as a foreign key.
E)   Both entities must have the same primary key.

Question 4

To represent a many-to-many relationship in the relational model,a(n)________ table is used.

Accepted Answer

The answer of To represent a many-to-many relationship in the...

Question 5

As far as Microsoft Access is concerned,there are no N:M relationships.

Accepted Answer

A) True 
 B)False  True

Question 6

In many-to-many relationships in a relational database design,________.

Accepted Answer

A)   the intersection table is ID-dependent on one of the parents
B)   the intersection table is ID-dependent on both of the parents
C)   the minimum cardinality from the intersection table to the parents is always M
D)   Both A and B
E)   Both B and C

Question 7

To represent a M:N relationship in the relational model,an intersection table is created to represent the relationship itself.

Accepted Answer

A) True 
 B)False  True

Question 8

The first step in representing entities using the relational model is to determine which identifier will be used as the key.

Accepted Answer

A) True 
 B)False

Question 9

What is an association relationship,and how does it differ from an N:M relationship?

Accepted Answer

An association relationship is very simi...

Question 10

Which of the following is not true about representing subtypes in a relational database design?

Accepted Answer

A)   One table is created for the supertype and one for each subtype.
B)   All of the attributes of the supertype are added to the subtype relations.
C)   The key of the supertype is made the key of the subtypes.
D)   A subtype and its supertype are representations of the same underlying table.
E)   An instance of the supertype may be related to one instance each of several subtypes.

Question 11

All recursive relationships are 1:1.

Accepted Answer

A) True 
 B)False

Question 12

A(n)________ is a relationship among entities of the same class.

Accepted Answer

recursive ...

Question 13

In a relational database design,all relationships are expressed by ________.

Accepted Answer

A)   creating a primary key
B)   creating a foreign key
C)   creating a supertype
D)   creating a subtype
E)   creating a line between entities

Question 14

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

Accepted Answer

A) True 
 B)False

Question 15

To create a 1:1 relationship in Microsoft Access,the Indexed property of the foreign key column must be set to Yes (No Duplicates).

Accepted Answer

A) True 
 B)False

Question 16

By default,the identifier of the entity becomes the foreign key of the corresponding table.

Accepted Answer

A) True 
 B)False

Question 17

What relationship pattern is illustrated in the following schema?
PRODUCT (ProductID,Description) 
SUPPLIER (SupplierID,ContactName,PhoneNumber) 
PRODUCT_SUPPLIER (ProductID,SupplierID,Cost) 
ProductID in PRODUCT_SUPPLIER must exist in ProductID in PRODUCT
SupplierID in PRODUCT_SUPPLIER must exist in SupplierID in PRODUCT

Accepted Answer

A)   Association relationship
B)   Intersection relationship
C)   Recursive relationship
D)   Strong entity relationship
E)   Supertype/subtype relationship

Question 18

In the relational model,many-to-many relationships cannot be directly represented by relations the way 1:1 and 1:N relationships can.

Accepted Answer

A) True 
 B)False  True

Question 19

For a(n)________ weak entity,it is necessary to add the key of the parent entity to the weak entity's relation so that this added attribute becomes part of the weak entity's key.

Accepted Answer

The answer of For a(n)________ weak entity,it is necessary to...

Question 20

One of the important properties of a column is whether or not it is ________.

Accepted Answer

A)   found in more than one entity
B)   required
C)   character or numeric
D)   subject to normalization
E)   subject to denormalization

Exam 5: Database Design

Explain the pragmatic reason for using surrogate keys.

Correct Answer
verified
Primary keys are commonly included in in...
View Answer

After a 1:1 relationship has been created between two tables in Microsoft Access,the Relationship Type of One-To-One appears ________.

Correct Answer
verified

Which of the following is true when representing a 1:1 binary relationship using the relational model?

Correct Answer
verified

To represent a many-to-many relationship in the relational model,a(n)________ table is used.

Correct Answer
verified

As far as Microsoft Access is concerned,there are no N:M relationships.

Correct Answer
verified
True

In many-to-many relationships in a relational database design,________.

Correct Answer
verified

To represent a M:N relationship in the relational model,an intersection table is created to represent the relationship itself.

Correct Answer
verified
True

The first step in representing entities using the relational model is to determine which identifier will be used as the key.

Correct Answer
verified

What is an association relationship,and how does it differ from an N:M relationship?

Correct Answer
verified
An association relationship is very simi...
View Answer

Which of the following is not true about representing subtypes in a relational database design?

Correct Answer
verified

All recursive relationships are 1:1.

Correct Answer
verified

A(n)________ is a relationship among entities of the same class.

Correct Answer
verified
recursive ...
View Answer

In a relational database design,all relationships are expressed by ________.

Correct Answer
verified

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

Correct Answer
verified

To create a 1:1 relationship in Microsoft Access,the Indexed property of the foreign key column must be set to Yes (No Duplicates).

Correct Answer
verified

By default,the identifier of the entity becomes the foreign key of the corresponding table.

Correct Answer
verified

Correct Answer
verified

In the relational model,many-to-many relationships cannot be directly represented by relations the way 1:1 and 1:N relationships can.

Correct Answer
verified
True

For a(n)________ weak entity,it is necessary to add the key of the parent entity to the weak entity's relation so that this added attribute becomes part of the weak entity's key.

Correct Answer
verified

One of the important properties of a column is whether or not it is ________.

Correct Answer
verified

Exam 5: Database Design

Explain the pragmatic reason for using surrogate keys.

Correct AnswerverifiedPrimary keys are commonly included in in...View AnswerShow Answer

After a 1:1 relationship has been created between two tables in Microsoft Access,the Relationship Type of One-To-One appears ________.

Correct AnswerverifiedShow Answer

Which of the following is true when representing a 1:1 binary relationship using the relational model?

Correct AnswerverifiedShow Answer

To represent a many-to-many relationship in the relational model,a(n)________ table is used.

Correct AnswerverifiedShow Answer

As far as Microsoft Access is concerned,there are no N:M relationships.

Correct AnswerverifiedTrue

In many-to-many relationships in a relational database design,________.

Correct AnswerverifiedShow Answer

To represent a M:N relationship in the relational model,an intersection table is created to represent the relationship itself.

Correct AnswerverifiedTrue

The first step in representing entities using the relational model is to determine which identifier will be used as the key.

Correct AnswerverifiedShow Answer

What is an association relationship,and how does it differ from an N:M relationship?

Correct AnswerverifiedAn association relationship is very simi...View AnswerShow Answer

Which of the following is not true about representing subtypes in a relational database design?

Correct AnswerverifiedShow Answer

All recursive relationships are 1:1.

Correct AnswerverifiedShow Answer

A(n)________ is a relationship among entities of the same class.

Correct Answerverifiedrecursive ...View AnswerShow Answer

In a relational database design,all relationships are expressed by ________.

Correct AnswerverifiedShow Answer

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

Correct AnswerverifiedShow Answer

To create a 1:1 relationship in Microsoft Access,the Indexed property of the foreign key column must be set to Yes (No Duplicates).

Correct AnswerverifiedShow Answer

By default,the identifier of the entity becomes the foreign key of the corresponding table.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

In the relational model,many-to-many relationships cannot be directly represented by relations the way 1:1 and 1:N relationships can.

Correct AnswerverifiedTrue

For a(n)________ weak entity,it is necessary to add the key of the parent entity to the weak entity's relation so that this added attribute becomes part of the weak entity's key.

Correct AnswerverifiedShow Answer

One of the important properties of a column is whether or not it is ________.

Correct AnswerverifiedShow Answer

Correct Answer
verified
Primary keys are commonly included in in...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified
An association relationship is very simi...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
recursive ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified