Construct data models for the following specifications. Include an ERD and a lis

Question

Construct data models for the following specifications. Include an ERD and a list of relations (entity list). Your relations must show all attributes, primary keys and foreign keys.

A pilot may be assigned to several flights as a crew member over time. The crew for a flight comprises a minimum of two pilots but could have up to four. For a pilot, we store the name, flying license number and birth date. For a flight, we store the flight code, origin location, destination location and type of aircraft. We also need to store the date a pilot is assigned to a flight, the role of the pilot and the total kilometres and hours the pilot has been flying in a flight.

Explanation / Answer

Here i am attaching the image file containing the solution.

PFA.

https://drive.google.com/file/d/0B7AsNUHucFxLNEpKVGEtOG5TNkE/view?usp=sharing

You can get back to me if any problem:

girrajjayaswal@gmail.com

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.