Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions