Explore BrainMass
Share

Explore BrainMass

    Normalization

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

    Consider a typical job order that might include the following information. Design a single table to hold all the information required to store a job order including this information. Next, apply normalization to reduce this table to third normal form. Prepare a Word document showing your original and final tables. Include a short summary (2-3 paragraphs) of the problems with the original single table design and how normalization improved the design.

    Orders:

    Job_id
    Scheduled_date
    Client_id
    Client_name
    Client_address
    Client_city
    Client_state
    Task_id
    Task_description
    Task_hours
    Task_rate
    Task_total_cost
    Job_total_cost

    Objective: Communicate with a relational database to create tables, and query and manipulate data.
    Use normalizing and data integrity methodologies when designing a database.

    © BrainMass Inc. brainmass.com October 9, 2019, 8:38 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/normalization-157696

    Solution Summary

    This solution deals with normalizing a database until the Third Normal Form. It also summarizes the three normal forms along with the definition of normalization. It also explains how normalization improves database design.

    $2.19