Question: 1. (10 points) Download the spreadsheet titled Assignment #5 Data and evaluate its contents. Be certain that you are looking at all of the data!

1. (10 points) Download the spreadsheet titled Assignment #5 Data and evaluate its contents. Be certain that you are looking at all of the data!

HAND DRAW a relational schema and diagram the functional dependencies. (I need it draw, please. I read the explanation on how to do it but I am still struggling on how to draw it)

Develop a set of 3NF relations.

PetID PetName Species Gender Age OwnerID OwnerName Surname StreetAddress City State StateFull ZipCode ProcedureDate ProcedureType ProcedureSubCode Description Price
T0-5705 Biscuit Dog female 5 5833 Mary Hurtado 4865 Juniper Drive Saint Charles MI Michigan 48655 11/4/16 0:00 VACCINATIONS 5 Rabies 10
N6-7350 Biscuit Dog female 8 3518 Connie Pauley 1539 Cunningham Court Bloomfield Township MI Michigan 48302
S4-0789 Biscuit Dog female 10 7101 Bessie Yen 30 Cunningham Court Rochester Hills MI Michigan 48306
U4-6674 Biscuit Dog female 1 3663 Lena Haliburton 4217 Twin Oaks Drive Traverse City MI Michigan 49684
I6-9459 Biscuit Dog female 4 6049 Debbie Metivier 315 Goff Avenue Grand Rapids MI Michigan 49503
O6-3123 Biscuit Dog female 2 6194 Karen Torres 3941 Ritter Avenue Center Line MI Michigan 48015 9/11/16 0:00 VACCINATIONS 5 Rabies 10
R4-6131 Biscuit Dog female 5 2863 John Sebastian 3221 Perry Street Davison MI Michigan 48423
U8-6473 Biscuit Dog female 3 1070 Jessica Velazquez 3861 Woodbridge Lane Southfield MI Michigan 48034 8/19/16 0:00 GROOMING 1 Bath 15
U8-6473 Biscuit Dog female 3 1070 Jessica Velazquez 3861 Woodbridge Lane Southfield MI Michigan 48034 7/10/16 0:00 VACCINATIONS 5 Rabies 10
U8-6473 Biscuit Dog female 3 1070 Jessica Velazquez 3861 Woodbridge Lane Southfield MI Michigan 48034 7/10/16 0:00 VACCINATIONS 6 Bordetella 10

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

1. (10 points) Download the spreadsheet titled Assignment #5 Data and evaluate its contents. Be certain that you are looking at all of the data! Draw a relational schema and diagram the functional...

Q:

1. (10 points) Download the spreadsheet titled Assignment #5 Data and evaluate its contents. Be certain that you are looking at all of the data! Is this data in 1NF? Why or Why Not? Handraw a...

Q:

Management and use of databases Instructions: We have been asked to help a local veterinary clinic build a database to help manage their data. They have sent a small subset of data from their current...

Q:

The total number of points for this assignment is 120 points. Please submit your assignment in a Word file. Use this assignment file as a template to enter and copy-paste your answers for your...

Q:

Hawkeye Football Programs - Part I Summary Motivated by contract negotiations with a publishing company, the University of Iowa's Sports Information office is examining its current protocol for...

Q:

School of Computing and Information Technology Session: Spring 2023 University of Wollongong Lecturer: Janusz R. Getta ISIT912 Big Data Management Assignment 2 Published on 21 August 2023 Scope The...

Q:

please show me the formula or how you get the answers please go down and take it look...i have taken new photo that is clear Accounting 365 Flex Budget Project Instruction BEFORE YOU NON HEAD CLOSELY...

Q:

MNG3702/101/3/2016 Tutorial Letter 101/3/2016 Strategy Implementation and Control MNG3702 Semesters 1 and 2 Department of Business Management PLEASE NOTE: This tutorial letter contains important...

Q:

MNG3702/101/3/2016 Tutorial Letter 101/3/2016 Strategy Implementation and Control MNG3702 Semesters 1 and 2 Department of Business Management PLEASE NOTE: This tutorial letter contains important...

Q:

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

Q:

Mark is painting his house. The blue paint for the siding is $14 per gallon and the white paint for the trim is $12 per gallon. Altogether he bought 12 gallons and spent $160. How many of each did he...

Q:

Was there an accord and satisfaction, discharging the debt? Jim Henches, a licensed massage therapist, treated Benjamin Taylor after he was injured in a car accident. When all treatments were...

Q:

A motor runs on diesel. Initially there are 40 litres of diesel in the fuel tank. The motor uses 5 litres per hour. After h hours there are f litres of diesel remaining. a Explain why f = 40 5h b...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

=+ what roles should government play in them ?

Q:

=+ Why do we have markets and, according to economists,

Q:

=+1. Give three examples of important trade-offs that you face in your life.