Home / CSE / Database System 2 - CS :: Data Modeling with ER

CSE :: Database System 2 - CS

  1. An attribute that names or identifies entity instances is a(n):

  2. A.

     entity.

    B.

     attribute.

    C.

     identifier.

    D.

     relationship.


  3. Properties that describe the characteristics of entities are called:

  4. A.

     entities.

    B.

     attributes.

    C.

     identifiers.

    D.

     relationships.


  5. In which of the following can many entity instances of one type be related to many entity instances of another type?

  6. A.

     One-to-One Relationship

    B.

     One-to-Many Relationship

    C.

     Many-to-Many Relationship

    D.

     Composite Relationship


  7. Entities of a given type are grouped into a(n):

  8. A.

     database.

    B.

     entity class.

    C.

     attribute.

    D.

     ERD.


  9. Which of the following is NOT a basic element of all versions of the E-R model?

  10. A.

     Entities

    B.

     Attributes

    C.

     Relationships

    D.

     Primary keys


  11. In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?

  12. A.

     One-to-One Relationship

    B.

     One-to-Many Relationship

    C.

     Many-to-Many Relationship

    D.

     Composite Relationship


  13. Entities can be associated with one another in which of the following?

  14. A.

     Entities

    B.

     Attributes

    C.

     Identifiers

    D.

     Relationships


  15. Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?

  16. A.

     Supertype entity

    B.

     Subtype entity

    C.

     Archetype entity

    D.

     Instance entity


  17. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

  18. A.

     Supertype entity

    B.

     Subtype entity

    C.

     Archetype entity

    D.

     Instance entity


  19. In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.

  20. A.

     parent

    B.

     child

    C.

     instance

    D.

     subtype