LAB PROJECT CSC 405: FINAL REPORT
1.0 GROUP ORGANIZATION CHART
DATABASE PROJECT
MANAGER
(Noor Syaza Aqilah)
DATABASE
DATABASE ENGINEER
ADMINISTRATOR
(Amal Hanani)
(Ainnur Syamira)
2.0 ORGANIZATION INTRODUCTION
2.1 LOCATION
Star Cinema Sdn Bhd owns and operates cinema screen in Malaysia only. It was first established
in Sungai Petani, Kedah on 21 July 2001. The location was selected due to the highest population
of people that lived in one place which would contribute a lot of profit to our company. Moreover,
the population of teenager which age between 18 to 30 years old is the highest. This is the
concrete reason why our company had started a business in this area. It was distributes
independently Malay, Chinese, English, and other foreign language films: and represents
independent cinema operators in media sales for advertising on cinema screens. Star Cinema has
broad its wing and available in all cities except for Kelantan and Kuala Pilah. In 2010, Star
Cinema will introduce the country’s first Screen X theatre which is a multi-projection theatre.
2.2 BACKGROUND INTRODUCTION
• DATABASE PROJECT MANAGER
NAME NOOR SYAZA AQILAH BINTI AMRAN
MATRIX NO 2019317049
GROUP AS246 1A1
IC NO 981209-01-5870
ADDRESS NO 25, JALAN BKI 11, TAMAN BUKIT KATIL
INDAH, 75450 MELAKA
PHONE NO 014-9488617
EMAIL syazasyeno@gmail.com
JOB DESCRIPTION • Ensure database management and maintenance
tasks are performed effectively.
• Ensure that database is developed according to
business requirements.
• Manage a team of professionals to design and
develop database systems.
• Provide guidance to database team on database
structures and features.
• Create standard procedures to enhance
scalability and performance of existing database
architecture.
• Troubleshoot complex database issues in
accurate and timely manner.
• DATABASE ADMINISTRATOR
NAME AINNUR SYAMIRA BINTI KAMARUDIN
MATRIX NO 2019391257
GROUP AS246 1A1
IC NO 980513-01-6654
ADDRESS NO 26, JALAN MEGAH 30, TAMAN MEGAH, 83000 BATU
PAHAT, JOHOR
PHONE NO 013-7273315
EMAIL ainnur.syamira@gmail.com
JOB
DESCRIPTION • Map out the conceptual design for a planned database
• Establish the needs of users and monitoring user access
and security
• Ensure that storage and archiving procedures are
functioning correctly
• Manage the security and disaster recovery aspects of a
database
• Monitor performance and manage parameters in order to
provide fast responses to front-end users
• DATABASE ENGINEER
NAME AMAL HANANI BINTI ZIKRI
MATRIX NO 2019545001
GROUP AS246 1A1
IC NO 981010-02-6740
ADDRESS NO 490, LORONG 2/3 TAMAN KEMPAS, 08000 SUNGAI
PETANI, KEDAH.
PHONE NO 011-31753057
EMAIL amal.hanani988@gmail.com
JOB
DESCRIPTION
• Assist in design and development of database systems
• Optimize database systems for performance and
reliability.
• Perform database maintenance and troubleshooting
activities.
• Test database systems and perform bug fixes.
• Identify and rectify database errors in a timely manner
3.0 CURRENT SYSTEM
At first, Star Cinema Company only provide walk in based system for customer to watch movies
at our cinema. We stored the data in file system and keep in the cabinet. As time flies, the files
getting more complicated and increase in time.
The speciality that lies in this company is we provided the recent and old movies because some
cinema company would not allow the old movie to be appeared on screen anymore in some
period of time. So here, we have brought the customer outstanding characters compared to other
cinema complex by allowing the old movie to be on screen. Therefore, customer can have a long
of time to enjoy the movie. Our company has also provided three different types of which couple,
standard and family. It would be more joyful for the customer to choose on which seat they
wanted to seat and get more comfortable while watching the movie. The couple seat was offered
to couple people while family seat is for a big family members and standard for those who would
go any kind of situation. This opportunity is rarely offered by some cinema company.
Furthermore, there are also three types of theatre which are deluxe, standard and premium.
Customer can choose based on their preferences. The movies provided are including all type of
genres such as for kids, for action movie, for a comedy and many more. The price offered is
affordable and reasonable for all customers. The movies are available in most of the time
according to the trending list.
4.0 CURRENT SYSTEM PROBLEM
As file increase in number, the data was unorganized and hard to find as the number
records increase.
It is difficult to compile and store the data recorded in a file.
It occupied a lot of space to store the recorded data in the cabinet.
The walk in based system consumed a lot of time and energy which make customer to
have a long queue at the counter.
The counter becomes more chaos as many people come to buy tickets at the counter.
4.1 STEPS IN CURRENT SYSTEM
Customer store data
record
walk in in files
5.0 PROPOSED SYSTEM PROCESS
The organization business of Star Cinema is basically an online website for ticket booking that
serves for customer to easily access by them and reduce their time consuming. Star Cinema has
provided a website for customer to easily access for the purpose online ticket booking.
An interface was created to allow people to login to their account before starting to book their
tickets and movies. The interface was including the login session which appeared with the
username of the members and the password of the members. Before customer has the ability to
login, they must sign up for new members. The member’s details have been kept in the system so
that they have their record. After the customer had login to their account the system will bring
them to another form which is the main menu that contain the ticket booking and the now
showing movie. Customer can choose either to click on ticket booking or now showing movie.
The now showing movie will lead customer to a new form which appeared in several pictures to
show the movies that are currently showing and the customer can see and choose either one of the
movies.
However, if the customer has clicked on the ticket booking it will appear in a new form that listed
out the details of ticket id, username of the customer, the seat number, the time of movie and the
total price. All of the data will be recorded in the reports so that our company could see how
many customers have been signed up for the members, the total ticket that has been sold out in a
month and transactions that occurred between the customers. Every detail of the elements such as
customer, theatre and movies will be listed out in the query to extract the information and to know
the total of every detail that has been recorded in the system.
5.1 STEP IN PROPOSED SYSTEM PROCESS
log in / main ticket
print record
sign up menu booking
6.0 PROJECT DESCRIPTION
Based on the previous system, Star Cinema Company only provides walk in base for customer
to book their tickets which sometimes give difficulty for the customer to have a long queue
for buying the tickets. To improve the system and make it more efficient our company has
come out with a new idea by creating a new website which allowed customer to book their
tickets through online. The customer needs to be a member by creating an account before they
get to log in to book a ticket. This system has provided an easier way for the customers to
book and watch the latest movies. It will save energy and time for customer to book a ticket.
This system provides QR code after customer book their ticket and they can simply walk to
the counter to scan the code before enter the theatre.
INTERFACE
The interfaces that will appear soon as customer open the ticket booking website. Customer
need to fill up their username and password. A new member can click on the sign up button to
be a member before get to log in and before proceed to another form.
Figure 1: Login Interface
FORMS
After customer has log in to their account, the main menu will guide customer so they can choose
either to click on the ticket booking for booking details or to click on the now showing button to see
the movies that will be showing. Therefore, customer can click on the ticket to print out their actual
ticket that has details on it.
Figure 2 : Main Menu Form
Figure 3: Now showing Form
Figure 4: Ticket Booking Form
Figure 5: Ticket QR code
As customer click on the ticket button it will appeared as the figure above. The customer can
simply print out their ticket and walk to the account to scan the QR code before enter the
theatre.
Figure 6: Sign up Form
To a new member who attempt to log in, they need to create a new account by fill in the form
so that their details will be recorded in the system and allow them to log in to book their
tickets.
REPORTS
The recorded reports are for reference so that the organizer gets to see how many customers have
purchased the ticket and other details that related to the movie which include the date, the ticket price,
the type of seat, the theatre and the show time.
Figure 7: Aquaman Movie Reports
Figure 8: Friendzone Movie Reports
Figure 9: Ralph Break The Internet Movie Report
Figure 10: Avengers Movie Report
Figure 11: Ticket Booking Report
The ticket booking report as shows above has recorded the total revenue for three months
which are March, April and May in 2019. Therefore, the organizer gets to calculate the profits
that collected from the reports.
TABLE
The tables below show at least 10 records for each table which include ticket booking, movie,
seat, show time and ticket table. Ticket booking works as a medium that link together between
customer and the other details that can gather and keep all the data together in one place.
Figure 12: Ticket Booking Table
Figure 13: Movie Table
Figure 14: Seat Table
Figure 15: Show Time Table
Figure 16: Ticket Table
ERD (Entity Relationship Diagram)
The entity relationship diagram below show the relationship between one tables to another
table with the primary keys labelled. The ERD has make an easier way for the organizer to see
the relationship and relate to each and another table.
Figure 17: ERD
BUSINESS RULES:
o One customer can purchase many tickets and one ticket can be purchase by only one
customer.
o One ticket for one Show Time and one Showtime can have many tickets.
o One ShowTime for one movie and one movie can have many ShowTime.
o One theatre can have many tickets and one ticket is only for one theatre.
o One theatre can have many seats and one seat is only available at one theatre.
o One ticket is only for one seat and one seat is only for one ticket.
o One theatre can screen many movies but one movie only screen at one theatre.
o One customer can have many ticket booking but one ticket booking is only booked by one
customer.
o One customer can have only one seat and one seat can be seated by only one customer.
o one ticket booking session consists of many tickets, one ticket can only be in one session.
o One seat can have only one ticket booking and one ticket booking for one ticket.
QUERY
A query is a request for data results, and for action on data. The query is to perform
calculation query that uses to retrieve data from a table or to make calculations are called
select query. Below is the example of query in our database system. The query has listed out
in details for selected components.
Figure 17: Customer Query
Figure 18: Aquaman Movie Query
Figure 19: Avengers Query
Figure 20: Friendzone Movie Query
Figure 21: Ralph Break The Internet Movie Query
Figure 22: Upin Ipin Query
Figure 23 : Theatre 1 Query (Standard)
Figure 24: Theatre 2 Query (Deluxe)
Figure 25: Theatre 3 Query (Premium)
7.0 PROJECT OBJECTIVE
The objectives of this project are:
1) To improve the computer’s data management by introducing the use of RDBMS.
2) To produce a systematic system which easily to process and access.
3) To get more accurate data that lies between the transactions.
4) To create more effective and efficient system that can store abundant of data.
8.0 PROJECT SIGNIFICANCE
The benefits from using this system are:
Easily access by the customers and organizers.
Reduce time consuming.
Avoid from getting a redundant data.
Provide a better platform for the customer to purchase the tickets.
