This is a purchase order processing database of Boston Shoes company. The company produces shoes and sells them to...

  

Transcribed Image Text:

This is a purchase order processing database of Boston Shoes company. The company produces shoes and sells them to various retail stores. The following is a description of the order processing database and other relevant information. 1. The customers of Boston Shoes are retail stores, such as Walmart, Target, Kohls, etc. Each customer has one headquarter and one or more branch stores. 2. For each customer headquarter, we want to store a unique customer ID, the name of the customer, the address, and the phone number. 3. For each branch store of a customer, we want to keep a branch number, address, and phone number. A branch number is a sequence number starting with 1 and is not unique among all branch stores. It is unique only among those that belong to the same retail store. For example, Walmart has three branch stores and their branch numbers are 1, 2, and 3; Target has two branch stores and their branch numbers are 1 and 2. 4. The Boston Shoes company produces different types of shoes. For each shoe type, we want to store unique type ID, type name (casual, walking, running, etc.), size, and price. 5. An order is issued by a retail store headquarter. For each order, we want to keep the following information. (1) A unique order number (2) The retail store who issued the order (3) Order date and order amount (4) The employee(s) of the Boston Shoes who handle the order 6. An order consists of one or more suborders. Each suborder has a suborder number. This suborder number is a sequence number starting with 1 and is not unique among all suborders. It is unique only among those that belong to a particular order. A suborder is shipped to exactly one branch store. A suborder includes one or more shoe types. We also want to store the 6. An order consists of one or more suborders. Each suborder has a suborder number. This suborder number is a sequence number starting with 1 and is not unique among all suborders. It is unique only among those that belong to a particular order. A suborder is shipped to exactly one branch store. A suborder includes one or more shoe types. We also want to store the following information for each suborder in the database: (1) Suborder number (2) The branch store the suborder is shipped to (3) Required shipping date (4) Actual shipping date (5) The quantity of each shoe type included in the suborder. 7. For each employee in the Boston Shoes, we want to keep a unique employee ID, name, salary, address, and classification. 8. An order is handled by exactly one employee, and an employee handles at most four orders.

Answer rating: 100% (QA)

The provided information outlines the structure and key components of a database that is used for ma View the full answer