The Assignment:
Study an Airline reservation system and identify the entities, attributes and relationship between them.
- Draw a complete ER diagram
- Transform this ER diagram to a logical Schema.
Objective
This assignment has been designed so that you understand the concept of
Transforming Conceptual Schema into Logical Schema and Relational
Schema. Also basic concepts of Normalization