Question

Please 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 of 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: Employeeld Name Address Phone_Number Department Job_Title 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 • You can draw the diagram by pen & paper, and take a picture of the diagram

Answer 1

The swimlane process diagram and database tables have been provided along with an explanation of primary key and foreign key relationships.

Step-by-step explanation:

Database Tables:

Here are the three database tables for the entities: consumer, product, and order:

Consumer table:
Primary KeyConsumerIDNameConsumerNameAddressConsumerAddressPhone NumberConsumerPhoneNumber

Product table:
Primary KeyProductIDNameProductNamePriceProductPrice

Order table:
Primary KeyOrderIDConsumer IDConsumerIDProduct IDProductIDStatusOrderStatus

Primary Key and Foreign Key Relationships:

A primary key is a unique identifier for each record in a table. In the consumer table, the primary key is ConsumerID. In the product table, the primary key is ProductID. In the order table, the primary key is OrderID.

A foreign key is a field in a table that refers to the primary key of another table. In the order table, the ConsumerID field is a foreign key that references the ConsumerID primary key in the consumer table. Similarly, the ProductID field in the order table is a foreign key that references the ProductID primary key in the product table.