Explore BrainMass

Explore BrainMass

    Second Normal Form versus Third 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!

    Create a table that is 2NF, but is not 3NF. Explain what is wrong with the table, and what needs to be done to correct the situation.

    © BrainMass Inc. brainmass.com December 16, 2022, 9:20 am ad1c9bdddf
    https://brainmass.com/computer-science/databases/second-normal-versus-third-normal-form-473705

    Solution Preview

    Create a table that is 2NF, but is not 3NF. Explain what is wrong with the table, and what needs to be done to correct the situation.
    Normalization in database design is a process that helps in checking the quality of relations between or amongst entities in the database. In this process relations with problems are converted to relations with lesser problems or anomalies. This thought leads to the number of normal forms that a database can be designed in. A database generally begins with the First Normal Form as coined by database guru E.F. ...

    Solution Summary

    The solution helps explain how to create the 2nd Normal Form and identify what needs to be corrected in the table to change to 3rd Normal Form.

    $2.49

    ADVERTISEMENT