Airline online tickets reservations database scheme for commercial flights built using Oracle tools.
- Install Oracle 11g Database: database
- Install Oracle SQL Developer: sql developer
- Install Oracle Data Modeler: data modeler
- Start server: help
- If you are not familiar with oracle tools you can watch video: guide
- Run generated ddl from ddl folder
- Run elon_scene.sql to test single ticket reservation
- Open project with Oracle Data Modeler from source folder
- Right click and show logical or relational data model
- Make further modifications
- Generate from logical -> relational -> ddl and backwards, as you wish
- Note that views were created inside relational model, you can delete them if they cause any confusion