Section 5 Quiz (Answer all questions in this section)

  1.   The relationship between CUSTOMER and RECEIPT is an example of a non-transferable relationship. True or False?    
True (*)  
False

 
  2.   Every ERD must have at least one non-transferable relationship. True or False?
True   
False (*)

 
  3.   A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False?
True (*)  
False

 
  4.   A non-transferable relationship means the relationship is manatory at both sides. True or False?   
True  
False (*)

 
  5.   Which of the following is an example of a non-transferable relationship 
TEACHER to SCHOOl  
STUDENT to COURSE  
EMPLOYEE to DEPARTMENT  
PERSON to BIRTH PLACE (*)

 
  6.   Which of the following pairs of entities is most likely to be modeled as a 1:1 relationship?
TREE and BRANCH  
TEACHER and SUBJECT AREA  
PERSON and FINGERPRINT (*)   
CAR and WHEEL

 
  7.   Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False?   
True  
False (*)

 
  8.   What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE"   
One to Many Optional  
Many to Many Mandatory  
One to One Optional (*)  
One to Many Mandatory

 
  9.   What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER"
Many to More  
One to Many (*)  
Many to Many 
One to One

 
  10.   Relationships can be Redundant. True or False?  
True (*)  
False


  11.   When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False?   
True  
False (*)

 
  12.   Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False?  
True (*)  
False

 
  13.   When you resolve a M:M by creating an intersection entity, this new entity will always inherit:  
Nothing is inherited from the original entities and relationship.
A relationship to each entity from the original M:M. (*)  
The UID's from the entities in the original M:M.  
The attributes of both related entities.

 
  14.   If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by 
Creating new attributes.  
Barring the relationships to the original entities. (*)  
Placing the UID attributes from the original entities into the intersection entity.  
None of the above.

 
  15.   A relationship on an ERD can have attributes. True or False?
True   
False (*)

Lanjutan... Database Design Midterm Exams Quiz

Download Source Code Program