Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ng the following information about an ase for organizing all airplanes stationed and maintained at the airport. Every airplane has a registration number, a name,
ng the following information about an ase for organizing all airplanes stationed and maintained at the airport. Every airplane has a registration number, a name, a maker, and a line number The airport accommodates a number of airplane models, and each model is identified by a model number and has a capacity and weight. Each airplane belongs to a specific model. Each airport employee is uniquely identified by his/her employee ID. We need to store the name, social security number (S5N), address, phone number, and salary of each employee. In addition, all airport employees belong to a union We must store the union membership number of each employee. . * *All employees are eligible to purchase insurance policies for his/her dependent s Each policy can be uniquelv identified by an ID. We also need to record its name and The name and date of birth of each dependent needs to be recorded. Each dependent must be identified uniquely by his/her name with the employee ID of the person who they depend on. Some airport employees are categorized as technicians and traffic controllers. Each technician must be certified for one or more plane model(s) with a specific certificate name, level, and issue date. Notice that the expertise of each technician may overlap with that of other technicians. * * .Traffic controllers must have an annual medical examination For each traffic controller, we must store the date of the most recent exam. The Airport has a number of tests that are used periodically to ensure that airplanes arg still airworthy. Each test has a Federal Aviation Administration (FAA) test number, a name, and a maxdmum possible. The FAA requires the airport to keep track of each time a given airplane is tested by a Biven technician using a given test. For each testing event, the information is tested by a given technician using a given test. For each testing event, the information needed is the date, the number of hours the technician spent doing the test, and the score the airplane received on the test. The FAA requires the airport to keep t siven technician using a given test. For each testing event, the infomation needed is the date, the number of hours the technician spent doings the test, and the score the airplane received on the test ack of each time a given airplane is tested by a * Draw an E-R diagram for the airport database. Be sure to indicate the various attributes of each entity and relationship set also specify the key and particular constraior each relationship set. Specifying any necessary overlap and covering constraints as well
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