USA: +1 508 290 1604 
Sign in
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
