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.