Question 1

For a 1:1 relationship,the key of each table should be placed in the other table as the foreign key.

Accepted Answer

A) True 
 B)False

Question 2

As far as Microsoft Access is concerned,there are no ________.

Accepted Answer

The answer of As far as Microsoft Access is concerned,there...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

Accepted Answer

STUDENT (StudentID, StuName, StuMajor, StuPhone, AdvisorID) ADVISOR (AdvisorID, AdvName, AdvOffice, AdvPhone) AdvisorID in STUDENT must exist in AdvisorID in ADVISOR.

Question 5

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

Accepted Answer

Edit Relat...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

When applied to 1:N relationships,the term "parent" refers to the many side of the relationship since a child may have many parents.

Accepted Answer

A) True 
 B)False

Question 8

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

Accepted Answer

A) True 
 B)False  False

Question 9

The technique for representing E-R relationships in the relational model is dependent on the minimum cardinality.

Accepted Answer

A) True 
 B)False

Question 10

To create a 1:1 relationship between two tables in Microsoft Access,the Indexed property of the foreign key column must be set to ________.

Accepted Answer

Yes (No Duplicates)

Question 11

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

Accepted Answer

A)  the key of the child is placed as a foreign key into the parent
B)  the key of the parent is placed as a foreign key into the child
C)  the keys of both tables are placed in a third table
D)  the keys of both tables are joined into a composite key
E)  C and D

Question 12

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,SupplierID)  SUPPLIER .(SupplierID,ContactName,PhoneNumber,ProductID) . C)  PRODUCT (ProductID,Description,Cost)  SUPPLIER ,(SupplierID,ContactName,PhoneNumber)  PRODUCT_SUPPLIER (ProductID,SupplierID) ..  D)  PRODUCT (ProductID,Description,Cost,SupplierID)  SUPPLIER (SupplierID,ContactName,PhoneNumber) , E)  PRODUCT (ProductID,Description,Cost)  SUPPLIER (SupplierID,ContactName,PhoneNumber)  PRODUCT_SUPPLIER  ( ProductID  , SupplierID) ,." class="answers-bank-image d-inline" rel="preload" >

Accepted Answer

A)  PRODUCT (ProductID,Description,Cost)  SUPPLIER (SupplierID,ContactName,PhoneNumber) 
B)  PRODUCT (ProductID,Description,Cost,SupplierI
D)   SUPPLIER .(SupplierID,ContactName,PhoneNumber,ProductI
D)  .
C)  PRODUCT (ProductID,Description,Cost)  SUPPLIER ,(SupplierID,ContactName,PhoneNumber) PRODUCT_SUPPLIER (ProductID,SupplierI
D)  ..
D)  PRODUCT (ProductID,Description,Cost,SupplierI
D)   SUPPLIER (SupplierID,ContactName,PhoneNumber) ,
E)  PRODUCT (ProductID,Description,Cost)  SUPPLIER (SupplierID,ContactName,PhoneNumber) PRODUCT_SUPPLIER  ( ProductID  , SupplierI
D)  ,.

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

What relationship pattern is illustrated in the following schema? EMPLOYEE EmployeeID,OfficePhone,Manager) 
Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE

Accepted Answer

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

Question 16

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 17

Explain the representation of ID-dependent weak entities using the relational model.

Accepted Answer

A weak entity is represented in the rela...

Question 18

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 19

How are one-to-one recursive relationships addressed using the relational model?

Accepted Answer

One-to-one recursive relationships are a...

Question 20

By default,Microsoft Access creates 1:1 relationships between tables.

Accepted Answer

A) True 
 B)False

Exam 5: Database Design

For a 1:1 relationship,the key of each table should be placed in the other table as the foreign key.

Correct AnswerverifiedShow Answer

As far as Microsoft Access is concerned,there are no ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

Correct AnswerverifiedSTUDENT (StudentID, StuName, StuMajor, StuPhone, AdvisorID) ADVISOR (AdvisorID, AdvName, AdvOffice, AdvPhone) AdvisorID in STUDENT must exist in AdvisorID in ADVISOR.

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

Correct AnswerverifiedEdit Relat...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

When applied to 1:N relationships,the term "parent" refers to the many side of the relationship since a child may have many parents.

Correct AnswerverifiedShow Answer

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

Correct AnswerverifiedFalse

The technique for representing E-R relationships in the relational model is dependent on the minimum cardinality.

Correct AnswerverifiedShow Answer

To create a 1:1 relationship between two tables in Microsoft Access,the Indexed property of the foreign key column must be set to ________.

Correct AnswerverifiedYes (No Duplicates)

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What relationship pattern is illustrated in the following schema? EMPLOYEE EmployeeID,OfficePhone,Manager) Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Explain the representation of ID-dependent weak entities using the relational model.

Correct AnswerverifiedA weak entity is represented in the rela...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

How are one-to-one recursive relationships addressed using the relational model?

Correct AnswerverifiedOne-to-one recursive relationships are a...View AnswerShow Answer

By default,Microsoft Access creates 1:1 relationships between tables.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
STUDENT (StudentID, StuName, StuMajor, StuPhone, AdvisorID) ADVISOR (AdvisorID, AdvName, AdvOffice, AdvPhone) AdvisorID in STUDENT must exist in AdvisorID in ADVISOR.

Correct Answer
verified
Edit Relat...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified
Yes (No Duplicates)

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A weak entity is represented in the rela...
View Answer

Correct Answer
verified

Correct Answer
verified
One-to-one recursive relationships are a...
View Answer

Correct Answer
verified