Database Normalization ExerciseWaqas Ahmed
Sample Invoice Data Source:
HILLTOP ANIMAL HOSPITAL DATE: JAN 13/2002
INVOICE # 987
MR. RICHARD COOKIES
123 THIS STREET
PET PROCEDURE AMOUNT
ROVER RABIES VACCINATION 30.00
MORRIS RABIES VACCINATION 24.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.
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.
- 5 years ago
- for A-plus writer only
- Forum: "My Father Addresses Me on the Facts of Old Age" by Grace Paley
- In analyzing hits by V-1 buzz bombs in World War II
- Read the following problem
- BUSN379_Course_Project_Part_I_v2 Question
- For Lab 2, please review Chapter 3 in your textbook. This lab involves a projectile being fired upward at an...
- Help with computer discussion homework
- For smart zena Financial Instrument
- Logistic Steps for airlines and delivery company's