Answered: Draw a single ER diagram that…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Draw a single ER diagram that represents the specifications listed below.

Follow the process below to help you do this:

Consider a model of an airport with planes, models of planes, test of planes, and technicians. Draw an ER diagram to represent these entities and their attributes. Planes have a unique registration number. Airplane Models are each identified by a model number (e.g., DC-80, A380, B747), and each have a capacity and a weight. Several technicians work at the airport. You need to store for each technician the name, phone number, address, and salary. The airport has a number of tests that are used regularly to ensure that airplanes are safe. Each test has a unique FAA number, a name, and a maximum possible score. Extend your ER diagram with relationships to represent the following information.

Each airplane is of one specific model.
Each technician is an expert on one or more plane models. His or her expertise may overlap with that of other technicians.
Transport Australia requires the airport to keep track of each time a given airplane is tested using a given test. For each testing event, the information needed

Expert Solution