Pedigree Dog Store – dog information

You run a pedigree dog store. You want to keep a file on dogs that are available and you want to keep a history file of dogs that you have had available and their parents. When a dog is sold, the record about the dog is moved from the available file to the history file.

• For the dogs you have available, you want to carry information about their 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 and moved to the history file, 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.

Design the database that can be used by your store.