The Case

Happy Hollers (HH) sells West Virginia related products at its store in Morgantown, WV. Customers can email in orders and HH mails the items to the customer. They also email the customer a bill, as seen below. Customers mail in a check, once they receive the order (HH is very trusting!). HH needs to track whether or not an order has been paid.

Order

Order Date:January 12, 2018 Order Number: 999 Customer Number: 100 Customer Name: Fredrick Andersen Customer Email: freddie@leafs.com

Item Num	Item Name	Price	Quantity	Total
HH03	Cookies	$1.00	3	$3.00
HH09	Cups	$5.00	5	$25.00
HH23	Hats	$15.00	1	$15.00

Total Bill: $43.00

HH wants to develop a database to keep track of their customers. Each customer receives a permanent customer number, and HH needs to track their first and last names. Customers can place an order using any email address - HH just needs to know which order came from which email address. Some customers pay an extra $10 to become "preferred" (they get faster shipping). Also, if a customer served in the military, HH wants to keep track of his or her military branch (e.g. Marines, Army, etc.) and highest rank achieved.

HH's items are stored in a back room. When fullfilling an order, an HH employee simply takes them out of inventory, packs them up, and mails them to the customer address on record. HH wants to track which employee packed the items for each order (one employee is assigned to each order). For employees, HH assigns an employee number and tracks their first and last names. HH also needs to know how long the employee has been working for them, as they give bonuses based on length of employment. They also need a list of phone numbers where the employee can be reached. If an employee is not a US citizen, they need to store the employee's visa status, to adhere to employment laws.

At the end of each month, HH's management wants to generate a report showing total sales for the month (broken down by Item). Also at the end of each month, the management needs a printout of each customer's purchases for the month.

The main user of this system will be Dr.Peace, so if you have any questions, see him!

Draw an object model that shows the necessary data components for the database in HH'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!.