Explore BrainMass

Explore BrainMass

    Entity Relationship

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    1. Is it possible for two entities to be related to each other in two ways? For example, could entity A be related to entity B both 1:M and 1:1 at the same time?

    a. No, this would violate structural integrity.
    b. Yes, but this should be avoided where possible.
    c. Yes, this is a perfectly acceptable practice when called for.
    d. Yes, this is very desirable and should be sought after.

    2. If a table is in first normal form (1NF) and has a primary key consisting of a single column, the table:

    a. is at most in first normal form.
    b. is also in second normal form.
    c. cannot be in third normal form.
    d. must be in fourth normal form.

    3. Assuming common business practices, the connectivity of the relationship between publishers and books is most likely to be:

    a. One-to-one.
    b. One-to-many.
    c. Many-to-one.
    d. Many-to-many.

    4. E-R Diagrams are oriented reward which of the following data models?

    a. Conceptual level.
    b. Internal level.
    c. External level.
    d. Physical level.

    © BrainMass Inc. brainmass.com October 9, 2019, 11:59 pm ad1c9bdddf

    Solution Summary

    Relationship between entities, 1NF and Data model of ER is discussed.