Draw an ER diagram for the airport database. Be sure to indicate the various attributes of each entity and relationship set; also specify the key and participation constraints for each relationships. Specify any necessary overlap and covering constraintsThe FAA passes a regulation that tests on a plane must be conducted by a technician whois an expert on that model. How would you express this constraint in the ER diagram? If you cannot express it, explain briefly. O "Untitled - NotepadFile Edit Format View HelpYou have just been hired as a consultant by the local airport. Impressed by your background in databases, they want you to completely redesign their database system.Your first task is to organize the information about al1 the airplanes stationed and maintained at the airport. The relevant information is as follows:Every airplane has a registration number, and each airplane is of aspecific model.The airport accommodates a number of airplane models,and each model is identified by a model number (e.g., DC-10) and has acapacity and a weight.A number of technicians work at the airport. You need to store the name, SSN, address, phone number, and salary of each technicianEach 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 techniciansmust also be recorded.Traffic controllers must have an annual medical examination. For each traffic controller, you must store the date of the most recent exam.All airport employees (including technicians) belong to a union. You must store the union member-ship number of each employee. You can assume that each employee isuniquely identified by a social security numberThe 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) testnumber, a name, and a maximum possible score.The FAA requires the airport to keep track of each time a given airplane is tested by a given technician using a given test. For each testing event, the informationneeded is the date, the number of hours the technician spent doing the test, and the score the airplane received on the testDraw an ER diagram for the airport database. Be sure to indicate the various attributes of each entity and relationship set; also specify the key and participationconstraints for each relationships. Specify any necessary overlap and covering constraintsThe FAA passes a regulation that tests on a plane must be conducted by a technician whois an expert on that model. How would you express this constraint in the ERdiagram? If you cannot express it, explain briefly.Ln 24, Col 126100%Windows (CRLF)UTF-8

ER : ER Diagram stands for Entity Relationship Diagram, also known as ERD is a diagram that displays…

Answered: Draw an ER diagram for the airport…

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 4TD: Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be...