Normalization Assignment Normalize the following relations Show possible candidate keys and the functional dependencies Explain the normal form in which the relation is currently in (based on the sample data) and how do you break the relations to get 3 rd Normal Form Show the new relations obtained after normalization and underline the candidate primary key in each new relation Relation 1 SHIPMENT (Shipment , Origin, Destination, Distance) (Illustrated with sample data) Shipment Origin Destination Distance 409 Seattle Denver 1330 618 Chicago Dallas 960 723 Boston Atlanta 1100 824 Denver Los Angeles 100 629 Seattle Denver 1330 Relation 2 PART SUPPLIER (PartNo, Description, VendorName, Address, UnitCost) (Illustrated with sample data) PartNo Description VendorName Address UnitCost 1234 Logic Chip Fast Chips Cupertino 10 00 1234 Logic Chip Smart Chips Phoenix 8 00 5678 Memory Chip Fast Chips Cupertino 3 00 5678 Memory Chip Quality Chips Austin 2 00 5678 Memory Chip Smart Chips Phoenix 5 00

The Answer is in the image, click to view ...

Question: Normalization Assignment Normalize the following relations. Show possible candidate keys and the functional dependencies. Explain the normal form in which the relation is currently in

Normalization Assignment

Normalize the following relations. Show possible candidate keys and the functional dependencies. Explain the normal form in which the relation is currently in (based on the sample data) and how do you break the relations to get 3^rd Normal Form. Show the new relations obtained after normalization and underline the candidate/primary key in each new relation.

Relation 1:

SHIPMENT (Shipment#, Origin, Destination, Distance)

(Illustrated with sample data)

Shipment#	Origin	Destination	Distance
409	Seattle	Denver	1330
618	Chicago	Dallas	960
723	Boston	Atlanta	1100
824	Denver	Los Angeles	100
629	Seattle	Denver	1330

Relation 2:

PART SUPPLIER (PartNo, Description, VendorName, Address, UnitCost)

(Illustrated with sample data)

PartNo	Description	VendorName	Address	UnitCost
1234	Logic Chip	Fast Chips	Cupertino	10.00
1234	Logic Chip	Smart Chips	Phoenix	8.00
5678	Memory Chip	Fast Chips	Cupertino	3.00
5678	Memory Chip	Quality Chips	Austin	2.00
5678	Memory Chip	Smart Chips	Phoenix	5.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Normalization Assignment Normalize the following relations. Show possible candidate keys and the functional dependencies. Explain the normal form in which the relation is currently in ( based on the...

Q 1 [ 5 Marks ] : Normalize the following relation. Show possible candidate / primary keys and the functional dependencies. Explain the normal form in which the relation is currently in ( based on...

QUESTION Normalize the following relations when each one satisfies the specified functional dependencies. Decompose into the highest possible normal form. Show your work ONE STEP at a time. In...

Exercises on Normalization Given the relation and functional dependencies; Example: STUDENT ( StudentNo , Name, PrimaryMajor, School ) FDs: StudentNo - > Name, PrimaryMajor, PrimaryMajor - > School 1...

This is my college Database coursework. I have a problem regarding making the erd diagrams and normalization(UNF, 1NF, 2NF, 3NF). I hope you would help me in making this along with the final erd...

Introduction This research paper mainly focuses on history of evolvement of normalization from a set of relation schemas, along with sequential normalization forms with suitable examples. This paper...

The second task is to perform functional dependency analysis of each mapped relation and normalize it into third normal form (3NF) relations. If the ER model mapping is done correctly, the mapped...

Introduction In relational databases the term normalization refers to a reversible step-by-step process in which a given set of relations is replaced by successive collections of relations that have...

I need some assistance with my project proposal and its overview, my systems analysis and entity-relation diagram(ERD) and overall database creation. I am using Microsoft Visio and MS SQL 2012 as...

Bunsen Companys cash collections average $10,000 per day. Because Bunsens customers are scattered across the country, the average interval between when a customer writes a check and when the check...

Use implicit differentiation to find the equation of the tangent line to the curve x2 / 9 - y2 / 16 = 1 at the point (9, 8(2)?

The derivatives market is very thinly regulated and regulations are rarely enforced in the name of market efficiency and "free market" capitalism. 1 0 years after LTCM went bankrupt ( bought out by...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Assume that the banking system has total reserves of $100 billion. Assume also that required reserves are 10 percent of checking deposits and that banks hold no excess reserves and households hold no...

As shown in Figure 3, the overall labor-force participation rate of men declined between 1970 and 2000. At the same time, the labor-force participation rate of women increased sharply. This overall...

The Bureau of Labor Statistics announced that in February 2008, of all adult Americans, 145,993,000 were employed, 7,381,000 were unemployed, and 79,436,000 were not in the labor force. Use this...