As a result, there is a need to keep track of the quantity of each part found in each product. Parts are supplied by suppliers. Information stored about suppliers includes a unique supplier number, supplier name, address, and phone number. The company carefully evaluates prospective suppliers for a part. 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.