Question: 1. Draw the data model for the following. Be sure to indicate the primary key and foreign keys in the model. Use visio or another

1. Draw the data model for the following. Be sure to indicate the primary key and foreign keys in the model. Use visio or another ER modeling tool to solve this problem. Copy the solution and paste it into this document. A sheep farmer shears his sheep every year, at which time he weighs and grades the fleece, a score between 1 and 10 based on the quality of the wool. He has several breeds of sheep and has asked you to create a database so that he can compare the performance of these breeds over an extended period. He has a small farm, so each sheep has a name and identifying ear tag. Draw a data model of this situation. 2. Create the database designed in answer to question 1. Create the tables in the database you use and copy and paste the table creation script here. 3. Populate the tables created in question 2 with at least 3 rows per table. Copy and paste the code you used to populate the tables here
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
