Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am trying to put the table below in 3NF (Third Normal Form) but I am unsure if I did it correctly? The last image
I am trying to put the table below in 3NF (Third Normal Form) but I am unsure if I did it correctly? The last image is what i have created. Please let me know if I am making any errors.
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. PetlD PetName [PetTy PetAge Owner VisitDate ProcedurelD ProcedureName 1 Rabies Vaccination 10 Examine and Treat Wound 246 Chopper Dog12 Mark Evans Jan 13 2015 246 Chopper Dog12 Mark Evans Mar 27 2016 12 Mark Evans Apr 03 2016 2 Tom Terry Jan 21 2015 298 Riley Dog2 Tom Terry Mar 12 2016 4 Mark Evans Jan 23 2015 4 Mark Evans Jan 13 2016 19 Chirpy Bird2 Tom Terry Apr 30 2016 519 Chirpy Bird2Tom TerryApr 30 2016 5 Heart Worm Test 8 Tetanus Vaccination 5 Heart Worm Test 1 Rabies Vaccination 1 Rabies Vaccination 246 Chopper Dog 298 Riley Dog 341 BoomerCat 20 Animal Check Up 12 Eye WashStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started