You should now be able to model your data and create transparent tables in the ABAP dictionary to add, edit and delete data. This lesson is an example of an Airline Data Model and how it was created in SAP.

Your assignment is to:

• Create a relational data model for an airline company that needs to store data from the passengers such as Name, ID, Address and Flight ; data from the flights such as ID, Origin and Destination; and data from the airline company such as ID, Airline Name and Flight numbers assigned to it.
• Create transparent tables in the ABAP Dictionary to represent your relational model.

Flight Information Relational Data Model

• ONE Airline can have MANY Flights (1-N)
• ONE Passenger can have MANY Flights
• ONE Flight can have MANY Passengers