Consider a mail order business in which employees take orders or parts from customers. Create a conceptual using the following information.
a. The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code.
b. Each customer of the company is identified by a unique customer number, first and last name, and Zip Code.
c. Each part sold by the company is identified by a unique part number, a part name, price and quantity in stock.
d. Each order placed by a customer is taken by an employee and is give a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.
Required:
Design an ER (Entity-Relationship) diagram for the mail order database and build the design using a data modeling tool such as ERwin or Rational Rose.
Answers: 2
Other questions on the subject: Business
Business, 21.06.2019 23:20, christopherschool04
On october 2, 2016 starbucks corporation reported, on its form 10-k, the following (in millions): total assets $14,329.5 total stockholders' equity 5,890.7 total current liabilities 4,546.9 what did starbucks report as total liabilities on october 2, 2016? select one: a. $12,516.7 million b. $6,377.3 million c. $995.0 million d. $8,438.8 million e. none of the above
Answers: 2
Business, 22.06.2019 13:40, deezzzy
After much consideration, you have chosen cancun over ft. lauderdale as your spring break destination this year. however, spring break is still months away, and you may reverse this decision. which of the following events would prompt you to reverse this decision? a. the marginal cost of going to cancun decreases. b. the marginal cost of going to ft. lauderdale decreases. c. the marginal benefit of going to cancun increases. d. the marginal benefit of going to ft. lauderdale decreases.
Answers: 2
Business, 22.06.2019 19:00, bussbhsvssu557
The market demand curve for a popular teen magazine is given by q = 80 - 10p where p is the magazine price in dollars per issue and q is the weekly magazine circulation in units of 10,000. if the circulation is 400,000 per week at the current price, what is the consumer surplus for a teen reader with maximum willingness to pay of $3 per issue?
Answers: 1
Business, 22.06.2019 19:50, crzyemo865
Aproduction line has three machines a, b, and c, with reliabilities of .96, .86, and .85, respectively. the machines are arranged so that if one breaks down, the others must shut down. engineers are weighing two alternative designs for increasing the line’s reliability. plan 1 involves adding an identical backup line, and plan 2 involves providing a backup for each machine. in either case, three machines (a, b, and c) would be used with reliabilities equal to the original three. a. compute overall system reliability under plan 1. (round your intermediate calculations and final answer to 4 decimal places.) reliability b. compute overall system reliability under plan 2. (round your intermediate calculations and final answer to 4 decimal places.) reliability c. which plan will provide the higher reliability? plan2plan1
Answers: 3
You know the right answer?
Consider a mail order business in which employees take orders or parts from customers. Create a conc...
Questions in other subjects:
Mathematics, 01.09.2020 19:01
English, 01.09.2020 19:01
