logo

CuriousTab

CuriousTab

Discussion


Home Database Database Design Using Normalization Comments

  • Question
  • The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Database Design Using Normalization problems


    Search Results


    • 1. The design guidelines and priorities for read-only databases are different because read-only databases are never updated.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. Proper normalization eliminates duplicated data.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. The DBMS allows surrogate keys to be changed.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. For every relationship, there are six possible referential integrity actions.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. In 1:N relationships, which entity becomes the parent entity is arbitrary.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. A foreign key is used to implement relationships between tables.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. All primary keys are required.

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


    Comments

    There are no comments.

Enter a new Comment