Question: **Draw an object model with all the necessary components.** Thanks! Johns company sells appliances at his store in Colorado. Johns customers can email in an

**Draw an object model with all the necessary components.** Thanks!

Johns company sells appliances at his store in Colorado. Johns customers can email in an order and the item will be mailed to them. A bill is also emailed to the customer. The customer will mail a check once they have received the order. John needs to track whether or not payment has been received.

Order Date: April, 4th, 2015 Order Number: 123 Customer Number: 215

Customer Name: Jack Smith

Customer Email: JSmith@abc123.com

Item Num

Item Name

Price

Quantity

AB12

Stove

$499.99

1

CD34

Refrigerator

$549.99

1

EF56

Microwave

$199.99

1

Total Bill: $1,249.97

John needs to develop a database to keep track of his customers. Each customer receives a permanent customer number. He also needs to track their first and last names. Customers can place an order using any email address but John needs to know which order came from which email.

One employee is assigned to each order and John needs to track which employee packed the items for each order. John assigns an employee number and tracks their first and last names. He also needs to how long the employees have been working for them because bonuses are given based on employment length. Johns company will need to store employee phone numbers. Also, if an employee is not a US citizen, Johns company will need to store the employees visa status.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!