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 specific 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.
Page 173Miscellaneous 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.
1. Draw a BPMN activity diagram that describes Quick Jet's purchases and payments process.
2. Prepare a UML class diagram with classes, associations, and multiplicities.
3. 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#________________________________ Plane#
Cash account balance.........................................Plane maintenance contract#
Check#............................................................................Plane maintenance contract date
Check amount................................................Plane maintenance contract duration
Check date......................................................Plane maintenance item performed on this order for this plane
Date this misc. purchase billed by credit card company..Plane maintenance order#
Employee#.....................................................................Plane maintenance order date
Employee hire date..........................................Plane miles since last maintenance
Employee name..............................................Plane type
Employee type................................................Plane type passenger capacity
Employee type description..................................Plane type range in miles
Lease#.............................................................................Vendor#
Lease date.......................................................................Vendor Name
Lease monthly payment amount............................Vendor type
Misc. supply purchase#...................................................Vendor type description
Misc. supply purchase date.................................. Year-to-date (YTD) purchases from this vendor type
Number of vendors of this type