a. Normalize the below given Shipping Manifest form to First Normal Form, Second Normal Form, Third Normal Form and BCNF.

هو فنن الـ shipping manifest

     Shipping Manifest

Shipment ID: 09-15678

Captain Number: 1234

Shipment Date: May 5, 2014

Captain Name: Humaid Khalfan

Origin: Oman

Destination: China

 

 

Export Item Details:

Item Code                  

23411

23413

23415

23424

23476

23412

23422

 

Item name

Sofa

Door

Office Chair

Sofa

Door Knob

Window frame

Office table

 

Category

Furniture

Building Accessory

Furniture

Furniture

Building Accessory

Building Accessory

Furniture

 

Type Description

Leather

Aluminum

Leather

 Accessory

Iron

Aluminum

Wood

 

Weight

400

85

70

300

30

100

250

 

Quantity

150

1500

600

400

600

400

100

 

Total Weight

60,000

127,500

42,000

120,000

18,000

40,000

25,000

 

 

Shipment total weight = 432,500

 

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

 

هذا الجدول ما رضى ينزل ملف ورود