Posted: June 2nd, 2021

Database assignment visio | Computer Science homework help


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


Name: __________________________



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



Using the sample report below put the data elements in the report into their normal forms using relational notation (relational notation was first shown in your textbook on page 38). Just to be clear, I want to see (using relational notation) what this report looks like in 1NF, 2NF, and 3NF.


Sample Report Data Source:




PET ID      PET NAME                PET TYPE  PET AGE   OWNER                  VISIT DATE              PROCEDURE

246            ROVER                      DOG             12              SAM COOK           JAN 13/2002               01 – RABIES VACCINATION

                                                                                                                              MAR 27/2002             10 – EXAMINE and TREAT WOUND

                                                                                                                              APR 02/2002              05 – HEART WORM TEST


298            SPOT                          DOG             2                TERRY KIM          JAN 21/2002               08 – TETANUS VACCINATION     

                                                                                                                              MAR 10/2002             05 – HEART WORM TEST


341            MORRIS                    CAT              4                SAM COOK           JAN 23/2001               01 – RABIES VACCINATION

                                                                                                                              JAN 13/2002               01 – RABIES VACCINATION


519            TWEEDY                   BIRD            2                TERRY KIM          APR 30/2002              20 – ANNUAL CHECK UP

                                                                                                                              APR 30/2002              12 – EYE WASH


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















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.



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:
error: Content is protected !!
Open chat
Order through WhatsApp!
You Can Now Place your Order through WhatsApp


Order your essay today and save 30% with the discount code DISCOUNTS2022