Database Normalization Exercise – Computer Science homework help – Assignment Help

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper

 

 

Name: __________________________

 

 

Sample Invoice Data Source:

 

 

                               INVOICE

 

 

HILLTOP ANIMAL HOSPITAL                                  DATE: JAN 13/2002

INVOICE # 987

 

MR. RICHARD COOKIES                           

123 THIS STREET

GLENDALE, CA                           

91202                                       

 

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.

 

 

1NF:

 

 

 

 

 

2NF:

 

 

 

 

 

 

3NF:

 

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.

                             

 

 


Assignment Pro (28431)
New York University
Is this question part of your assignment?

Sign up to get the full answer

Get Answer
   

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)
Have an assignment question? Get help from Expert tutors!
Your time is important. Let us write you an essay from scratch
100% plagiarism free
Sources and citations are provided
Stuck? We have tutors online 24/7 who can help
you get an A grade paper.
Ask Expert Tutors
Answer in as fast as 15 minites

Are you looking for Assignment Help save 20% with this code BIXBY