Question

When we receive an order, we check each line item on the order to see if...

When we receive an order, we check each line item on the order to see if we have the goods in stock. If we do, we assign the goods to the order. If this assignment sends the quantity of those goods in stock below the reorder level, we reorder the goods. While we are doing this, we check to see if the payment is OK. If the payment is OK and we have the goods in stock, we dispatch the order. If the payment is OK but we do not have the goods, we leave the order waiting. If the payment is not OK, we cancel the order.

Identify the correct model to represent it and build it!

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Step1. First you have to identify the object before creating model

Here is the possible object which i can identify in this :

Supplier, Product, Customer, Order

we can create more object if needed as follows

Product Price, Customer Address, Customer Order, Customers ordered product, customer order dilivery, Addresses, Supplier Address,

Step 2 identify the relation ship between these object

Supplier 1---------* Products

Product --------- Product Price

Product ---------- Customer ordered product

Customer ----------- Customer Order

Customer ----------- Customer Address

Customer order ------------- customer order products

Customer Order ------------- Customer order dilivery

Customer Address ---------- Address

Step 3: Once you are able to identify relationship between object its easior to create model as shown below

Suppliers PK,FK1 row 1 Customers Customer Address Address PK uniqueld row 1 row 2 row 3 PK uniqueld row 1 row 2 row 3 PK,FK2row 2 PK,FK1 row 1 PK,FK2 row 2 row 1 row 1 Products Customer Order PK uniqueld row 1 row 2 row 3 PK uniqueld row 1 row 2 row 3 Customer Order Dilivery PK,FK1 row 1 PK,FK2 row 2 row 1 Product Price PK,FK1 row 1 PK,FK2 row 2 row 1 Customer Order Products PK,FK1 row 1 PK,FK2row 2 row 1

Add a comment
Know the answer?
Add Answer to:
When we receive an order, we check each line item on the order to see if...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 26–1. Indorsements.  A check drawn by Cullen for $500 is made payable to the order of...

    26–1. Indorsements.  A check drawn by Cullen for $500 is made payable to the order of Jordan and issued to Jordan. Jordan owes his landlord $500 in rent and transfers the check to his landlord with the following indorsement: “For rent paid, [signed] Jordan.” Jordan’s landlord has con- tracted to have Deborah do some landscaping on the prop- erty. When Deborah insists on immediate payment, the landlord transfers the check to Deborah without indorse- ment. Later, to pay for some...

  • Underneath the problem you will see buttons to 'check' or 'clear' your answers. (These will not...

    Underneath the problem you will see buttons to 'check' or 'clear' your answers. (These will not appear when there are no inputs in the step, instead you'll see the 'Continue' button to click on to move to the next portion of the exercise.) Use these carefully because 'clear" will delete all inputs in the question that haven't yet been graded. Check your answers only after entering all required inputs for that step. Buttons with the question number and the number...

  • Module 6 - Cash Register (10 Points) We are going to write a program that simulates...

    Module 6 - Cash Register (10 Points) We are going to write a program that simulates a customer's transaction at a cash register. You will organize your code using functions. Each of the functions below counts for 2 points. You must create functions allowing the user to: 1. Add an item to the order. No name or list of items is needed simply prompt the user for a dollar amount to add. 2. Clear all transactions. Set the amount of...

  • Assignment 5 will be way different. It will be more like what you will receive in...

    Assignment 5 will be way different. It will be more like what you will receive in a programming shop. By that I mean that some things are built for you and others you will need to create or finish. P.S. part of your grade will include: Did you add in the required files? Did you rename your project? does your linear searches work? Did you put your code in the correct modules? did you change modules that you weren't supposed...

  • We are using, Oracle Database 11g Express Edition. use SQL and the TAL Distrutors database (see...

    We are using, Oracle Database 11g Express Edition. use SQL and the TAL Distrutors database (see figure 1-2 in chapter 1) to complete the following exercises. if directed to do so by your instructor, use the information provided with the chapter 3 exercises to print your output or save it to a document. 1. list the item number, description, and price for all items. 2. list all rows and columns for the complete ORDERS table. 3. list the names of...

  • AA. Final Project - Improved JavaFX GUI Personal Lending Library Description: In this project we will...

    AA. Final Project - Improved JavaFX GUI Personal Lending Library Description: In this project we will improve our personal lending library tool by (1) adding the ability to delete items from the library, (2) creating a graphical user interface that shows the contents of the library and allows the user to add, delete, check out, or check in an item. (3) using a file to store the library contents so that they persist between program executions, and (4) removing the...

  • In order to receive credit for this assignment, you must: . build a spreadsheet that accurately e...

    In order to receive credit for this assignment, you must: . build a spreadsheet that accurately estimates the cash flows of this project (using both assumptions provided and judgment about how to implement them) . use your spreadsheet to evaluate this project (as directed by the assignment) and determine whether it will create value for the firm; produce a written recommendation explain whether you think the company should accept or reject this project, and why! Case Study: New Product Decision...

  • Objective: The objective of this assignment is to write use cases, draw use case diagram and...

    Objective: The objective of this assignment is to write use cases, draw use case diagram and activity diagram. Assignment Specification: A retail store wants to build an online system for their customer to place orders online and for pickup later from the store. Customers join the system by registering online (username (email), password, address, phone no) and including a credit card for use in online ordering; at that time they use login credentials (uername and password) to enter the online...

  • Create a system flowchart and review the controls in the process. See attached document for details....

    Create a system flowchart and review the controls in the process. See attached document for details. Flowchart Assignment Business Process Diagramming and Control Evaluation The project is based on the business processes and controls for Order Entry/ Shipping and Billing / Cash Receipts at NashGulch Furnishings. NashGulch Furnishing sells high end, i.e. expensive and unique, home and office furnishings to design studios, building contractors, and architects. Customers place orders over the phone to the NashGulch customer fulfillment center, Nash Gulch...

  • If possible please just send the SQL statement. Thank you Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top o...

    If possible please just send the SQL statement. Thank you Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font, include the SQL statement and then provide a screen shot of each query. The screen shots must include both the SQL statement and the results for each item below based on the data entered in...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT