Airport Database Management System

Entity Relationship Diagram

Built using Diagram Editor.

Extended Entity Relationship (EER) Diagram

• An EER Diagram would consist properties like Specialisation & Generalisation.
  • Suppose, an employee in this system can be specialised into entities like:
    • Administration
    • Security
    • Engineers
    • Traffic Monitor
  • And, different types of flights, like Airbus, Boeing can be generalised into one single entity Flight.

Steps to map (E)ER into a Relational Schema

These steps are briefly described in this PDFER-mapping-to-RelationalSchema.pdf>).

Relational Schema

• Mapping the above ER Diagram to a Relational Schema

Built using draw.io.