Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

**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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions