Scribd
Upload
4K views2 pages

Invoice Normalization for Pet Vaccinations

The document is an invoice from Hilltop Animal Hospital dated January 13, 2002 billing Mr. Richard Cook of Ontario for rabies vaccinations for his pets Rover and Morris. Rover received a rabies vaccination for $30 and Morris received one for $24, with a total due of $58.32 including taxes.

Uploaded by

Anonymous 8y7rzY
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4K views2 pages

Invoice Normalization for Pet Vaccinations

The document is an invoice from Hilltop Animal Hospital dated January 13, 2002 billing Mr. Richard Cook of Ontario for rabies vaccinations for his pets Rover and Morris. Rover received a rabies vaccination for $30 and Morris received one for $24, with a total due of $58.32 including taxes.

Uploaded by

Anonymous 8y7rzY
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Nama : Ayu Nur’aini

NIM : 16/401506/SV/12010
Kelas : rekmed c

Normalization Exercise 2

INVOICE
HILLTOP ANIMAL HOSPITAL DATE JAN 13/2002
INVOICE # 987

MR. RICHARD COOK


123 THIS STREET
MY CITY, ONTARIO
Z5Z 6G6

PET PROCEDURE AMOUNT


ROVER RABIES VACCINATION 30.00
MORRIS RABBIES VACCINATION 24.00

TOTAL 54.00
TAX (8%) 4.32
AMOUNT OWING 58.32

UNF : invoice [invoice_no, invoice_date, cust_name, cust_addr, (pet_name, procedure, amount)]

Invoice_no Invoice_date Cust_name Cust_addres Pet


987 Jan 13/2002 Mr.Richard Cook 123 This Street, Rover, Rabies
My City, Ontario Vaccination, 30.00
Morris, Rabies
Vaccination, 24.00

1NF :
invoice [invoice_no, invoice_date, cust_name, cust_addr]

Invoice_no Invoice_date Cust_name Cust_addr


987 Jan 13/2002 Mr. Richard Cook Ontario

invoice_pet [invoice_no, pet_id, pet_name, procedure, amount ]


Invoice_no Pet_id Pet_name Procedure Amount
987 001 Rover Rabies Vaccination 30,00
987 002 Morris Rabies Vaccination 24,00

2NF :
invoice [ invoice_no,invoice_date, cust_name, cust_addr ]
Invoice_no Invoice_date Cust_name Cust_addr
987 Jan 13/2002 Mr. Richard Cook Ontario

invoice_pet [ invoice_no, pet_id, procedure, amount ]

Invoice_no Pet_id Procedure Amount


987 001 Rabies Vaccination 30,00
987 002 Rabies Raccination 24,00

pet [ pet_id, pet_name ]


Pet_id Pet_name
001 Rover
002 Morris

3NF :
invoice [ invoice_no, invoice_date, cust_no, (FK) ]
Invoice_no Invoice_date Cust_no (FK)
987 Jan 13/2002 1

invoice_pet [ invoice_no (FK), pet_id (FK), procedure, amount ]


Invoice_no(FK) Pet_id (FK) procedure amount
987 001 Rabies Vaccination 30,00
987 002 Rabies Vaccination 24,00

pet [ pet_id, pet_name ]


Pet_id Pet_name
001 Rover
002 Morris

customer [ cust_no, cust_name, cust_street, cust_city, cust_psticd ]


Cust_no Cust_name street Cust_city Cust_psticd
1 Mr. Richard Cook 123 This Street Ontario

Nama : Ayu Nur’aini NIM : 16/401506/SV/12010 Kelas : rekmed c Normalization Exercise 2 INVOICE HILLTOP ANIMAL HOSP
987 001 Rover Rabies Vaccination 30,00 987 002 Morris Rabies Vaccination 24,00 2NF : invoice [ invoice_no,in

You might also like