Posted: February 18th, 2021

Database normalization exercise | Computer Science homework help



Name: __________________________



Sample Invoice Data Source:






HILLTOP ANIMAL HOSPITAL                                  DATE: JAN 13/2002



MR. RICHARD COOKIES                           


GLENDALE, CA                           



PET                   PROCEDURE                               AMOUNT           


ROVER               RABIES VACCINATION                  30.00

MORRIS             RABIES VACCINATION                  24.00



                        TOTAL                                       54.00

                        TAX (8%)                                   4.32


                        AMOUNT OWING                         58.32   




List the relational notation for each normal form (e.g. Invoice (abc, def, ghi):

Some find it easier to first draw out a conceptual model with entities and relationships before starting on the relational notation, but this is up to you.


















Part II


Using your completed part 1 document as input, create a new logical ERD using Visio 2013 (Crow’s Foot Database Notation template). I want to see you map your 3NF relational notation into an ERD in Visio. 

When your done creating the ERD in Visio submit your completed Visio file (PetInvoice.vsdx or whatever you decide to name the file) to me for grading via the upload link.




Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: