airline-tickets-reservations

Airline online tickets reservations database scheme for commercial flights built using Oracle tools.

Preview

Installation

• 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

DDL Generation

• 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