The Cinema Booking System is a user-friendly platform that allows customers to reserve movie tickets conveniently. It is developed using Qt for Python and Qt Creator software and connected to Microsoft SQL Server database. With this system, users can browse a wide selection of movies, view showtimes, and choose their preferred seats. The system provides real-time seat availability, ensuring that customers can select seats that best suit their preferences. Overall, the Cinema Booking System streamlines the movie ticket booking process, making it easy and convenient for customers to reserve seats for an enjoyable movie-going experience.
The entities involved in this system are Customer, Employee, Movie, Hall, Seat, Showtime, and Transaction. The relationships demonstrated in the following ERD are Rate which is a relationship between Customer and Movie where a customer can rate a movie and leave a review. The Employee has 2 relationships Manage_Halls and Manage_Movies for maintaining the halls and movies, also there exists has relationship between Hall and Seat as each hall contains seats and Seat is a weak entity as it is identified by the hall it is in. There is a ternary relationship Contains between Movie, Hall, and Showtime as each showtime is associated with a movie and a hall. Also Showtime is a weak entity as it is identified by the Movie and Hall with partial keys Time and Date. There is a quaternary relationship Reserve between Customer, Showtime, Seat and Transaction to represent when a customer books seats and confirms the transaction.