Skip to content

Database Analysis and Design for Train Reservation System. Analysis of User Requirments Phase, Design of ERD, Schema, Implementation of Physical Tables, Populating Data, and Queries to Analyze the Data. Views for the security of data and helping analyze the rest of the tables.

Notifications You must be signed in to change notification settings

MinaElkholy42/Train-Reservation-System-Database-Design-and-Analysis

Repository files navigation

Train Reservation System Database Design and Analysis

  • Designing and analyzing a database for the train reservation system with Documentation explaining all the steps followed in the project work.

  • The design includes tickets, trains, passengers, types of services provided according to ticket class, seats, dates, arrival times, movement from different stations, and others.

  • Designing the ERD and converting it to Schema through the ERDPlus.com website, tables implemented using SQL DDL Commands, and data entered using SQL DML commands.

  • I wrote many Queries to generate reports, analyze the data to enhance the business needs, and know more information about all the entities in the system.

  • The databases used are SQL Live, Oracle, and MS SQL Server.

About

Database Analysis and Design for Train Reservation System. Analysis of User Requirments Phase, Design of ERD, Schema, Implementation of Physical Tables, Populating Data, and Queries to Analyze the Data. Views for the security of data and helping analyze the rest of the tables.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published