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 4th 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 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)
  • Consider the following relations and normalize them into the 4th Normal form.(make sure that you indicate the primary keys and foreign keys)

Patient bill

Patient #: 12345

Date: 7/20/08

Patient Name: Mary Baker

Date admitted: 7/14/08

Patient Address: 300 Oak Street

Discharge date: 7/17/08

City-State-Zip: Boulder, CO 80638

Cost Center

Cost Name

Date Charged

Item Code

Desc

Charge

Bal Due

100

Room & Board

7/14/2008

2000

Semi-prv room

200

7/14/2008

2005

Television

5

7/15/2008

2000

Semi-prv room

200

7/16/2008

2000

semi-prv room

200

Subtotal

605

110

Laboratory

7/14/2008

1580

Glucose

25

7/15/2008

1585

Culture

20

Subtotal

45

125

Radiology

7/15/2008

3010

X-ray chest

30

Subtotal

30

Balance due

680

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]

"Looking for a Similar Assignment? Order now and Get a Discount!

Open chat
Need a Paper Done?
essaywritinghelp.net
Hello
Can we help you?