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.