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!

Is this data in 1NF? Why or Why Not?

Handraw a relational schema and diagram the functional dependencies.

Develop a set of 3NF relations.

2. (5 points) Build an E-R diagram in MySQL. Are these becoming more comfortable? Do you have any open questions about the data or did you have to make any assumptions? Be sure to document any assumptions or questions!

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! HAND DRAW a relational schema and diagram the...

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:

I will scan the rest of the assignment to this question. Assignment 3 Due Date: Sunday, October 2, 2022 The total number of points for this assignment is 60 points. Please submit your assignment in a...

Q:

Assignment 3 Due Date: Sunday, October 2, 2022 The total number of points for this assignment is 60 points. Please submit your assignment in a Word file. Use this assignment file as a template to...

Q:

help get the answers.. its a complete question 1. (10 points) Annie and David are painting their apartment. At the paint store, David says he prefers Canary Yellow to Bumblebee Yellow, Lime Yellow,...

Q:

Practice Section You may want to download and open the Practice Database in Lesson 4 in Microsoft Access (Admissions Student Database.mdb; Please note that this database is graciously provided...

Q:

1 MGTC 319 Decision Making in the Business Environment Week 2 Assignments Reading and Research: Putting DMAIC of Six Sigma in practice - Sanders, Matthew; Prior, Alex, International Journal of...

Q:

A uniform thin solid door has height 2.20 m, width 0.870 m, and mass 23.0 kg. Find its moment of inertia for rotation on its hinges. Is any piece of data unnecessary?

Q:

(a) If the mass of 1.0 kg of coal (or any substance) could be completely converted into energy, how many kilo-watt-hours of energy would be produced? (b) Assume that the average U. S. family of four...

Q:

2. Rene and Steve Burrows are in their mid-thirties and have two children, ages 8 and 5. They have combined annual income of $95,000 and own a house in joint tenancy with a market value of $310,000,...

Q:

K On Sept 1, Fliteboard USA received an invoice for office cleaning fee for $500. Fliteboard plans to pay this invoice on Sept 30. What is the Journal Entry for Sept 30? . OB. O C. O D. Expense...

Q:

11. Distance learning can be used to deliver a lecture to geographically dispersed trainees. How might distance learning be designed and used to avoid some of the learning and transfer of training...

Q:

12. Why would a company use a combination of face-to-face instruction and Web-based training?

Q:

1. Using only the Web, further investigate any new technology discussed in this chapter. Utilizing any search engine on the Web (e.g., Google, Yahoo), conduct a search for information about the...