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