Question 1

Which of the following is not true of recursive relationships?

Accepted Answer

A)  When the recursive relationship is M:N,an intersection table is created.
B)  The rows of a single table can play two different roles.
C)  The techniques for representing the tables are the same as for non-recursive relationships except the rows are in the same table.
D)  Recursive relationships can be 1:1,1:N,or M:N relationships.
E)  Even when the relationship is 1:N,a new table must be defined to represent the relationship.F) D) and E)
G) B) and D)

Question 2

Recursive relationships can be represented in the relational model using the same techniques that are used for binary relationships.

Accepted Answer

A) True 
 B)False

Question 3

Microsoft Access uses the same pure N:M relationships that occur in data modeling.

Accepted Answer

A) True 
 B)False

Question 4

By default,when Microsoft Access creates a relationship between two tables it creates a(n)________ relationship.

Accepted Answer

The answer of By default,when Microsoft Access creates a relationship...

Question 5

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 6

Relations should always be normalized to the highest degree possible.

Accepted Answer

A) True 
 B)False

Question 7

Once a table has been defined,it should be examined according to ________ criteria.

Accepted Answer

The answer of Once a table has been defined,it should...

Question 8

Relationships that are 1:1 do not require referential integrity constraints.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following would be a reason to denormalize a relation?

Accepted Answer

A)  Relax security
B)  Lack of design time
C)  End user preference
D)  Improve performance
E)  None of the aboveF) B) and E)
G) All of the above

Question 10

How are 1:1,1:N and N:M relationships handled in Microsoft Access?

Accepted Answer

By default,when Microsoft Access creates...

Question 11

Given the tables 
TABLE_A (Attribute1, Attribute2, Attribute3)  
TABLE_B (Attribute4, Attribute5, Attribute6)  
As shown in the figure below,which of the following would display the correct placement of foreign keys in the relational model?
Attribute1, Attribute2, Attribute3)   TABLE_B (Attribute4, Attribute5, Attribute6)   As shown in the figure below,which of the following would display the correct placement of foreign keys in the relational model?   A)  TABLE_A (Attribute1, Attribute2, Attribute3)  TABLE B (Attribute4, Attribute5, Attribute6, Attributel)  B)  TABLE_A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5)   TABLE_B (Attribute4, Attribute5, Attribute6)   C)  TABLE_A (Attribute1, Attribute2, Attribute3, Attribute4)  TABLE_B (Attribute4 , Attribute5, Attribute6, Attributel)   D)  TABLE_A (Attribute1, Attribute2, Attribute3)  TABLE B (Attribute4, Attribute5, Attribute6)   E)  TABLE_A (Attribute1, Attribute2, Attribute3, Attribute6)  TABLE_B (Attribute4, Attribute5, Attribute6) " class="answers-bank-image d-inline" rel="preload" >

Accepted Answer

A)  TABLE_A (Attribute1, Attribute2, Attribute3) TABLE B (Attribute4, Attribute5, Attribute6, Attributel) 
B)  TABLE_A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5)  TABLE_B (Attribute4, Attribute5, Attribute6) 
C)  TABLE_A (Attribute1, Attribute2, Attribute3, Attribute4) TABLE_B (Attribute4 , Attribute5, Attribute6, Attributel) 
D)  TABLE_A (Attribute1, Attribute2, Attribute3) TABLE B (Attribute4, Attribute5, Attribute6) 
E)  TABLE_A (Attribute1, Attribute2, Attribute3, Attribute6) TABLE_B (Attribute4, Attribute5, Attribute6) F) B) and D)
G) C) and D)

Question 12

Explain the representation of a one-to-many strong entity relationship in a relational database design.

Accepted Answer

One-to-many relationships are represente...

Question 13

To represent a 1:N relationship in the relational model,the key of either entity may be placed as a foreign key in the other entity.

Accepted Answer

A) True 
 B)False

Question 14

The first step of database design is to define a table for each ________.

Accepted Answer

The answer of The first step of database design is...

Question 15

To represent a 1:N relationship in the relational model,the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.

Accepted Answer

A) True 
 B)False

Question 16

The ideal primary key is ________.

Accepted Answer

A)  short
B)  numeric
C)  fixed
D)  A and B
E)  A,B,and CF) B) and C)
G) A) and E)

Question 17

The ideal primary key is short,numeric,and fixed.

Accepted Answer

A) True 
 B)False

Question 18

Given the tables
PRODUCT (ProductID, Description, Cost) 
SUPPLIER (SupplierID, ContactName, PhoneNumber) 
As shown in the figure below,which of the following would represent the correct placement of foreign keys?
ProductID, Description, Cost)  SUPPLIER (SupplierID, ContactName, PhoneNumber)  As shown in the figure below,which of the following would represent the correct placement of foreign keys?   A) PRODUCT (ProductID,Description,Cost)  SUPPLIER  (SupplierID,ContactName,PhoneNumber)  B) PRODUCT (ProductID,Description,Cost)  SUPPLIER  (SupplierID,ContactName,PhoneNumber,ProductID)  C) PRODUCT (ProductID,Description,Cost,SupplierID)  SUPPLIER  (SupplierID,ContactName,PhoneNumber,ProductID)  D) PRODUCT (ProductID,Description,Cost,ContactName)  SUPPLIER  (SupplierID,ContactName,PhoneNumber)  E) PRODUCT (ProductID,Description,Cost,SupplierID)  SUPPLIER  (SupplierID,ContactName,PhoneNumber) " class="answers-bank-image d-inline" rel="preload" >

Accepted Answer

A)  PRODUCT (ProductID,Description,Cost)  SUPPLIER  (SupplierID,ContactName,PhoneNumber) 
B)  PRODUCT (ProductID,Description,Cost)  SUPPLIER  (SupplierID,ContactName,PhoneNumber,ProductI
D)  
C)  PRODUCT (ProductID,Description,Cost,SupplierI
D)   SUPPLIER  (SupplierID,ContactName,PhoneNumber,ProductI
D)  
D)  PRODUCT (ProductID,Description,Cost,ContactName)  SUPPLIER  (SupplierID,ContactName,PhoneNumber) 
E)  PRODUCT (ProductID,Description,Cost,SupplierI
D)   SUPPLIER  (SupplierID,ContactName,PhoneNumber) F) B) and E)
G) None of the above

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is not true about surrogate keys?

Accepted Answer

A)  They are identifiers that are supplied by the system,not the users.
B)  They have no meaning to the users.
C)  They are nonunique within a table.
D)  They can be problematic when combining databases.
E)  The DBMS will not allow their values to be changed.F) C) and D)
G) A) and E)

Exam 5: Database Design

By default,when Microsoft Access creates a relationship between two tables it creates a(n)________ relationship.

Correct AnswerverifiedShow Answer

The ideal primary key is ________.

Correct AnswerverifiedShow Answer

Relationships that are 1:1 do not require referential integrity constraints.

Correct AnswerverifiedShow Answer

To represent a 1:N relationship in the relational model,the key of either entity may be placed as a foreign key in the other entity.

Correct AnswerverifiedShow Answer

Given the tables PRODUCT (ProductID, Description, Cost) SUPPLIER (SupplierID, ContactName, PhoneNumber) As shown in the figure below,which of the following would represent the correct placement of foreign keys?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ideal primary key is short,numeric,and fixed.

Correct AnswerverifiedShow Answer

Recursive relationships can be represented in the relational model using the same techniques that are used for binary relationships.

Correct AnswerverifiedShow Answer

Which of the following would be a reason to denormalize a relation?

Correct AnswerverifiedShow Answer

How are 1:1,1:N and N:M relationships handled in Microsoft Access?

Correct AnswerverifiedBy default,when Microsoft Access creates...View AnswerShow Answer

Microsoft Access uses the same pure N:M relationships that occur in data modeling.

Correct AnswerverifiedShow Answer

Which of the following is not true about surrogate keys?

Correct AnswerverifiedShow Answer

Given the tables TABLE_A (Attribute1, Attribute2, Attribute3) TABLE_B (Attribute4, Attribute5, Attribute6) As shown in the figure below,which of the following would display the correct placement of foreign keys in the relational model?

Correct AnswerverifiedShow Answer

Once a table has been defined,it should be examined according to ________ criteria.

Correct AnswerverifiedShow Answer

The first step of database design is to define a table for each ________.

Correct AnswerverifiedShow Answer

To represent a 1:N relationship in the relational model,the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.

Correct AnswerverifiedShow Answer

Explain the representation of a one-to-many strong entity relationship in a relational database design.

Correct AnswerverifiedOne-to-many relationships are represente...View AnswerShow Answer

Which of the following is not true of recursive relationships?

Correct AnswerverifiedShow Answer

Relations should always be normalized to the highest degree possible.

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
By default,when Microsoft Access creates...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
One-to-many relationships are represente...
View Answer

Correct Answer
verified

Correct Answer
verified