make forth normal form

I need support with this Business question so I can learn better.

Exam 2 Part 2 (15 points)

• Take a look at the following report and normalize it to the 4^th normal form. (make sure that you indicate the primary keys and foreign keys)
• Consider the following relation that keeps track of the sales of a wholesale dealer in trousers: Normalize the relation to the 4th normal form. (make sure that you indicate the primary keys and foreign keys)
• Take a look at the following report and normalize it to the 4^th normal form. (make sure that you indicate the primary keys and foreign keys)
• Consider the following relations and normalize them into the 4th Normal form.(make sure that you indicate the primary keys and foreign keys)
• Consider the following relations and normalize them into the 4th Normal form.(make sure that you indicate the primary keys and foreign keys)

TrousersSold (customerID, customerName, model, size, day, numberSold, price)

Suppose the following functional dependencies hold on the relation:

customerID ->customerName

customerID, model, size, day ->numberSold

model, size ->price

model, price -> size

INVOICE

HILLTOP ANIMAL HOSPITALDATE: JAN 13/2002

INVOICE # 987

MR. RICHARD COOK

123 THIS STREET

MY CITY, ONTARIO

Z5Z 6G6

PETPROCEDUREAMOUNT

ROVER RABIES VACCINATION30.00

MORRISRABIES VACCINATION24.00

TOTAL54.00

TAX (8%) 4.32

AMOUNT OWING58.32

Shipping (ShipName, ShipType, VoyageID, Cargo, Port, Date)

Hint: Date is the date the ship arrives in the given Port

With the functional dependencies:

ShipName-> ShipType

VoyageID-> ShipName, Cargo

ShipName, Date -> VoyageID, Port

STORE_ITEM (SKU, PromotionID, Vendor, Style, Price)

With the functional dependencies:

SKU, PromotionID -> Vendor, Style, Price

SKU -> Vendor, Style

[opskill_register_order]