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.
Objective: Communicate with a relational database to create tables, and query and manipulate data.
Use normalizing and data integrity methodologies when designing a database.
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.