Question related to normalization

Assignment Help Data Structure & Algorithms

Reference no: EM1380288

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.

Reference no: EM1380288

Questions Cloud

Inventory tracking database : Construct a relational database of your choice. The DB should contain no more than six tables. Define three business requirements that this database will provide.

How does dividend payment affect stock price : What are advantages and disadvantages of stock repurchases relative to traditional dividend payments and how does dividend payment affect stock price? any supporting evidence?

Creating database for a human resources group : Construct a database for a human resources group. List a few different tables and columns to store the HR information.

Question related to normalization : 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.

Create a context level dfd : Create a context level DFD. You should take your DFD to your tutorial for feedback before starting on the ER.

Entity relationship diagrams : Discuss why are Entity Relationship Diagrams an important initial stage in developing databases? Who would be the initial parties interacting to develop the ERDs?

Question about database structure : Determine when a typical database is created the structure is constructed before the data is actually loaded into the database. What problems exist when someone wishes to add or delete from the existing structure?

Deterministic dimensions and rebar area : Performance function for bending of a rectangular reinforced concrete beam under moments due to dead and live loads

User Account

All Pages