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.

Northern lights electronics just completed plans to distribute its new tablet. the product has several unique features that differentiate it from competitor products. the marketing team plans to begin a roll-out with to only one traditional retailer for the first two months. this strategy will give consumers the perception of the product’s stand-out personality and increase demand. marketing will proceed with for the next four months, where it plans to distribute to three other retailers, as well. for the last six months of the year, it will initiate distribution agreements with discount retailers and online retailers, and any other electronics store that wants to carry it. the marketing team is confident that the tablet will cycle through the first three stages of its product life cycle quickly. as the tablet reaches maturity during the second half of its first year in the market, it is good strategy to proceed with as described above. intensive distribution; selective distribution; exclusive distribution exclusive distribution; selective distribution; intensive distribution tertiary level distribution; secondary level distribution; mono-level distribution mono-level distribution; secondary level distribution; tertiary level distribution