Solution-Normalize the given shipment form to first normal

Normalize the given shipment form to first normal form

Assignment Help Database Management System

Reference no: EM132098363

Task 1:

a) Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify all the entities, attributes of each entity including primary key, not null, relationship between the entities and cardinality constraints. State any assumptions necessary to support your design.

Task 2:

a. Normalize the below given Shipment form to First Normal Form, Second Normal Form and Third Normal Form.

Shipment Summary

Shipment ID: 7878 Manager ID: 1234
Shipment Date: 12/12/2017 Manager Name: Fahad al khindi
Source: Oman
Target: London

Shipment Details:

artifact Code	artifact name	Classification	artifact Type	Load	Quantity	Total Load
23411	Sofa	Furniture	Leather	400	150	60,000
23413	Door	Building Accessory	Aluminum	85	1,500	127,500
23415	Office Chair	Furniture	Leather	70	600	42,000
23424	Sofa	Furniture	Wood	300	400	120,000
23476	Door Knob	Building Accessory	Iron	30	600	18,000
23412	Window frame	Building Accessory	Aluminum	100	400	40,000
23422	Office table	Furniture	Wood	250	100	25,000

Note: Furniture artifacts are made only with leather and wood, similarly Building Accessories are made of Aluminum and iron.

Verified Expert

This task is about database design. The table is provided with meeting data. The table is first normalized and then ERD is created. The ERD is normalized up to 3rd normal form.

Reference no: EM132098363

Questions Cloud

Examine an adverse selection problem your company facing : Examine an adverse selection problem your company is facing and recommend how it should minimize its negative impact on transactions.

Solidify deal with major automotive parts company : Your company is trying to solidify a deal with a major automotive parts company from Detroit,

To accommodate the changes in the book selling market : To accommodate the changes in the book selling market, publishers changed their pricing approach so that

What do you suppose has happened to federal collections : Willard Taylor, a tax attorney with Sullivan & Cromwell LLP, is contemplating the latest trend among U.S. firms that have been opting to become corporations.

Normalize the given shipment form to first normal form : Identify all the entities, attributes of each entity including primary key, not null, relationship between the entities and cardinality constraints

Determine what would be the market price and quantity : Market demand for electricity is given by P = 2 - 0.0001Q. If Punggol Power Co. set prices as though it were a perfectly competitive firm.

Benefits and costs of globalization : How does the Singapore case illustrate some of the benefits and costs of globalization?

Discuss security issues related to the researched technology : Select a Wi-Fi device you are familiar with and analyze the security protection currently implemented on the device.

Replacing striking workers-can management do it : Can an employee be fired for ‘protesting’? While at work? Outside of work hours? Explain. Replacing striking workers: Can management do it? Explain.

Reviews

inf2098363

10/16/2018 11:49:52 PM

I provided them with my requirement a few days before and it was a quick response in order placing making payment and delivering the solution they are very much organised and prompt services...Thank you for my assignment. Will consider you only for my further homework.

Write a Review

Required(*) Message

User Account

All Pages

Normalize the given shipment form to first normal form

Reference no: EM132098363

Reference no: EM132098363

Questions Cloud

Reviews

inf2098363

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