subject
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.

ansver
Answers: 2

Another question on Business

question
Business, 21.06.2019 18:40
Which of the following is most likely to lead to a general decrease in wages? a. elastic demand b. public goods c. an economic recovery d. immigration 2b2t
Answers: 1
question
Business, 22.06.2019 17:40
Adamson company manufactures four lines of garden tools. as a result of an activity analysis, the accounting department has identified eight activity cost pools. each of the product lines is produced in large batches, with the whole plant devoted to one product at a time. classify each of the following activities or costs as either unit-level, batch-level, product-level, or facility-level. activities (a) machining parts. (b) product design. (c) plant maintenance. (d) machine setup. (e) assembling parts. (f) purchasing raw materials. (g) property taxes. (h) painting.
Answers: 2
question
Business, 22.06.2019 22:30
Which of the following situations is most likely to change a buyer's market into a seller's market? a. a natural disaster that drives away a lot of the population. b. the price of building materials suddenly going up. c. the government buys up a lot of houses to build a new freeway. d. a factory laying off a lot of workers in the area.
Answers: 1
question
Business, 22.06.2019 23:40
Joint cost cheyenne, inc. produces three products from a common input. the joint costs for a typical quarter follow: direct materials $45,000 direct labor 55,000 overhead 60,000 the revenues from each product are as follows: product a $75,000 product b 80,000 product c 30,000 management is considering processing product a beyond the split-off point, which would increase the sales value of product a to $116,000. however, to process product a further means that the company must rent some special equipment costing $17,500 per quarter. additional materials and labor also needed would cost $12,650 per quarter. a. what is the gross profit currently being earned by the three products for one quarter? $answer b. what is the effect on quarterly profits if the company decides to process product a further? $answer
Answers: 2
You know the right answer?
Consider a mail order business in which employees take orders or parts from customers. Create a conc...
Questions
question
Business, 31.05.2021 02:50
question
Social Studies, 31.05.2021 02:50
question
Mathematics, 31.05.2021 02:50
question
History, 31.05.2021 02:50
Questions on the website: 13722361