Quiz # 2 (Chapter 3 & 4)

12 Questions | Total Attempts: 121

SettingsSettingsSettings
Quiz # 2 (Chapter 3 & 4) - Quiz

Spring 2010, Database System Quiz # 2


Questions and Answers
  • 1. 
    If an attribute has different number of values for each entity, it will be modeled as:
    • A. 

      Atomic

    • B. 

      Composite

    • C. 

      Derived

    • D. 

      Multivalued

  • 2. 
    Each simple attribute of an entity type is associated with a value set, which specified the set of values that may be assigned to that attribute for each individual entity. This value set is called
    • A. 

      Attribute

    • B. 

      Entity

    • C. 

      Domain

    • D. 

      Constraint

  • 3. 
    The key attribute is chosen after carefully studying the
    • A. 

      ER Diagram

    • B. 

      Text Book

    • C. 

      User Requirements

    • D. 

      DBMS

  • 4. 
    The basic object that the ER model represents is 
    • A. 

      Entity

    • B. 

      Cardinality

    • C. 

      Participation

    • D. 

      Relationship

  • 5. 
    The attribute which is not divisible and has only one meaning is called a
    • A. 

      Derived Attribute

    • B. 

      Atomic Attribute

    • C. 

      Composite Attribute

    • D. 

      Single Attribute

  • 6. 
    Entity types which can not exists independently are called
    • A. 

      1:1

    • B. 

      Strong

    • C. 

      Weak

    • D. 

      Derived

  • 7. 
    A collection of entities that have the same attributes is called
    • A. 

      ER Diagram

    • B. 

      Entity Type

    • C. 

      Entity Set

    • D. 

      ER Schema

  • 8. 
    An entity type usually has an attribute whose values are distinct for each individual entity in the entity set. Such an attribute is called a 
    • A. 

      Global Attribute

    • B. 

      Underlined Attribute

    • C. 

      Key Attribute

    • D. 

      Derived Attribute

  • 9. 
    Each simple attribute of an entity type is associated with a _______________ , which specified the set of values that may be assigned to that attribute for each individual entity.
  • 10. 
    The degree of a relationship is the number of ________ in it.
  • 11. 
    The participation constraint is defined as the:
    • A. 

      Min # of relationships possible

    • B. 

      Mix # of relationships possible

    • C. 

      Min # of relationships required

    • D. 

      Mix # of relationships required

  • 12. 
    In addition to the all the modeling concepts of ER model, the EER includes the concepts of
    • A. 

      Subclass \ superclass & specialization \ generalization

    • B. 

      Specialization \ generalization & relationship

    • C. 

      Subclass \ superclass & specialization

    • D. 

      Superclass & specialization \ generalization

Back to Top Back to top