Consider a model of an airport with planes, models of planes, a test of planes, and technicians. Draw an ER diagram to represent these entities and the following attributes. Planes have a unique registration number. Airplane Models are each identified by a model number (e.g. DC-80), and each has a capacity and a weight. A number of technicians work at the airport. You need to store for each 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. (a) Each airplane is of one specific model. (b) Each technician is an expert on one or more plane models. His or her expertise may overlap with that of other technicians. (c) Transport Canada 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 is the date, the number of hours spent doing the test, and the score that the airplane received on the test. (d) Convert this ER diagram to a relational schema. Give an explanation about the primary key of each relation. Please answer in detail
Consider a model of an airport with planes, models of planes, a test of planes, and technicians. Draw an ER diagram to represent these entities and the following attributes.
Planes have a unique registration number. Airplane Models are each identified by a model number (e.g. DC-80), and each has a capacity and a weight. A number of technicians work at the airport. You need to store for each 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.
(a) Each airplane is of one specific model.
(b) Each technician is an expert on one or more plane models. His or her expertise may overlap with that of other technicians.
(c) Transport Canada 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 is the date, the number of hours spent doing the test, and the score that the airplane received on the test.
(d) Convert this ER diagram to a relational schema. Give an explanation about the primary key of each relation.
Please answer in detail
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
