ER diagram

ER Diagram For Airport Management

Why this ER Diagram? 

Answer --  This ER Diagram is plotted for airports. It explains all the relations and details about various flights with respect to airport including important information in easiest way.

Who will use this?

Answer -- Airport management.

Entities and their attributes

Airport (Entity)
-code
-name
-location 
 -city
 -state

Airplane Type (Entity)
-maker
-model
-range

Airplane (Entity)
-id number

Flight (Entity)
-airline
-number

Leg Instance (Weak Entity)
-date

Flight Leg (Weak Entity)
-length

Now consider various relationship in the given ER diagram.

1-Airplane is related to airport by means of landing.
2-Departure and arrival time establish a relationship between flight and airport.(It notify passengers for flight departure time or arrive time on airport).
3-Every flight contains legs, it can be of any length (flight contains flight legs)
4- Flight leg contains number of leg instance (every instance for particular length or destination)
5-At last there can be different type of airplanes based on various factors like model number, passenger capacity, travel range, manufacturing company etc.