logo

CuriousTab

CuriousTab

Discussion


Home Database Modeling Data in the Organization Comments

  • Question
  • Which of the following conditions should exist if you want to convert a relationship to an associative entity?


  • Options
  • A. Some of the relationships for the participating entities are "many".
  • B. The resulting associative entity has an independent meaning.
  • C. The resulting associative entity has no attributes.
  • D. All of the above

  • Correct Answer
  • The resulting associative entity has an independent meaning. 


  • Modeling Data in the Organization problems


    Search Results


    • 1. A rectangle represents which of the following in an ERD?

    • Options
    • A. Attribute
    • B. Entity
    • C. Optional One
    • D. Relationship
    • Discuss
    • 2. A binary relationship is which of the following?

    • Options
    • A. A relationship between two attributes
    • B. A relationship between two entities
    • C. An attribute with two different relationships
    • D. An entity with two different relationships
    • Discuss
    • 3. If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?

    • Options
    • A. Derived attribute
    • B. Optional one cardinality
    • C. Multi-valued attribute
    • D. Weak entity
    • Discuss
    • 4. When the minimum number of instances of an entity is one, you know which of the following?

    • Options
    • A. Mandatory one
    • B. Optional one
    • C. Mandatory many
    • D. Cannot tell
    • Discuss
    • 5. An attribute name should be which of the following?

    • Options
    • A. Singular verb or verb phrase
    • B. Follow a standard format
    • C. Use a alias
    • D. All of the above.
    • Discuss
    • 6. A relationship is which of the following?

    • Options
    • A. A person, place, or thing
    • B. Property or characteristic of an entity
    • C. Link between entities
    • D. Weak entity
    • Discuss
    • 7. If no multivalued attributes exist in a relation, then the relation is in what normal form?

    • Options
    • A. First normal form
    • B. Second normal form
    • C. Third normal form
    • D. Fourth normal form
    • Discuss
    • 8. When mapping a many-to-many unary relationship into a relation which of the following is true?

    • Options
    • A. One relation is created.
    • B. Two relations are created.
    • C. Three relations are created.
    • D. Four relations are created.
    • Discuss
    • 9. A foreign key is which of the following?

    • Options
    • A. Any attribute
    • B. The same thing as a primary key
    • C. An attribute that serves as the primary key of another relation
    • D. An attribute that serves no purpose
    • Discuss
    • 10. A primary key is which of the following?

    • Options
    • A. Any attribute
    • B. An attribute that uniquely identifies each row
    • C. An attribute that uniquely identifies each column
    • D. A derived attribute
    • Discuss


    Comments

    There are no comments.

Enter a new Comment