Assignment $3$: Entity Relationship Model

Create the Entity Relationship Model for a flight training school application. The requirements for the application is summarized below:

The flight school has $2$ types of training aircraft, high$-$wing and low$-$wing. It has multiple aircraft of each type. Each aircraft, besides its type, has a make, model, model year, color$($s$)$; and it is uniquely identified by the tail number.

It is necessary to keep a record for the maintenance of each aircraft. The maintenance record should capture the date of the maintenance, a summary of the work done during maintenance and the identity of the mechanic that performed the maintenance.

The flight school has pilot instructors. Each instructor is uniquely identified by the social security number. It is necessary to keep track of the name, address, phone number, email address of each instructor. Each instructor is qualified to train pilots on high$-$wing, low$-$wing or both types of aircraft, and it is necessary to keep track of this qualification. Each instructor has a pilot certificate with an expiry date that needs to be kept on record.

The flight school has student pilots. Each student is identified by the social security number, name, address, phone number and email address. It is necessary to keep track of the training progress of each student by keeping track of the date, the number of hours, the aircraft type, the instructor of each completed training session.

The flight school keeps the schedule of future training sessions. Each entry in the schedule tracks the particular aircraft, the student, the instructor, the date, the scheduled start time and the scheduled end time of the session

$1$