Hi,

I am struggling with problem number 2. The problem asks you to draw a BPMN diagram, UML Class diagram, and table listings. You can read presentation here, so it may help you complete problem.

Chapter 6 Purchase and Payments Business Process Copyright 2014 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education. Learning Objectives LO#1 Describe the business activities that comprise the purchase and payment process LO#2 Develop an activity model of the purchase and payment process using BPMN LO#3 Understand and apply different activity modeling options LO#4 Develop business rules to implement controls for the purchase and payment process LO#5 Develop structure models for the purchase and payment process using UML class diagrams LO#6 Implement a relational database from the UML Class Diagram of the purchase and payment process 6-2 LO# 1 Review of Purchases and Payments Accounting 6-3 LO# 2 Sunset Graphics Purchases Process 1. Research prices and product availability 2. Select the best price and availability combination and send a purchase order to the supplier 3. Receive the items from the supplier (and record the purchase and accounts payable) 4. Pay the supplier according to the credit terms 6-4 LO# 2 Basic Purchases BPMN Activity Model The basic activity model implements the process steps. 6-5 LO# 3 Collaboration Model of the Purchases Process The collaboration model focuses on the message flows between the pools. 6-6 Adding Swimlanes to Show Functional Responsibility LO# 3 Swimlanes show functional responsibili ties 6-7 Business Rules Examples for Purchases Process Process Steps Intention Partner Authority/Action Place Order Order products from reliable suppliers at the best available prices to meet required delivery time Manager approval required for orders > $5,000; Partner ordering products must not manage inventory Receive Items Record receipt Partner receiving items of items must not be same partner promptly and that ordered the items accurately LO# 4 Access Controls Application Controls Partners preparing purchase orders cannot modify product inventory records, receive items, or pay suppliers System must provide purchase order number control, default values, range and limit checks, and create audit trail Partners receiving items cannot modify purchase orders or inventory records; they cannot view purchase order quantity ordered information System must only allow partner to enter the number of items received, subject to range and limit checks on quantities received; date of receipt defaults to current date 6-8 LO# 5 Sunset's Basic Purchases UML Class Models 1. Purchase Orders are commitments to purchase from the supplier. 2. Receipts document the receipt of items from the supplier (when purchases recognized). 3. Cash disbursements pay for one or more receipts 6-9 LO# 5 Revised Purchases UML Class Diagram Purchase Orders and Receipts collapsed into one Purchases events Added Product Categories type image as defined in Chapter 5 Added Supplier Categories type image to show Sunset Partner responsibility for Categories 6-10 LO# 6 Implementing UML Diagram in a Database Database will contain 8 tables to implement classes and 1 linking table for the relationship between Purchases and Products. 6-11 Posting Foreign Keys Example Post towards the * and away from the 1 Foreign keys implement links for one-to-many relationships. 6-12 Database Relationships Which relationship is missing? How would you implement that? 6-13 Did you notice the similarity between the sales process and the purchase process? 6-14 2. Quick Jet Inc. provides air taxi service to the wealthy, including celebrities, sports stars, and business executives. This case describes how Quick Jet leases and maintains its planes. Quick Jet employees negotiate long-term leases with airplane leasing companies. Each lease involves one plane. Quick Jet categorizes its planes according to passenger capacity and normal flying range. Quick Jet makes monthly lease payments for its planes. If it leases multiple planes from the same lease company, it combines payments. Maintenance The company has no maintenance staff of its own, so it also contracts with a number of airplane maintenance companies to perform the routine maintenance required to keep its fleet airworthy. It issues orders against the contracts for specific maintenance required for the planes. To comply with FAA regulations, it tracks the details of the specific maintenance performed on each plane. To facilitate the tracking, each maintenance order specifies the maintenance services for one plane. Quick Jet plays for all the maintenance performed by each maintenance contractor within 15 days, according to the terms of the contracts, and may combine payments. Miscellaneous Purchases Quick Jet also provides each of its pilots with credit cards so they can purchase fuel and miscellaneous supplies at the various airports they use. The pilots turn in detailed lists of their purchases that identify the supplier, the date, the amount purchased, and the prices, as well as the plane for which the items were purchased. Each list is assigned a miscellaneous purchase number. Quick Jet pays the credit card bills in full each month upon receipt from the credit card company. Other Information Quick Jet keeps information about the plane leasing companies, the plane maintenance contractors, miscellaneous suppliers, and the credit card companies in one vendor file. However, it tracks plane leases, maintenance contracts, maintenance orders, and miscellaneous purchases separately (separate events). Quick Jet categorizes its employees according to their job assignments (e.g., pilots, purchasing employees, A/P clerks). It also categorizes vendors according to the services/goods they provide. It puts information about its agents, resources, and type images in the database before linking to other classes. a. Draw a BPMN activity diagram that describes Quick Jet's purchases and payments process. b. Prepare a UML class diagram with classes, associations, and multiplicities. c. Using the preceding information and the following attributes list, prepare a listing of the relational tables necessary to support this sales and collection process. List the tables in the following order: resources, events, agents, type images, and linking tables. Attributes: Cash account# Cash account balance Check# Check amount Check date Date this misc. purchase billed by credit card company Employee# Employee hire date Employee Name Employee type Employee type description Lease# Lease date Lease monthly payment amount Misc. supply purchase# Misc. supply purchase date Number of vendors of this type Plane# Plane maintenance contract# Plane maintenance contract date Plane maintenance contract duration Plane maintenance item performed on this order for this plane Plane maintenance order# Plane maintenance order date Plane miles since last maintenance Plane type Plane type passenger capacity Plane type range in miles Vendor# Vendor Name Vendor type Vendor type description Year-to-date (YTD) purchases from this vendor type