Project Synopsis
Types of user 3 and their functionality
1. Admin
2. Customer
3. Guest
1 Admin
• Add movie
• Update movie
• Delete movie
• Add theatre
• Update theatre
• Delete theatre
• Login
• logout
• Add offer
• Delete offer
• Generate various reports
1. Customer payment status
2. View theatres
3. View movies
4. Month wise customer transaction details
2 Customer
• Login
• Logout
• Delete account
• Search theatre
• Search movies
• View offer
• Book movie
• View/edit profile
• Change password
• View booking history
3 Guest
• Search theatre
• Search movies
• View offer
• Sign up
Table Columns Data Type Constraints
customer
customer_id PK NUMBER(10) PRIMARY KEY
first_name VARCHAR2(20) NOT NULL
last_name VARCHAR2(20)
email VARCHAR2(20) NOT NULL,UNIQUE
mobile VARCHAR2(10) NOT NULL,UNIQUE
date_of_birth DATE NOT NULL
loginid VARCHAR2(20) NOT NULL, FOREIGN KEY
user_type
loginid VARCHAR2(20) PRIMARY KEY
usertype VARCHAR2(20)
Not null
password VARCHAR2(20) NOT NULL, CHECK length>6 characters
movie
movie_id NUMBER(10) PRIMARY KEY
movie_name VARCHAR2(50) NOT NULL, UNIQUE
movie_desc VARCHAR2(500 )NOT NULL
release_date DATE NOT NULL
duration NUMBER(3) NOT NULL, CHECK (duration> 60)
cover_photo_url VARCHAR2(500 )NOT NULL
trailer_url VARCHAR2(500 )NOT NULL
**movie_theatre
theatre
theatre_id NUMBER(10) PRIMARY KEY
theatre_name VARCHAR2(20) NOT NULL, UNIQUE
city_name VARCHAR2(20) NOT NULL
ticket_price NUMBER(5,2) NOT NULL, DEFAULT = "150.00"
booking
booking_id NUMBER(10) PRIMARY KEY
customer_id NUMBER(10) NOT NULL, FOREIGN KEY
movie_id NUMBER(10) NOT NULL,FOREIGN KEY
theatre_id NUMBER(10) NOT NULL,FOREIGN KEY
booking_date DATE NOT NULL
no_of_seats NUMBER(10) NOT NULL
*Main schema has been given create other
tables for all requirements.
**Movie_theatre table should have movieid
& theatreid
Detailed Functionality:
1) should maintain a common theme for all pages
2)pages should have header nav bar and footer
3)add some static pages like about us ,contact
as per your choice
Admin:
1)This page contains a form to accept movie
details.
Movie id should be generated programmatically.
Theatre id should be displayed in the combo list
Movie des field should contain all the details of the
movie. check release date should not be older
than the current date
Create a folder to store movie photo and add
url to the field.
2)except id other thing can be updated in update
movie check release date should not be older than
the current date
3)admin should get the list of movie along with
button to delete the respective movie from the
list.
4) theatre id should be randomly
generated unique number
5)check theatre name has already in the
database or not
6) except id other thing can be updated in update
theatre
7)admin should get the list of theatre along with
button to delete the respective theatre from the
list.
8)based upon frequently booked movies
admin can offer discount for specific user
Develop a business logic to generate offer to
certain customer and store them into the database
Maintain a table for offer
9)admin can add the offer by filling up a form and
also delete any specific offer
10)admin home page should have links to get info
regarding customer movie and theatre ,also can
get the details of customer payment status and
monthly transaction.
Customer:
1) in customer home page he should get option to
delete account->(all the data related to that
customer should be deleted from the back end)
2)change password will ask old password new
password and confirm new password check if
old & new are same or not also check new and
confirm new password is matched or not.
3) In edit profile except email and username other
things can be changed
4)customer can view order history that will display
all his/her previous booking details
5)when customer wants to book a movie he/she
has to select theatre from the list and provide
number of seats required and will be redirect to
the payment page(payment should be a dummy
one will ask for credit/debit card payment,
customer has to provide card number, name,
expiry month/year and csv number)after a
successful payment customer should get a
payment receipt.(after payment process payment
status should be marked as “pending”, admin
should change it as “success” from admin portal).
Guest
sign up form
Will have first name, last name, date of birth, login
id & password, check password should have 6 digit
length along with show strength while entering
combination of lower case, uppercase number and
special letters(#$_). Check if username has already
been registered or not, display suitable error msg
for all validation.
a) Home page should contain login option and all
search facility after login customer and admin should
get same home with additional links.
b) Search option must have the option to search by
movie name, search by theatre name search by
releasing date
c)guest user can able to search, view offer and signup
*session should be maintained properly.
* all the form should have validation for fields
* use ajax in appropriate place
* proper back end structure should be maintained.
