Explore BrainMass
Share

Normalization

This content was STOLEN 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 24, 2018, 10:23 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
See Also This Related BrainMass Solution

Normalization and Optimization

Do explain the process of Normalization?
Explain the context in which Normalization is used?
What is its purpose?
What are the steps to be taken?
What do we actually do when we normalize?
Would you describe Normalization as Science or Art?

Dedicate your last paragraph to Optimization (de-normalization)

View Full Posting Details