logo

CuriousTab

CuriousTab

Discussion


Home Database ER Model and Business Rules Comments

  • Question
  • A rectangle represents which of the following in an EER?


  • Options
  • A. Attribute
  • B. Entity
  • C. Optional One
  • D. Relationship

  • Correct Answer
  • Entity 


  • ER Model and Business Rules problems


    Search Results


    • 1. When an entity instance must be a member of only one subtype, it is which of the following?

    • Options
    • A. Disjoint with total specialization
    • B. Disjoint with partial specialization
    • C. Overlap with total specialization
    • D. Overlap with partial specialization
    • Discuss
    • 2. Inheritance is which of the following?

    • Options
    • A. When a supertype entity inherits values of the subtype attribute
    • B. When a subtype entity inherits values of the supertype attribute
    • C. When a supertype entity inherits values of another supertype attribute
    • D. When a subtype entity inherits values of another subtype attribute
    • Discuss
    • 3. Use of a supertype/subtype relationship is necessary when which of the following exists?

    • Options
    • A. An instance of a subtype participates in a relationship that is unique to that subtype.
    • B. An instance of a subtype participates in a relationship that is the same as the other subtypes.
    • C. Attributes apply to all of the instances of an entity type.
    • D. No attributes apply to any of the instances of an entity type.
    • Discuss
    • 4. A subtype discriminator is which of the following?

    • Options
    • A. An attribute of the supertype whose values determine the subtype
    • B. An attribute of the subtype whose values determine the supertype
    • C. An attribute of the supertype whose values determine the supertype
    • D. An attribute of the subtype whose values determine the subtype
    • Discuss
    • 5. A supertype/subtype hierarchy is which of the following?

    • Options
    • A. Each subtype has only one attribute.
    • B. Each supertype has only one attribute.
    • C. Each subtype has only one supertype.
    • D. Each supertype has only one subtype.
    • Discuss
    • 6. Specialization is which of the following processes?

    • Options
    • A. Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
    • B. Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
    • C. Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.
    • D. Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.
    • Discuss
    • 7. Which of the following statements concerning business rules is true?

    • Options
    • A. It should be complex.
    • B. It should not be convertible to computer code.
    • C. It may include restrictions.
    • D. All of the above.
    • Discuss
    • 8. A secondary key is which of the following?

    • Options
    • A. Nonunique key
    • B. Primary key
    • C. Useful for denormalization decisions
    • D. Determines the tablespace required
    • Discuss
    • 9. Selecting a data type involves which of the following?

    • Options
    • A. Maximize storage space
    • B. Represent most values
    • C. Improve data integrity
    • D. All of the above.
    • Discuss
    • 10. The blocking factor is:

    • Options
    • A. a group of fields stored in adjacent memory.
    • B. the number of physical records per page.
    • C. attributes grouped together by the same primary key.
    • D. attributes grouped together by the same secondary key.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment