Explore BrainMass

Explore BrainMass

    database normal form

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    1. Find or create a violation of 1st normal form and demonstrate how you would fix it.
    2. Find or create a violation of 2nd normal form and demonstrate how you would fix it.
    3. Find or create a violation of BCNF and demonstrate how you would fix it.
    4. Find or create an example of a violation of a normal form that you would allow, tell why you are allowing the violation and explain how you would protect against anomalies.

    © BrainMass Inc. brainmass.com March 4, 2021, 5:56 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/database-normal-form-19528

    Solution Preview

    1. Find or create a violation of 1st normal form and demonstrate how you would fix it.

    First normal form requires each attribute in the relation is atomic.

    For the Insurance relation in my design, if we combine Address, City, State, Zip four together called Address attribute, it will violate the first normal form. Because the combined Address attribute will have composite value.

    The original Insurance table is like following:

    Insurance
    InsuranceID Single value
    Name Single value
    Address Single value
    City Single value
    State Single value
    Zip Single value
    Phone Single value
    Deductible Single value
    Cover_rate Single value

    If we change the table to the following:

    Insurance
    InsuranceID Single value
    Name Single value
    Address Composite value
    Phone Single value
    Deductible Single value
    Cover_rate Single value

    In the new table, the address attribute will have composite value, including address, City, State and Zip, which will violate the first normal form. Because use the second design, we cannot trace the Zip, or State, or City information separately.
    Because we cannot retrieve all the information we need using the second design, we should use the table we designed originally. We keep every attribute single valued. Not the second design.

    2. Find or create a violation of 2nd normal form and demonstrate how you would fix it.

    Second normal form requires that all attribute in the relation are fully functional depend on the primary key.

    If we combine table PatientBill and table PatientPayment together in my design, it will violate the second normal form. Because the some of attribute in the relation are not fully ...

    Solution Summary

    This job helps ot find or create an example of a violation of a normal form that you would allow.

    $2.49

    ADVERTISEMENT