Pedigree Dog Store

You run a pedigree dog store.

• For each dog, you want to carry information about breed, birth, weight and length at birth, father, mother, prizes won by the father and mother (there can be many prizes so you must prepare for that), and the price you are charging for the dog.
• When the dog is sold, you want to enter the id of the person buying the dog and the date of the sale.
• Because you keep track of the dogs you sell, you want information on the owner including name, address and phone. Note that an owner can buy one or many dogs. You want to be able to query and find out what dogs an owner bought.

You need to implement this in Access showing the tables, data and establishing the relationships.

Using the form and report wizard (extra credit if you do a form or report design on your own – take pictures to show me the steps) create forms and reports showing the information you have collected. One of your reports should show information from multiple tables.

I then want you to query the database;

• Do a query using two tables
• Do a query using two tables where you query for condition 1 and either condition 2 or condition 3.
• Query and find out what dogs an owner has bought.
• Query and find out what prizes the parents won
• Write down criteria for information you would like to see and then create the query to meet the criteria you specified.

Extra Credit if you do the queries in SQL and include a list of the SQL code you wrote.