The following narrative describes the purchase and payment process for Quick Jet Inc. Use the narrative to answer the questions below. Quick Jet Inc. provides air taxi service to the wealthy, including celebrities, sports stars, and business executives. 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. LO 6-2, LO 6-3, LO 6-5

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 page 191specific maintenance performed on each plane. To facilitate the tracking, each maintenance order specifies the maintenance services for one plane. Quick Jet pays 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 Jets 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.