Consider the following relational database that Best Airlines uses to keep track of its mechanics, their skills, and their airport locations. Mechanic number, airport name, and skill number are all unique fields.

Size is an airport's size in acres. Skill Category is the type of skill, such as an engine skill, wing skill, tire skill, etc. Year Qualified is the year that a mechanic first qualified in a particular skill; Proficiency Rating is the mechanic's proficiency rating in a particular skill.

Analyze each of the following situations and, using the physical database design techniques discussed in this chapter, state how you would modify the logical design shown to improve performance or otherwise accommodate it.

a. There is a high-priority need to quickly find any particular airport's data given only the airport's city and state.

b. There is a frequent need to find the total salary of all of the mechanics at any particular airport.

c. There is a high-priority need to quickly find any particular mechanic's data together with the data about the airport at which she works.

d. There is a frequent need to list the names and telephone numbers of themechanics who work at any particular airport, together with the airport's city and state.

e. Assume that there is an additional attribute called Skill Description in the SKILL table. This attribute is used to store lengthy descriptions of each skill. The problem is that its presence in the SKILL table is slowing down access to the rest of the data in the table, which is accessed much more frequently.

f. The need to access data about the ten largest airports in the country is much more frequent than the need to access data about the rest of the airports.