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.

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.

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.

Required:

c. Using the information in the case above and the attributes listed below, 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. Then answer the questions below.

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

1. Which of the following is the primary key of the Planes table?

2. Which of the following is the primary key of the Plane Lease table?

3. Which of the following is the primary key of the Plane Types table?

4. Which of the following is the primary key of the Miscellaneous Supplies table?

5. Which of the following is the primary key of the Cash table?

6. Which of the following is a foreign key in the Planes table?

7. Which of the following is a foreign key in the Plane Lease table?

8. Which of the following is a foreign key in the Cash Disbursements table?

9. Which of the following is a foreign key in the Employees table?

10. How would you implement the association between Plane Lease and Cash Disbursement tables?