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 employ- ees 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 mainte- nance 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 mainte- nance contractors, miscellaneous suppliers, and the credit card companies in one ven- dor 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.

Draw a BPMN activity diagram that describes Quick Jets purchases and payments process.

Prepare a UML class diagram with classes, associations, and multiplicities.

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