Reference no: EM132286969

The Case

Express Delivery (ED) is a Morgantown based home goods company. Customers can call in orders and ED mails the items to the customer. They also email the customers a bill, as seen below. Customers can mail in a check, once they receive the order. ED needs to track whether the order has been paid or not, but the payment information is handled by a third-party vendor.

ED needs to create a database to track their customers. Each customer receives a permanent ID when they call in. While on the phone, they also gather information regarding the customer's name, address, and email. A customer can have multiple emails, but we need only one email to be on the order. Customers can be of two types – individuals and corporate. Corporate customers have a tax id number that has to be stored by the company.

ED’s products are stored in a back room. The employee sends the products to the address on file for each specific order. ED wants to track which employee packed the products for each order (one employee is assigned to each order). Employee’s first and last name, address, phone numbers, and how long the employee has worked for the company needs to be tracked.

Draw an object model that shows the necessary data components for the database in ST's new system. If you make assumptions (which you should keep to an absolute minimum!), make sure to list them in detail. Include all calculated fields needed to create the order shown above.