Suppliers often supply several different parts to the company. Shoes Database Shoes are identified by a unique product code. Each customer is identified by a unique customer number. Additional information, such as name, address, and phone are also stored for each customer. Different customers have different buying habits.
Some customers purchase only a single pair of shoes.
Others purchase several different pairs while still others purchase several pairs of identical shoes. All of these types of purchases must be recorded. Additional information about a purchase includes the date of purchase and the quantity of each shoe purchased. Each salesperson is identified by a unique employee number. Each sale is credited to a single salesperson.