Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following information in an airport database An airport is describe by its name and the city that the airport locates at Each airplane

image text in transcribed

Consider the following information in an airport database An airport is describe by its name and the city that the airport locates at Each airplane has a registration number and the date of production as its descriptive attributes Each airplane model is identified by a model number and has a capacity and a weight A technician is characterized by an ID, a name and a phone number Each airport accommodates a number of airplane models, and an airplane model may appears in several airports Each airplane is of a specific model, e.g. Boeing 737 A number of technicians work at the airport, but each technician works only at one airport Each technician is responsible for one or more plane models, and one plane model has one or more technician responsible for it Each airplane is periodically tested by a number of technicians. A technician may test several airplanes each year. The information, such as the test number, the test date, the testing result, is required to describe a testing of an airplane

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Organizing Information Digital And Information Literacy

Authors: Greg Roza

1st Edition

1448805929, 978-1448805921

More Books

Students also viewed these Databases questions

Question

8. Explain competency models and the process used to develop them.

Answered: 1 week ago