Business, 15.10.2020 14:01 jarteria0

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

Show answers

Another question on Business

Business, 22.06.2019 01:30

For each example identify the most appropriate ctso

Answers: 3

Answer

Business, 22.06.2019 03:50

Suppose that a worker in agland can produce either 10 units of organic grain or 2 units of incense per year, and a worker in zenland can produce either 5 units of organic grain or 15 units of incense per year. there are 20 workers in agland and 10 workers in zenland. currently the two countries do not trade. agland produces and consumes 100 units of grain and 20 units of incense per year. zenland produces and consumes 50 units of grain and no incense per year. if each country made the decision to specialize in producing the good in which it has a comparative advantage, then the combined yearly output of the two countries would increase by a. 30 units of grain and 100 units of incense. b. 30 units of grain and 150 units of incense. c. 50 units of grain and 90 units of incense. d. 50 units of grain and 130 units of ince

Answers: 1

Answer

Business, 22.06.2019 11:00

Which ranks these careers that employers are most likely to hire from the least to the greatest?

Answers: 2

Answer

Business, 22.06.2019 13:20

Last year, johnson mills had annual revenue of $37,800, cost of goods sold of $23,200, and administrative expenses of $6,300. the firm paid $700 in dividends and had a tax rate of 35 percent. the firm added $2,810 to retained earnings. the firm had no long-term debt. what was the depreciation expense?

Answers: 2

Answer

You know the right answer?

Consider a mail order business in which employees take orders or parts from customers. Create a conc...

Questions