-
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.
-
Notifications
You must be signed in to change notification settings - Fork 1
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.
MinaElkholy42/Train-Reservation-System-Database-Design-and-Analysis
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
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 0
No packages published