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.