Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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 constraints The 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.

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 constraints The 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.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

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 constraints

The 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 - Notepad File Edit Format View Help You 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 a specific model. The airport accommodates a number of airplane models, and each model is identified by a model number (e.g., DC-10) and has a capacity 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 technician 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. 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 is uniquely identified by a social security number 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. 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 information needed is the date, the number of hours the technician spent doing the test, and the score the airplane received on the test 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 constraints The 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. Ln 24, Col 126 100% Windows (CRLF) UTF-8
Transcribed Image Text:O "Untitled - Notepad File Edit Format View Help You 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 a specific model. The airport accommodates a number of airplane models, and each model is identified by a model number (e.g., DC-10) and has a capacity 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 technician 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. 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 is uniquely identified by a social security number 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. 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 information needed is the date, the number of hours the technician spent doing the test, and the score the airplane received on the test 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 constraints The 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. Ln 24, Col 126 100% Windows (CRLF) UTF-8
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS