Answered step by step
Verified Expert Solution
Question
1 Approved Answer
. Each technician is an expert on one or more plane model(s), and his or her expertise may overlap with that of other technicians. This
. Each technician is an expert on one or more plane model(s), and his or her expertise may overlap with that of other technicians. This information about technicians must also be recorded. Each Traffic controllers must have an annual medical examination. For each traffic controller, you must store the date of the most recent exam. . Each TSA Agent must have TSI Clearance, Medical clearance and SSBI . All airport employees (including TSA Agents, technicians and traffic controller) has a union membership number and you can assume that each employee is uniquely identified by a social security number and you need to store the name, address, phone number, job title and salary . The airport has a number of tests that are used periodically to ensure that airplanes are still airworthy. Each test has a Federal Aviation Administration (FAA) test number, a name, and a maximum possible score In addition for each test we need the date the airplane was given the test, the number of hours the technician spent doing the test and the score the airplane received on the test
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started