Question: Think about a typical job order that might include the following information. Design a single table to hold all the data needed 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.