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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started