Movie
Movie
Movie
Project Report
ON
1|Page
Ashoka Education Foundation’s
Certificate
e
2024-25
This is to certify that Mr. _SANKET SHANTILAL MARATHE Class _TYBBA(CA)___
Semester __V__ Roll No. __32_ & University Exam Seat No. __9905___ has successfully
under Savitribai Phule Pune University during the academic year 2024 -25 .
2|Page
Ashoka Education Foundation’s
Certificate
e
2024-25
This is to certify that Mr. _DURVANKUR SURESH KANSARE Class _TYBBA(CA)___
Semester __V__ Roll No. __10__ & University Exam Seat No. __9892___ has successfully
under Savitribai Phule Pune University during the academic year 2024 -25 .
3|Page
Acknowledgement
The satisfaction that accompanies that the successful completion of any task would be incomplete
without the mention of people whose ceaseless cooperation made it possible, whose constant guidance
and encouragement crown all efforts with success.
I would like to thanks Head of BBA(CA) Department of Ashoka Center for Business and Computer
Studies of Nashik. Project Guide Mrs. Pratima Bhalekar for the guidance, inspiration and constructive
suggestions that helped me in the preparation of this project. I also thank all the colleagues and other
professors for helping me in completing this project.
4|Page
INDEX
1. Introduction
2. Existing System
3. Proposed System
4. Objective of System
7. Data Dictionary
9. Conclusion
5|Page
Introduction
In particular, this Movie Ticket Booking System project in Python focuses mainly on keeping track of
movie booking details. To be more precise, the system helps to keep track of theatre movies with
respect to their depth information. Also, the system displays all pricing lists according to day and type.
In addition, the system allows viewing booking details and more. Evidently, this project contains a
manager panel with a cashier panel. In an overview of this web application, the manager has full
control over the system. He/she can manage movies, schedule movies, alter ticket prices, and list
booking details.
6|Page
Existing System
The existing system for a Theatre Management system for managers and cashiers typically involves a
combination of manual processes and traditional software tools that may have some level of automation
but still come with limitations. Here’s a description of how the existing system functions:
1. Current System Overview
The current system is primarily a manual process or a semi-automated system that involves using
traditional software (such as spreadsheets or standalone applications) to manage bookings, schedules,
and sales records. There is limited integration between different functions, resulting in inefficiencies,
errors, and the need for redundant tasks.
2. Components of the Existing System
• Cashier Role:
o Customers walk up to the ticket counter to purchase movie tickets.
o Cashiers manually check seat availability from printed schedules or use a simple booking
application to view available seats.
o Cashiers record the booking in a physical logbook or a basic booking software with
limited capabilities.
o Printed tickets may be issued manually using pre-printed ticket stock, or a basic ticket
printing tool may be used.
o Canceling or changing a booking requires manually updating the seat status, often leading
to errors or overbooking.
3. Challenges in the Existing System
Inefficiency
• Manual Processes: Many tasks, such as updating schedules, booking tickets, and generating
reports, are performed manually, resulting in slower operations.
• Time-Consuming Tasks: Updating schedules and communicating changes to all relevant staff
members can be slow, especially during peak periods.
Inaccuracy
• Human Errors: Manually tracking bookings, sales, and schedules often leads to errors, such as
double-booking or inaccurate sales records.
• Inconsistent Updates: Lack of real-time synchronization between different parts of the system
can result in discrepancies, such as outdated schedules.
7|Page
Security and Access Control Issues
• Limited Access Control: Traditional systems may not offer role-based access, meaning cashiers
and managers might have the same access privileges, potentially leading to unauthorized
changes.
• Data Security Risks: Manual processes and non-specialized software increase the risk of data
loss or unauthorized data access.
4. Existing Tools and Technologies Used
• Spreadsheets (e.g., Microsoft Excel or Google Sheets) for tracking schedules and sales.
• Physical Ticket Books or Pre-Printed Tickets for ticket issuance.
• Standalone Booking Software or Point-of-Sale (POS) Systems with basic ticketing functions.
• Manual Cash Registers for handling payments.
5. Summary of Limitations
• Low Automation: The system heavily relies on manual effort, making it inefficient and error-
prone.
• Lack of Integration: There is no seamless integration between ticket booking, schedule
management, and sales reporting.
• Inaccurate Data Handling: Manual processes lead to data inconsistencies and limited reporting
capabilities.
• Limited Access Control and Security Features: Inadequate role-based access and data security
measures.
8|Page
Proposed System
The proposed Theatre Management system for managers and cashiers is designed to automate and
streamline cinema operations related to ticket sales, scheduling, and reporting. The system aims to
simplify the process of booking tickets, managing movie schedules, and generating reports, while
providing role-based access for cashiers and managers to perform their specific tasks efficiently.
1. System Overview
• Ticket Booking and Cancellation: Enable cashiers to quickly book or cancel movie tickets for
walk-in customers.
• Sales Reporting: Provide managers with tools to generate reports on ticket sales and cinema
performance.
• User Management: Offer role-based access control to limit functionalities based on the user's
role (cashier or manager).
2. System Requirements
• Cashier Functions:
o Ticket Booking: Cashiers can book tickets for customers, choosing available seats for a
specific showtime.
o View Schedule: Access the current movie schedule and seat availability.
• Manager Functions:
9|Page
o Sales Reporting: Generate daily, weekly, or custom sales reports.
3. User Interfaces
• Cashier Interface:
• Manager Interface:
o A dashboard for viewing key metrics (e.g., total sales, upcoming movies).
o Tools for managing movie schedules, configuring prices, and generating reports.
4. Database Design
• Entities:
o Movies: Contains movie details such as title, duration, genre, and rating.
o Bookings: Tracks all ticket sales, customer information, and seat assignments.
5. Manager Workflow
1. Log In: Manager logs into the system with manager-level credentials.
2. Manage Movies and Schedules: Add, update, or remove movie listings and showtimes.
10 | P a g e
3. View Sales Reports: Generate reports for analysis and decision-making.
6. Security Features
• User Authentication: Secure login with encrypted passwords to ensure user identities are
verified.
• Role-Based Access Control (RBAC): Different levels of access based on the role (cashier or
manager).
• Maintenance: Regular updates for bug fixes, performance improvements, and new features.
• Future Enhancements:
o Online Booking Integration: Expand the system to support web-based or mobile app
ticket booking.
o Multi-Theater Support: Add the ability to manage multiple cinema locations within the
same system.
o Loyalty Program Integration: Include features for customer rewards, memberships, and
loyalty points.
11 | P a g e
Objective of the Project
The Theatre Management System is designed not only for customers but also to enhance the workflow
for managers and cashiers at theaters. The objectives for each of these roles are distinct but aligned
toward improving operational efficiency and enhancing the customer experience. Below are the specific
objectives for managers and cashiers:
Objectives for Managers
1. Comprehensive Dashboard:
o Provide a centralized dashboard that allows managers to view real-time data on ticket
sales, occupancy rates, and upcoming showtimes.
o Enable quick access to key performance indicators (KPIs) to make informed operational
decisions.
2. Movie and Showtime Management:
o Allow managers to easily add, update, or remove movie listings and showtimes.
o Implement dynamic pricing strategies based on demand and occupancy, allowing for
quick adjustments to maximize revenue.
3. Analytics and Reporting:
o Offer robust reporting tools that analyze sales trends, customer demographics, and user
behavior.
o Generate automated reports for daily, weekly, and monthly performance, helping
managers to identify areas for improvement.
4. Promotional Campaign Management:
o Facilitate the creation and management of promotional offers, discounts, and loyalty
programs.
o Enable tracking and analysis of the effectiveness of marketing campaigns.
5. Inventory and Resource Management:
o Manage the allocation of resources, including theater screens, projectors, and staff
schedules.
o Ensure optimal use of facilities to maximize the customer experience and minimize costs.
6. User Management:
12 | P a g e
o Allow managers to create and manage user accounts for cashiers and staff, setting roles
and permissions based on job responsibilities.
o Monitor user activity for accountability and performance evaluation.
Objectives for Cashiers
1. Streamlined Transaction Processing:
o Provide cashiers with a user-friendly interface to quickly process ticket sales and manage
customer transactions.
o Ensure that cashiers can easily access customer booking information and payment details.
2. Real-Time Ticket Management:
o Allow cashiers to view real-time seat availability and booking statuses to assist customers
effectively.
o Enable quick resolution of any booking issues or changes requested by customers.
3. Customer Interaction Tools:
o Equip cashiers with tools to assist customers with inquiries regarding movies, showtimes,
and promotions.
4. Sales Tracking and Reporting:
o Enable cashiers to track daily sales, monitor cash flow, and prepare end-of-day financial
reports.
o Streamline the process of reconciling cash registers at the end of shifts.
5. Training and Support:
o Provide resources for training new cashiers on system operations and customer service
protocols.
o Implement support tools for cashiers to quickly resolve any technical issues they
encounter.
13 | P a g e
Fact Finding Technique
To effectively gather requirements for the Theatre Management System tailored for managers and
cashiers, a variety of fact-finding techniques can be employed. Each technique serves to uncover
specific needs, preferences, and operational challenges faced by these roles. Below are suggested
fact-finding techniques along with their application in the context of the movie ticket booking
system:
1. Interviews
• Application:
o Conduct one-on-one interviews with theater managers to understand their operational
challenges, ticket pricing strategies, and reporting needs.
o Interview cashiers to gather insights into their daily workflows, challenges faced during
transactions, and their needs for customer interaction.
• Purpose:
o To obtain in-depth information on how managers and cashiers envision the system
functioning and what features would be most beneficial for their roles.
2. Surveys and Questionnaires
• Application:
o Create structured surveys for managers and cashiers to gather quantitative data on their
preferences for system features (e.g., preferred payment methods, reporting metrics).
o Include questions about the frequency of specific tasks they perform and the challenges
they encounter.
• Purpose:
o To collect data from a larger group of stakeholders efficiently, enabling statistical analysis
of needs and preferences.
3. Observation
• Application:
o Observe cashiers as they process ticket sales and handle customer interactions. Take note
of common issues, workflow inefficiencies, and customer pain points.
o Observe managers during peak operational hours to understand decision-making
processes related to scheduling and promotions.
• Purpose:
14 | P a g e
o To gain real-world insights into the daily operations and interactions that may not be fully
captured through interviews or surveys.
4. Focus Groups
• Application:
o Organize focus group sessions that include both managers and cashiers to discuss their
experiences, expectations, and ideas for the new system.
o Facilitate discussions around the integration of features that can enhance workflow
efficiency and customer satisfaction.
• Purpose:
o To gather diverse perspectives and foster collaboration among stakeholders, potentially
generating creative solutions and features for the system.
5. Document Review
• Application:
o Review existing documentation, such as current ticketing processes, sales reports, and
customer feedback forms.
o Analyze manuals or guidelines used by cashiers and managers to understand existing
workflows and identify areas for improvement.
• Purpose:
o To provide context for current operations, helping to identify gaps in the existing system
that the new system could address.
6. Prototyping
• Application:
o Develop a low-fidelity prototype of the movie ticket booking system and present it to
managers and cashiers for feedback.
o Allow users to interact with the prototype to visualize potential features and provide input
on usability and functionality.
• Purpose:
o To facilitate early user involvement, ensuring that the design aligns with the needs and
preferences of both managers and cashiers.
7. Workshops
• Application:
15 | P a g e
o Conduct workshops with managers and cashiers to collaboratively define system
requirements and brainstorm potential solutions.
o Use facilitated sessions to discuss workflows, common challenges, and desired features
in an interactive environment.
• Purpose:
o To promote teamwork and engagement, enabling stakeholders to voice their needs and
concerns while developing a shared understanding of system requirements.
8. Use Cases and Scenarios
• Application:
o Develop use cases that describe specific scenarios for both managers (e.g., creating a new
movie listing) and cashiers (e.g., processing a ticket sale).
o Use these scenarios to identify specific functionalities that the system must support.
• Purpose:
o To clarify user interactions with the system and ensure that requirements are aligned with
actual user workflows.
16 | P a g e
Feasibility Study
1. Introduction:
The feasibility study assesses the viability of developing a travel and tourism agency website. The
The objective of this feasibility study is to assess the practicality of implementing a Movie Ticket
Booking System designed for theater managers and cashiers. The system aims to streamline ticket
sales, enhance customer service, and improve operational efficiency.
Technical Feasibility
• Infrastructure Requirements:
o Assess the existing hardware and software infrastructure of the theaters. Determine
whether current systems can support the new booking system.
• Software Development:
o Evaluate the technical skills of the development team and whether they have the
expertise to build and maintain the system.
• Integration Capabilities:
o Determine how the new system will integrate with existing systems (e.g., payment
gateways, customer relationship management systems).
Operational Feasibility
• User Acceptance:
17 | P a g e
o Assess the willingness of managers and cashiers to adopt the new system. Gather user
feedback to understand their concerns and preferences.
o Evaluate how well the new system aligns with existing workflows and whether it can
improve operational efficiency.
• Training Requirements:
o Determine the training needs for managers and cashiers to effectively use the new
system.
o Evaluate the availability of training resources and support for staff during the transition.
Economic Feasibility
Cost-Benefit Analysis
• Development Costs:
o Estimate costs for software development, including labor, technology, and infrastructure
investments.
o Consider ongoing maintenance costs, licensing fees, and potential subscription costs for
cloud-based services.
• Revenue Generation:
o Analyze potential revenue increases from improved ticket sales and customer
satisfaction.
o Consider the impact of promotional campaigns and loyalty programs enabled by the new
system.
o Calculate the expected ROI by comparing the potential financial benefits against the
estimated costs.
Legal Feasibility
Regulatory Compliance
18 | P a g e
o Assess compliance with data protection laws (e.g., GDPR, CCPA) regarding customer
data management and privacy.
• Licensing Requirements:
o Identify any necessary licenses or permits required to operate the system within the
jurisdiction.
o Ensure that the system complies with relevant theater operation regulations.
Scheduling Feasibility
Timeline Estimation
• Project Duration:
o Estimate the time required for system design, development, testing, and deployment.
• Resource Availability:
19 | P a g e
System Design
ERD
20 | P a g e
DFD
21 | P a g e
1st level Dfd
22 | P a g e
Data Dictionary
1. Tickets
Column Type
Ticket_no(Primary) INT
Showid INT
Seat_no INT
2. Hall
Column Type
Hall_id(Primary) INT
Class(Primary) Varchar(10)
No_of_seats INT
3.Movie
Column Type
Movie_id(Primary) INT
Movie_namePrimary) Varchar(10)
language Varchar(10)
23 | P a g e
4.Price
Column Type
Price_id(Primary) INT
Class(Primary) Varchar(10)
No_of_seats INT
5.Ticket
Column Type
Ticket_no INT
Show_id INT
Seat_no INT
24 | P a g e
Input Output Screens
1.Main window:
2 Details of Movie
25 | P a g e
3.Show Scheduling
4.Cashier
26 | P a g e
5 Booking
6.Seating
27 | P a g e
8.Showing of Ticket Number
28 | P a g e
9.Ticket_No in Database
10.Database
29 | P a g e
Conclusion
The Theatre Management system is designed to significantly enhance the operational efficiency and
customer service experience for both theater managers and cashiers. By automating and
streamlining the ticketing process, the system addresses many of the challenges faced by these
stakeholders in the current manual or outdated systems.
1. Enhanced Efficiency:
o The system automates various tasks such as ticket sales, seat selection, and payment
processing, allowing cashiers to handle transactions more quickly and accurately. This
efficiency not only improves the workflow for cashiers but also reduces wait times for
customers, leading to a better overall experience.
2. Comprehensive Management Tools:
o For managers, the system provides powerful tools for managing movie listings,
showtimes, and pricing strategies. The real-time data and reporting features empower
managers to make informed decisions based on sales trends and customer preferences.
3. User-Friendly Interface:
o The design of the system prioritizes usability, ensuring that both managers and cashiers
can navigate the interface with ease. Training programs will further enhance user
competency, leading to a smoother transition and higher user satisfaction.
4. Scalability and Future Readiness:
o The architecture of the system is designed to be scalable, accommodating future growth
in ticket sales, customer base, and additional features. This adaptability ensures that the
system remains relevant and effective as the theater industry evolves.
.
Implementing the Theatre Management System represents a significant step forward in modernizing
theater operations. It not only enhances the capabilities of managers and cashiers but also positions
the theater to better meet the needs and expectations of its customers. As the entertainment landscape
continues to change, adopting such a system will help theaters remain competitive and provide an
exceptional experience for moviegoers.
In conclusion, this system is not just a technological upgrade; it is a comprehensive solution that
integrates management, operational, and customer service functions, paving the way for improved
business outcomes and customer satisfaction.
30 | P a g e
Future Scope
The Theatre Management system for managers and cashiers has significant potential for future
enhancements and expansions. As technology evolves and consumer preferences shift, the system
can adapt to meet new challenges and opportunities in the theater industry. Below are some potential
areas for future development:
• Mobile Ticketing:
o Develop a companion mobile application for customers, enabling them to book tickets,
select seats, and make payments from their smartphones.
• Push Notifications:
• Data-Driven Insights:
o Introduce advanced analytics tools to analyze customer behavior, ticket sales trends, and
occupancy rates, enabling managers to make informed strategic decisions.
• Predictive Analytics:
o Use machine learning algorithms to forecast demand and optimize pricing strategies
based on historical data and trends.
• Personalized Marketing:
o Integrate CRM systems to track customer preferences and purchase history, allowing for
targeted marketing campaigns and personalized offers.
• Loyalty Programs:
o Develop sophisticated loyalty programs that reward repeat customers with points,
discounts, or exclusive access to events.
31 | P a g e
• AI Chatbots:
o Explore the use of VR/AR for virtual seat previews and immersive promotional
experiences, allowing customers to experience movies in a new way.
• Social Sharing:
o Allow users to share their booking experiences on social media platforms, promoting
movies and enhancing audience engagement.
• Influencer Collaborations:
o Collaborate with influencers to promote films and ticket sales through social media
campaigns directly linked to the booking system.
o Implement dynamic pricing strategies that adjust ticket prices in real-time based on
demand, competitor pricing, and occupancy levels.
o Develop tools that allow managers to analyze pricing performance and make data-driven
adjustments to maximize revenue.
o Allow integration with third-party booking platforms, increasing the theater's visibility
and sales opportunities.
o Explore partnerships with travel agencies and event planners to offer bundled ticket
packages and promotions.
32 | P a g e
8. Sustainability Initiatives
• Digital Ticketing:
o Promote digital ticketing to reduce paper waste and enhance convenience for customers.
• Eco-Friendly Promotions:
o Introduce eco-friendly initiatives and promotions, such as discounts for customers who
choose digital tickets or eco-friendly transportation options to the theater.
33 | P a g e
Bibliography & References
• www.Google.com
• www.youtube.com
• www.w3schools.com
34 | P a g e