logo

CuriousTab

CuriousTab

Discussion


Home Database Data Models into Database Designs Comments

  • Question
  • An ideal primary key is short, numeric and seldom changing.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Data Models into Database Designs problems


    Search Results


    • 1. When the parent entity is required and the parent has a surrogate key, update actions can be ignored.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. When the parent entity is required, a new child row can always be inserted.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. Surrogate keys have much meaning for users.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. Cascading updates refers to child rows being automatically deleted when a parent row is deleted.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. Intersection tables are ID-dependent on both their parent tables.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. The terms alternate key and candidate key mean the same thing.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. The data model produced from the reverse engineering process does not include intersection table data.

    • Options
    • A. True
    • B. False
    • Discuss


    Comments

    There are no comments.

Enter a new Comment