Entity Relationship Diagram Quiz

22 Questions | Attempts: 6332

SettingsSettingsSettings
Entity Relationship Diagram Quiz - Quiz

Hey, are you aware of the entity-relationship model (ER)? Try this interesting 'ER diagram' quiz and see how much you can score on this test. This model is used to describe interrelated things of interest in a specific domain of knowledge. If you think you have a good understanding of this topic, then this quiz will be very useful in testing your knowledge. So, get ready and start answering. Good luck to you!


Questions and Answers
  • 1. 
    ER was developed by Chen in 1980. True or false? 
    • A. 

      True

    • B. 

      False

  • 2. 
    ER aims to:
    • A. 

      Facilitate database programming

    • B. 

      Facilitate database organization

    • C. 

      Facilitate database design

    • D. 

      Facilitate database website

  • 3. 
    The Conceptual data model is the set of concepts that:
    • A. 

      Describe the structure of a database and the associated insert and update transactions

    • B. 

      Describe the structure of a database and the associated retrieval and update transactions

    • C. 

      Describe the structure of a database and the associated retrieval transactions

    • D. 

      None of the above

  • 4. 
    An ERs purpose is to support a user's perception of the data and conceal the technical aspects associated with database design. True or false? 
    • A. 

      True

    • B. 

      False

  • 5. 
    A high-level conceptual model is dependent on the DBMS and HW platform used to implement the database. True or false? 
    • A. 

      True

    • B. 

      False

  • 6. 
    The basic concepts of the Entity-Relationship model include:
    • A. 

      Entity types

    • B. 

      File types

    • C. 

      Relationship types

    • D. 

      Atrtributes

    • E. 

      Storage detailes

  • 7. 
    Entity type = An object or concept identified by the enterprise as having an ______________ existence.
  • 8. 
    A Entity is
    • A. 

      An instance of an Entity type that is uniquely identifiable

    • B. 

      An instance of a DBA type that is uniquely identifiable

    • C. 

      An instance of a type that is uniquely identifiable

    • D. 

      None of the above

  • 9. 
    Weak entity type:
    • A. 

      An entity that is not existance-dependent on some other entity type

    • B. 

      An Entity that characterizes a DBMS

    • C. 

      An instance that is existence dependent on some other entity type

    • D. 

      None of the above

  • 10. 
    Strong entity type:
    • A. 

      An entity that is not existance-dependent on some other entity type

    • B. 

      An Entity that characterizes a DBMS

    • C. 

      An instance that is existance dependent on some other entity type

    • D. 

      All of the above

  • 11. 
    An Attribute is a property of an entity or a relationship type. True or false? 
    • A. 

      True

    • B. 

      False

  • 12. 
    An Attribute:
    • A. 

      A set of values that might be assigned to an attribute. 

    • B. 

      Is a property of an entity or a relationship type

    • C. 

      A set of numbers and values 

    • D. 

      None of the above 

  • 13. 
    An Attribute domain:
    • A. 

      A set of values that might be asigned to an atribute

    • B. 

      Is a property of an entity or a relationship type

    • C. 

      Is a set of numeric and database values

    • D. 

      None of the above

  • 14. 
    Simple attribute:
    • A. 

      An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity

    • B. 

      An attribute that holds multiple values for a single component

    • C. 

      An attribute that holds a single value for a single entity

    • D. 

      An atribute composed of multiple components each with individual existance

    • E. 

      An atribute composed of a single component with an independent existance

  • 15. 
    Composite attribute:
    • A. 

      An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity

    • B. 

      An attribute that holds multiple values for a single component

    • C. 

      An attribute that holds a single value for a single entity

    • D. 

      An atribute composed of multiple components each with individual existance

    • E. 

      An atribute composed of a single component with an independent existance

  • 16. 
    Single valued attribute:
    • A. 

      An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity

    • B. 

      An attribute that holds multiple values for a single component

    • C. 

      An attribute that holds a single value for a single entity

    • D. 

      An atribute composed of multiple components each with individual existance

    • E. 

      An atribute composed of a single component with an independent existance

  • 17. 
    Multi- valued attribute:
    • A. 

      An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity

    • B. 

      An attribute that holds multiple values for a single component

    • C. 

      An attribute that holds a single value for a single entity

    • D. 

      An atribute composed of multiple components each with individual existance

    • E. 

      An atribute composed of a single component with an independent existance

  • 18. 
    Derived attribute
    • A. 

      An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity

    • B. 

      An attribute that holds multiple values for a single component

    • C. 

      An attribute that holds a single value for a single entity

    • D. 

      An atribute composed of multiple components each with individual existance

    • E. 

      An atribute composed of a single component with an independent existance

  • 19. 
    A Candidate key is an attribute or set of attributes that uniquely identifies individual occurrences of an entity type.
    • A. 

      True

    • B. 

      False

  • 20. 
    The Primary key:
    • A. 

      Uniquely identifies each occurance of an entity type

    • B. 

      Is equivalant with a composite key

    • C. 

      Is the candidate key selected to be a primary key

    • D. 

      All of the above

  • 21. 
    A Composite key is a candidate key that consists of two or more attributes. State true or false. 
    • A. 

      True

    • B. 

      False

  • 22. 
    Degree of a relationship.
    • A. 

      Is always 1

    • B. 

      The number of participating entities in a relationship

    • C. 

      The number of representations in a relationship

    • D. 

      Is always 0

    • E. 

      Is always 0

Related Topics

×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.