Purchase Solution

Normalization

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

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.

Purchase this Solution


Free BrainMass Quizzes
Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Networking Questions

This quiz consists of some basic networking questions.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Javscript Basics

Quiz on basics of javascript programming language.