Seating Selection System Database Design
-
Hi All, I am designing a ticket booking system with seat selection facility. I need to store the Seating Map (of an auditorium/theatre) in database so that the same can be fetched and shown in UI. I am not sure how to do the same in an RDBMS. Please help me. Thanks Riyaz
-
Hi All, I am designing a ticket booking system with seat selection facility. I need to store the Seating Map (of an auditorium/theatre) in database so that the same can be fetched and shown in UI. I am not sure how to do the same in an RDBMS. Please help me. Thanks Riyaz
hmrizin wrote:
Please help me.
With what exactly? The design, the implementation in the RDBMS, fetching the things or showing the stuff in the UI? A quickstart; them seats are probably numbered. You need a table to store who is sitting on what number on a specific event. A theater can have multiple events on a day, so you'd also need a table to list the events :)
I are troll :)
-
hmrizin wrote:
Please help me.
With what exactly? The design, the implementation in the RDBMS, fetching the things or showing the stuff in the UI? A quickstart; them seats are probably numbered. You need a table to store who is sitting on what number on a specific event. A theater can have multiple events on a day, so you'd also need a table to list the events :)
I are troll :)
Eddy Vluggen wrote:
With what exactly? The design, the implementation in the RDBMS, fetching the things or showing the stuff in the UI?
The implementation in RDBMS. The Database Design should support the following: 1. Storing Seating Map of different Auditoriums/CinemaHalls 2. Should store not only the seat numbers but the exact seating arrangement with pathways, screen-location etc Is is possible to do with an RDBMS? Please gimme some ideas. Thanks Riyaz
-
Eddy Vluggen wrote:
With what exactly? The design, the implementation in the RDBMS, fetching the things or showing the stuff in the UI?
The implementation in RDBMS. The Database Design should support the following: 1. Storing Seating Map of different Auditoriums/CinemaHalls 2. Should store not only the seat numbers but the exact seating arrangement with pathways, screen-location etc Is is possible to do with an RDBMS? Please gimme some ideas. Thanks Riyaz
-
hmrizin wrote:
Is is possible to do with an RDBMS?
Yes. Have you ever designed a database before?
I are troll :)
-
If you can do it in MySQL, then you can do it in SQL Server too :) I doubt that you'll run into problems with grouping the data over tables and normalizing them, although you might run into some minor problems with the differences in syntax between SQL Server and MySQL. To answer the original question; yes, it should be possible.
"please help in this regard. give the visual basic code for this as soon possible."
-
If you can do it in MySQL, then you can do it in SQL Server too :) I doubt that you'll run into problems with grouping the data over tables and normalizing them, although you might run into some minor problems with the differences in syntax between SQL Server and MySQL. To answer the original question; yes, it should be possible.
"please help in this regard. give the visual basic code for this as soon possible."
-
Sorry for the late reply Eddy; caught up with some other work Thank you for your support. Have started designing the database. Will keep you posted.