Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw the swimlane process diagram for the business process below: Consumer submit order to Sales department Sales department forwards the order to Warehouse Warehouse check

Draw the swimlane process diagram for the business process below:

  • Consumer submit order to Sales department
  • Sales department forwards the order to Warehouse
  • Warehouse check the inventory
  • If the ordered product is out of stock, the order will be canceled
  • If the ordered product is available, the Payment department will process credit card payment
  • If the card is accepted, the Warehouse will handle delivery
  • If the card is declined, the order will be canceled


Please also create three database tables for consumer, product and order using Word tables (1 row, multiple columns for different key fields)

Please underline the primary key

You can include any fields you feel necessary to have in your table in order to model these three entities

Please explain what is the primary key and foreign key relationships in these three tables

You can refer to the example below for the table format:

Please design the database tables using tables in Word document.

There are two ways to submit your swimlane diagram:

  • You can draw it using Lucidchart, export a picture file of your diagram, and insert the picture to the Word document

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Fundamentals of Management

Authors: Robbins, DeCenzo, Coulter

7th Edition

132996855, 0-13-610982-9 , 9780132996853, 978-0-13-61098, 978-0136109822

More Books

Students also viewed these General Management questions

Question

Define Decision making

Answered: 1 week ago

Question

What are the major social responsibilities of business managers ?

Answered: 1 week ago

Question

What are the skills of management ?

Answered: 1 week ago