This is a purchase order processing database of Boston Shoes company. The company produces shoes and...
Fantastic news! We've Found the answer you've been seeking!
Question:
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. 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.
Expert Answer:
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
Related Book For
Accounting for Decision Making and Control
ISBN: 978-0078025747
8th edition
Authors: Jerold Zimmerman
Posted Date:
Students also viewed these databases questions
-
A Venezuelan - style economic collapse would be less likely in a mixed economy like the United States. Explain the reason.
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Consider two mutually exclusive investment projects: A 1 and A2. Each project has the same service life, and the present worth of each component value (B, I, and C) is computed at 10% as follows:...
-
Let g(x) = f(x) 2, where f is twice differentiable for all x, f(x) > 0 for all x 0, and f is concave downward on ( , 0) and concave upward on (0, ). (a) At what numbers does g have an extreme value?...
-
A ferryboat, whose speed in still water is 4.00 m/s, must cross a river whose current is 3.00 m/s. The river runs from West to East and the boat is pointed North. 1. If the boat does not compensate...
-
Explain how organizations should choose appropriate T&D methods.
-
Snake Golf Club, Corp., had the following stockholders equity at December 31, 2011: On June 30, 2012, Snake split its common stock 2 for 1. Requirements 1. Make the memorandum entry to record the...
-
On January 1, JKR Shop had $550,000 of beginning inventory at cost. In the first quarter of the year, it purchased $1,690,000 of merchandise, returned $24,100, and paid freight charges of $38,600 on...
-
In cell K3, enter a formula using the COUNTIF function that counts the number of Expansion projects, checking that the column of project types in the Projects table (Projects[Project Type]) is equal...
-
Please answer questions where appropriate. Let x be a numpy array with 4 rows and 4 columns: x = numpy.array( [[ 1, 2, 3, 4], [ 5, 6, 7, 8], [ 9, 10, 11, 12], [13, 14, 15, 16]]) What is the result of...
-
What is a typical R 2 for the characteristic line of an individual stock? For a portfolio?
-
Why are U.S. Treasury bonds not riskless?
-
What are the four main types of bonds?
-
What is a bond?
-
What are some disadvantages of the APT?
-
A. 10.67% B. 8% OC. 6.4% Find the annual simple interest rate of a loan, where $1200 is borrowed and where $1232 is repaid at the end of 4 months. D. 2.67% E. 9%
-
Explain briefly what is meant by electronic data interchange (EDI). How does EDI affect a companys audit trail?
-
The purchasing department at Feder buys all of its raw materials, supplies, and parts. This department is a cost center. It uses a flexible budget based on the number of different items purchased...
-
Telstar Electronics manufactures and imports a wide variety of consumer and industrial electronics, including stereos, televisions, camcorders, telephones, and VCRs. Each line of business ( LOB)...
-
Fuller Aerosols manufactures six different aerosol can products ( room deodorants, hair sprays, furniture polish, and so forth) on its fill line. The fill line mixes the ingredients, adds the...
-
A phenotypically abnormal individual has a phenotypically normal father with an inversion on one copy of chromosome 7 and a phenotypically normal mother without any changes in chromosome structure....
-
Explain why inversions and reciprocal translocations do not usually cause a phenotypic effect. Then explain how they can do so in certain cases.
-
A triploid plant has 18 chromosomes (i.e., 6 chromosomes per set). If we assume that a gamete has an equal probability of receiving one or two copies of each of the 6 types of chromosome, what are...
Study smarter with the SolutionInn App