Design a database for tracking service data about aircraft for a small airport. There are several models of aircraft, and each model has a specific manufacturer, size (number of seats), and description. Records of maintenance need to be kept which mechanic made what repair to which aircraft. Mechanics are trained and certified for each model of aircraft separately, but not all mechanics are trained and certified for all aircraft. The hourly rate paid to mechanics varies according to the number of models a mechanic is certified to work on.

Create a set of tables for the company in 3NF. Represent your answer in DBDL. (i.e. give table name and fields. Underline the primary key.) Draw an Entity-Relationship Diagram using Visio or Lucid Charts.

Identify any assumptions you made