When it finds a supplier for a part, it purchases that part exclusively from the selected supplier. 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.