Solution-Database normalization solution

Database normalization solution

Assignment Help Database Management System

Reference no: EM13842118

Database Normalization

Normalize the below Orders table to 3NF. Make sure to identify all the entities and their attributes, especially if you make any new items (such as entity or attributes). The following is a list of possible attributes for ORDERS; you may have more:

ORDERS

OrderNo

CustomerNo

CustomerName

CustomerAddress

CustomerCity

CustomerState

CustomerZip

OrderDate

ItemsOrdered

Total

Submit dependency diagrams for all entities you create. The following table is a sample of data, before ORDERS was normalized. Please start with the below table and then write out each dependency diagram as you move from 1NF to 2NF to 3NF. You must show your progress and submit your final document with all dependency diagrams.

The following table is a sample, before ORDERS was normalized:

ORDER NO	ORDER DATE	CUSTOMER NO	CUSTOMER NAME	CUSTOMER ADDRESS	ITEMS ORDERED
100	1/1/99	54545	ACME Co	1234 1^st St.	1A4536, Flange, 7lbs, $75;4-OR2400, Injector, .5lbs, $108;4-OR2403, Injector, .5lbs, $116;1-4I5436, Head, 63lbs, $750
101	1/1/99	12000	Sneed Corp.	555 Main Ave.	1-3X9567, Pump, 5lbs, $62.50
102	1/1/99	66651	ZZZ & Co.	4242 SW 2nd	7-8G9200; Fan, 3lbs, $84;1-8G5437, Fan, 3lbs, $15;1-3H6250, Control, 5lbs, $32
103	1/2/99	54545	ACME Co	1234 1^st St.	40-8G9200, Fan, 3lbs, $480;1-2P5523, Housing, 1lb, $165;1-3X9567, Pump, 5lbs, $42

Reference no: EM13842118

Questions Cloud

Write a java program the displays the state bird : Write a Java program the displays the State bird and flower. The program should prompt the user to enter a State and print both the State bird and flower.

It strategy with the strategy of the business : Your textbook discusses five practices that businesses use to more dynamically link IT strategy with the strategy of the business. In your opinion, which of these five practices do you think would work the best in your organization? Explain in detail..

What amount of interest income would siebens report : Related to this note receivable, what amount of interest income would Siebens report on its 2015 income statement?(Round your final answer to the nearest whole dollar amount.

It strategy development to be successful : What four factors must be in place for IT strategy development to be successful? Using your favorite search engine, locate a company that has a successful IT strategy and explain how these four factors contributed to the company’s success

Database normalization solution : Database Normalization Solution

Module/week relates the story of phineas gage : This module/week relates the story of Phineas Gage, whose name appears in virtually every general psychology textbook. After a heavy metal rod was blown through his frontal and temporal lobes, Phineas experienced dramatic behavioral change. The study..

List and briefly define the key areas comprise network : List and briefly define the key areas that comprise network management. Explain succinctly the difference between the database of a network management system and its MIB. How do you implement each in a network management system

Very large scale integrated : Art Fleming is a design engineer with a proven track record in the field of electronic musical instruments. He recently designed a new VLSI (very large scale integrated) chip. It will take approximately 2 years to turn the VLSI chip into a marketable..

Keeping a community safe and enforcing the law : Imagine working for someone who shows you the basics of your job and then gives you the freedom to decide the best way to get your work done within a given set of rules. In effect, that is the nature of police work and police discretion. Police offic..

User Account

All Pages

Database normalization solution

Reference no: EM13842118

Reference no: EM13842118

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT