Question

Using MySQL Workbench Data Modeler, create a model showing the below table in 3rd Normal Form. Note that you only can model table and column names and data types. The data shown is for your reference to determine functional, partial, and transitive dependencies. PetID PetName PetTyp PetAge Owner VisitDate ProcedureID ProcedureName 246 Chopper Dog 12 Mark Evans Jan 13 2015 1 Rabies Vaccination 246 Chopper Dog 12 Mark Evans Mar 27 2016 10 Examine and Treat Wound 246 Chopper Dog 12 Mark Evans Apr 03 2016 5 Heart Worm Test 298 Riley Dog 2 Tom Terry Jan 21 2015 8 Tetanus Vaccination 298 Riley Dog 2 Tom Terry Mar 12 2016 5 Heart Worm Test 341 Boomer Cat 4 Mark Evans Jan 23 2015 1 Rabies Vaccination 341 Boomer Cat 4 Mark Evans Jan 13 2016 1 Rabies Vaccination 519 Chirpy Bird 2 Tom Terry Apr 30 2016 20 Animal Check Up 519 Chirpy Bird 2 Tom Terry Apr 30 2016 12 Eye Wash

          Using MySQL Workbench Data Modeler, create a model showing the below table in 3rd Normal Form.
Note that you only can model table and column names and data types. The data shown is for your
reference to determine functional, partial, and transitive dependencies.
PetID PetName PetTyp PetAge Owner VisitDate ProcedureID ProcedureName
246 Chopper Dog 12 Mark Evans Jan 13 2015 1 Rabies Vaccination
246 Chopper Dog 12 Mark Evans Mar 27 2016 10 Examine and Treat Wound
246 Chopper Dog 12 Mark Evans Apr 03 2016 5 Heart Worm Test
298 Riley Dog 2 Tom Terry Jan 21 2015 8 Tetanus Vaccination
298 Riley Dog 2 Tom Terry Mar 12 2016 5 Heart Worm Test
341 Boomer Cat 4 Mark Evans Jan 23 2015 1 Rabies Vaccination
341 Boomer Cat 4 Mark Evans Jan 13 2016 1 Rabies Vaccination
519 Chirpy Bird 2 Tom Terry Apr 30 2016 20 Animal Check Up
519 Chirpy Bird 2 Tom Terry Apr 30 2016 12 Eye Wash

Using MySQL Workbench Data Modeler, create a model showing the below table in 3rd Normal Form.
Note that you only can model table and column names and data types. The data shown is for your
reference to determine functional, partial, and transitive dependencies.
PetID PetName PetTyp PetAge Owner VisitDate ProcedureID ProcedureName
246 Chopper Dog 12 Mark Evans Jan 13 2015 1 Rabies Vaccination
246 Chopper Dog 12 Mark Evans Mar 27 2016 10 Examine and Treat Wound
246 Chopper Dog 12 Mark Evans Apr 03 2016 5 Heart Worm Test
298 Riley Dog 2 Tom Terry Jan 21 2015 8 Tetanus Vaccination
298 Riley Dog 2 Tom Terry Mar 12 2016 5 Heart Worm Test
341 Boomer Cat 4 Mark Evans Jan 23 2015 1 Rabies Vaccination
341 Boomer Cat 4 Mark Evans Jan 13 2016 1 Rabies Vaccination
519 Chirpy Bird 2 Tom Terry Apr 30 2016 20 Animal Check Up
519 Chirpy Bird 2 Tom Terry Apr 30 2016 12 Eye Wash

Added by Kimberly L.

Question

Please give Ace some feedback