Pedigree Dog Store
You run a pedigree dog store. You have two types of products - dogs and dog supplies. You
want to carry very different information for each.
For dogs, 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, 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 ownder including name, address and phone.
For products you want to carry standard inventory information such as: name, vendor, price, cost,
on hand, on order, reorder point. You also want to carry vendor information. Sales are
made in the store so there is no record of sales. Adjustments are made to the onhand.
Records of orders to the vendor should be kept and when orders are received they should
alter the onhand and the onorder.
Design the database that can be used by your store.