Cinema Information management system

Cinema Information Management System

Project Report

Dedication I dedicate this project to my teacher, dear parents and sisters who were a great support.

1


Project Report

Acknowledgement

First of all I thank ALLAH, the Almighty, for bestowing me with determination and grit to undergo the project. I owe my gratitude to many people for the guidance they endowed me with. Foremost on the list is Ms Jaweria Malik, my supervisor, who was sheer source of guidance and encouragement. I am also gratified to my family whose suggestions have helped me to improve and render this project

2


Project Report

Abstract In this project Cinema Information Management System is developed for Cinepax. Database is designed in Microsoft Access. It is designed to manage the record about movies schedule, movies collection, ticket sales and press releases. It provides the friendly interface to the user to enter, retrieve and manage records through tables, form, queries and reports.

3


Project Report

Table of Contents Sr.

Content

Page No

1

Problem Statement………………………………………….…....

5

2

Introduction…………………………………………………….....

3

Scope of Project………………………………………….………..

7

4

Proposed System………………….……………………….……...

8

5

Entity Relationship Diagram………………………………….....

12

6

Data Flow Diagram…..…………………………………………...

13

7

Hardware Software Requirements…...…………………………

16

8

Component of Access Database….…………………..….……….

19

9

Tables....…………………………………………………………...

20

10 11 12 13

Forms……………………………………………………….…...… Queries……………………………………………………….……. Reports…………………………………………………….….…... Conclusion…………………………………………………….…...

22 27 28 32

no

5

4


Project Report

Problem Statement Since the existing system is completely manual so it is really very difficult to maintain and to keep a full record about the daily purchase of tickets. The information is not up to date and manual system requires staff to maintain their records on the registers. It creates many problems such as Black ticketing, duplication of data or information is also present which creates an error.

Introduction Database A computer database is a structured collection of records or data that is stored in a computer system. A database relies upon software to organize the storage of the data and to enable a person or program to extract desired information. The term "database" refers to the collection of related records, and the software should be referred to as the database management system (DBMS). This is sometimes shortened to “database manager or database system”.

Database Management System A database management system (DBMS) is computer software designed for the purpose of managing databases. Typical examples of DBMSs include Oracle, DB2, Microsoft Access, Microsoft SQL Server,

MySQL. DBMSs are typically used by Database

administrators in the creation of Database systems. The DBMS accepts requests for data from the application program and instructs the operating system to transfer the appropriate data. When a DBMS is used, information systems can be changed much more easily as the organization's information requirements change. New categories of data can be added to the database without disruption to the existing system.

5


Project Report

Microsoft Access Microsoft Access is a relational database management system from Microsoft which combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a member of the 2007 Microsoft Office system. Access can use data stored in Access, Microsoft SQL Server, Oracle. Relatively unskilled programmers and non-programmer can use it to build simple applications. It supports some object-oriented techniques but falls short of being a fully object-oriented development tool. Access is used by small businesses, within departments of large corporations for handling the creation and manipulation of data. Access can be used as a database for basic web based applications hosted on Microsoft's Internet Information Services and utilizing Microsoft Active Server Pages ASP.

Introduction to organization Cinepax is the first cinema in Pakistan that is providing a world class movie-going experience to people of Pakistan by building a state of the art movie theatre in urban cities. Cinepax is the first dedicated Cineplex Company in Pakistan that is building the country’s first nationally branded Cineplex chain. It is targeting larger cities of Pakistan; Karachi, Lahore, Islamabad, Faisalabad, Gujranwala, Multan and Hyderabad. It The company plans to develop 120 screens over five years. The cinema complex would screen premium contents in a family-friendly environment having world class seating arrangements and air conditioned halls that would be open from 12 noon to 12 midnight. The Cineplex shows English, Urdu and Punjabi films besides cartoons. Total Area of Cinepax is 33225 Square feet, Total Cinema screens are 5 and the halls are equipped with total 1400 seats.

6


Project Report

Scope of project Development of Cinema Information Management System for Cinepax helps in managing the database for storing and retrieving required information about movies schedules, movies collections, ticket sales and press releases. It has a friendly user interface which makes the database management system easy to use for common users.

Advantages of project Efficiency It gives the required information about the movies scheduled, tickets sales, press releases and other data in less time. Security The Cinema Information Management System developed for this project is very secure and cannot be hacked or accessed by any stranger. Facilities It is very easy to access and retain the information about movies schedules, movies collections, ticket sales and press releases. Time It takes less time to store new information and to retrieve required information from the database management system. Flexibility This database management is flexible as it can be easily modified when some changes in the system is required.

7


Project Report

PROPOSED SYSTEM INTRODUCTION The need is to computerized the ticketing system of Cinepax cinema. There are various attributes and properties of the movies that help to maintain and manage records through this software. MOVIE’S ID All the movies are assigned a unique code which helps in identifies the record of each movie. MOVIE’S NAME It gives opportunity to the user to select the movie by recognizing through its name. MOVIE’S LANGUAGE It tells about the language of the movie. MOVIE’S DURATION It shows the duration of movie. MOVIE’S SYNOPSIS AND CAST It gives the customer an overview about the story and cast of the movie. MOVIE’S DAY, DATE, TIME AND SCREEN It tells about the day along with the time and screen on which the movie will be showed. This helps in telling the customer about the timings of the movie shows. TICKET’S PRICE It tells about the price of ticket of the movie (identified by movie’s ID). TICKET BOOK NUMBER (First and Last Ticket Number)

8


Project Report

It describes the ticket book number assigned to that movie (identified by movie’s ID) and also the start and end ticket number of that ticket book. TICKETS SOLD It tells the total number of the tickets being sold for a specific movie (identified by movie’s ID).

OBJECTIVES OF PROPOSED SYSTEM The software is planned by keeping in mind all those necessities and provisions so that it should not have a single thread of complexity in it. The software that is projected is able to overcome all the flaws that are mentioned before and will be helpful for further expansion. EFFICIENCY By computerizing the front desk it increases the efficiency of work like updating of the data regularly maintenance of the data properly with all attributes of the movie. SECURITY Obviously with a computerized system, the data can be stored more properly. Also it will make sure that there remain no chances of fraudulence in money matters. TIME SAVING By introducing the new technology we save our time like in file system we require more time to update the data but in new system we just open the record and can make changes or can update the data and also help to save time in dealing the customers. ACCURACY The computerized system will be accurate enough to provide minimum errors and to perform any no of calculations. However facilities will be provided to remove the problems which may be present in the system. FLEXIBILITY 9


Project Report

It provide flexibility as in file system there are large numbers of files and are difficult to maintain or save but in new technology there is separate group or domain for each movie to record data. USER FRIENDLY The system will be user friendly. The software will create a flexible and comfortable environment and it leads to make everything more wholesome and beneficial. RELIABILITY Reliability is the ability of system to perform and maintain all functions in routine circumstances as well as in unexpected circumstances so that it can work properly in any sort of problem. The system has been made reliable enough to cope up with hard situations.

PURPOSE This section will define all system requirements for the “Computerized Ticketing System”.

INTENDED AUDIENCE AND READING SUGGESTIONS The targeted audience for this software requirements specification document mainly includes the users, developers and testers.

SCOPE The software will provide ability to the staff to enter the new records of the movies, delete and also update them. It will also allow keeping the record of the total tickets sold.

FEATURES The features provided by the system are: 1- Easy access to database containing the details of all movies. 2- Each movie will be assigned a unique code and its ticket price can simply be identified by just entering its code. 10


Project Report

3- Features available in the movies collection form have easy access which include, back, forward, create, delete and update query etc. 4- Features available in the movie schedule form tell about the day and timings of the movie shows. 5- Features available in the daily ticket sales form provide complete details about the ticket sold on each day. 6- Help in reducing the work load and saves time.

GENERAL DESCRIPTION PRODUCT PERSPECTIVE This software will allow the user to handle the work efficiently and gain customer satisfaction and help to increase reliability. PRODUCT FUNCTIONS Main aim is to computerize the manual system to save time and extra effort required managing the file system. The software system will help the User  To keep the records of all movies  Maintain or update the record of movies  Easy access to database containing information  Exact calculation of tickets sold. USER CHARACTERISTICS: The user will be trained or qualified person user profile is specified below: •

He is a person who is authorized to enter, delete, update and edit the data in database.

•

He is the person who will operate the software to calculate the total amount of the tickets sold along with their total price.

GENERAL CONSTRAINTS No constraints have been noticed for the system.

ASSUMPTION AND DEPENDENCIES We assume that user has general understanding of computer and also user understands the instructions written in English language. 11


Project Report

Notation for Entity Relation Diagram

Entity Relationship Diagram

12


Project Report

Data Flow Diagram Notation for Data Flow Diagram

13


Project Report

Level 0 DFD

14


Project Report

Level 1 DFD

15


Project Report

SPECIFIC REQUIREMENTS: Mouse, PC, Printer. The Hardware and Software requirements for the proposed system are:  HARDWARE REQUIREMENTS Physical memory (RAM): 512 MB minimum, 1 GB recommended Virtual memory: Double the amount of RAM Temp disk space: 100 MB Hard disk space: 2 GB Video adapter: 256 colors Processor: 200 MHz minimum  SOFTWARE REQUIREMENTS System Architecture: 32-bit Operating System: Computerized Ticketing System for Windows is supported on the following operating systems: • Windows NT Server 4.0, Windows NT Server Enterprise Edition 4.0, and Terminal Server Edition with service pack 6a or higher are supported. • Windows 2000 with service pack 1 or higher. • Windows Server 2003 • Windows XP Professional

EXTERNAL INTERFACE REQUIREMENTS: •

Graphical User Interface The GUI system will provide user with easy access to needed functions.

•

User Interfaces For entering data, button is available in database. For searching any information regarding the movie queries are also available.

•

Hardware Interfaces Our project will be implementing on “Microsoft Access”. So it communicates directly with the operating system and indirectly with hardware. Physical connections of different

16


Project Report

parts of the system are e-g. plug\ socket compatibility, mouse monitor control, physical space utilization, wiring correctness etc electronic compatibility of hardware units. •

Software Interfaces Software has been linked with database to see and select the appropriate movie details. Software units communicate by setting pre-defined parameters and through shared area of memory. Software units communicate by calling pre-defined procedures. Moreover that “C++ Compiler” or “C SHARP” can be used. It will help to link database as well as will provide a good and easy interface to the user due to friendly GUI. It also helps in simple program execution and calculations.

NON-FUNCTIONAL REQUIREMENTS  Accessibility  Control  Availability  Certification  Dependency  Documentation  Efficiency (resource consumption for given load)  Effectiveness (resulting performance in relation to effort)  Extensibility (adding features, and properties at next major version upgrade)  Legal and licensing issues  Maintainability  Performance  Platform compatibility  Price  Quality (e.g. Faults Discovered, Faults Delivered, Fault Removal Efficacy)  Reliability  Resource constraints (processor speed, memory, disk space, network bandwidth etc.)  Security 17


Project Report

 Software, tools, standards etc. Compatibility  Stability  Supportability Accessibility Our new Computerized Ticketing System is accessible to each and every person. It means that arrangements of every kind will be available i.e "ability to access" the functionality, and possible benefit, of our system. Accessibility is often used to focus on people with disabilities and their right of access to entities, often through use of assistive technology. Availability The system will be available only for the ticketing staff of the cinema to maintain the movie’s record and for appropriate and correct entry of the data. Documentation The complete documentation of whole system including the records will be provided to the company. It will be in the form of hardware as well as software which will provide any sort of help regarding to the system and user guides. Maintainability Efforts will be made in order to face the following problems •

correct defects

•

meet new requirements

•

make future maintenance easier

•

cope with a changed environment

Quality Efforts will be made in order to cope up with the conditions and to improve the quality along with ability to meet quality standards. Reliability 18


Project Report

Reliability is the ability of system to perform and maintain its functions in routine circumstances, as well as hostile or unexpected circumstances. The system has made reliable enough to cope up with hard situations. Usability Usability is a term used to denote the ease with which people can employ a particular tool or other human-made object in order to achieve a particular goal. Usability can also refer to the methods of measuring usability and the study of the principles behind an object's perceived efficiency or elegance.

OTHER REQUIREMENTS COST AND SCHEDULING After settling down the initial stages and deciding the proper plan to constitute the software it is necessary to determine the cost and time frame to complete the project. So after analyzing the whole requirements and resources for project it is concluded that total budget required for the project will be around 2, 50,000 rupees and time consumed to complete this project be definitely around 1 month. The project will be completed and delivered in time.

Components of Access Database Main components used in Access Database are •

Tables

•

Queries

•

Forms

•

Reports

Tables A table is made up of rows and columns of cells that you can fill with text and graphics. Tables are often used to organize and present information. A table is a collection of data 19


Project Report

about a specific topic, such as products or suppliers. Using a separate table for each topic means that you store that data only once. This results in a more efficient database and fewer data-entry errors.

Queries Query is a mean of finding all the records stored in a data source that fit a set of criteria named by the user. Queries can contain operators, quotation marks, wildcard characters, and parentheses to help focus your search.

Forms A form is a type of a database object that is primarily used to enter or display data in a database. You can also use a form as a switchboard that opens other forms and reports in the database, or as a custom dialog box that accepts user input and carries out an action based on the input. Reports Reports are used for printing information from database. A report can be combine data from more then one table. Reports are designed by adding visual objects known as controls to the design grid.

TABLES Daily Ticket Sales Table This table contains the Date, Movie ID, Ticket Price, Ticket book number, First Ticket number, Last Ticket number and total numbers of tickets sold.

20


Project Report

Movie Schedule Table This table contains movie ID, date, day, movie name, time and screen number.

Movie Collection Table This table contains movie ID, name, language, duration, image, synopsis and cast of the movie.

21


Project Report

Press Release Table This table contains press release number, headline, release date, publish date, publication, circulation, page number and station.

FORMS

Main Form

22


Project Report

Movies Collection Form In this form, user can view, enter and delete information about movies collection which includes movie ID, name, language, duration, image, synopsis and cast of the movie.

23


Project Report

24


Project Report

Movies Schedule In this form, user can view, enter and delete information about movies schedule which includes movie ID, date, day, movie name, time and screen number.

25


Project Report

Daily Ticket Sales Form In this form, user can view, enter and delete information about daily ticket sales which includes Date, Movie ID, Ticket Price, Ticket book number, First Ticket number, Last Ticket number and total numbers of tickets sold.

26


Project Report

Press Release Form In this form, user can view, enter and delete information about press release which includes press release number, headline, release date, publish date, publication, circulation, page number and station.

27


Project Report

QUERIES Daily Ticket Sales Query

Movies Schedule Query

Movie Ticket Sold Query

28


Project Report

REPORTS

29


Project Report

30


Project Report

31


Project Report

32


Project Report

Conclusion The testing of this system should prove that this system is perfect or the organizations to do their work in a more appropriate form. There are many aspects of this computerized system. The organization is now using this system and by the help of this system their efficiency has been increased. This is also a time saving system which can do many things automatically and in very short time, which were done manually by the users before this system. This system is formed in such a way that it will contain all the latest features. It is more reliable than any other system available for data saving now days. In the future further developments could also be done on it to make it more efficient.

33

Cinema Information management system

Recommend Documents