This was one of my mini-projects in my third semester in Indian Institute of Information Technology – Allahabad. Our professor wanted us to have a practical exposure in Database Systems by working on real-life problems by build a project from scratch.
We were lucky to be working on Railway Reservation System as I, personally, always wanted to work on this. The Indian Railway System has always fascinated me with the scale at which it is being used. It always made me wonder how they build such a robost(?) and scalable system, and to work on a similar topic is exciting!
Now, getting back to the project, we were basically asked to design ER diagram, schema diagrams and normalization tables. I’ve posted all the diagrams in the presentation. Hope it helps anyone to build a better system than we did. Good Luck!
follow me in twitter @prashishh