CS 8630 Project Presentation

1
CS 8630 Project Presentation

• Instructor Dr. Guimaraes
• Members Chieu Wang Bohan Huang

2
Online Cinema System (OCS)

• Overview
• An interactive online cinema booking system.
• Provide Customer Administrator functions.
• Customer online registration, movie preview,
  interactive seat booking, view movie schedules.
• Administrator online maintenance of movies and
  cinema records, customer list generation.

3
Technology Used

• Database Microsoft Access 2003.
• Java Database Connectivity JDBC.
• Apache Tomcat Web Server.
• Java Server Pages JSP.
• HTML.
• Java Scripts.

4
Application Development

• Research existing systems and collect possible
  roles for system.
• Create E-R diagram Relational Schema.
• Deploy Apache Web Server Test connectivity.
• Develop JSP pages and Java Scripts.
• Build base tables.
• Testing and debugging.

5
Specifications Development

• Discussion and role play on functions.
• Based on past personal experiences using the
  manual system.
• Sort and rank functions for development.
• Decide to work on core functions and seat
  booking before others.

6
Development PrioritiesCompleted

• User log In.
• Profile administration.
• User registration.
• Movie previews.
• Movie show times.
• Movie seat reservation.
• Booking list.

7
System Restrictions

• Customers restricted to book a maximum of 4 seats
  per cinema per show time.
• Movie show dates valid for 7 days in advance.
• Static show time allocated to each cinema.
• No payment collection implementation. Only seat
  reservations and maintenance.

8
Case Diagram
9
OCS E-R Diagram
10
Relational Schema (a)
11
Relational Schema (b)
12
CRUD Matrix
13
Customer Functions

• Existing customer login.
• New customer registration.
• Change existing data in customer record.
• Preview movies.
• View movies schedules.
• Reserved seats.
• Delete booked seats.

14
Administrator Functions

• Modify administrator record.
• Add, modify, and delete of movies records.
• Add, modify, and delete of cinema records.
• View movies schedules.
• View customer list.

15
OCS Intro Screen
16
Unregistered Customers Option Screen
17
New Customer Registration
18
Preview Movies
19
Movie Show Times
20
Registered Customers Log In
21
Registered Customers Option Screen
22
Registered Customer View/Edit Profile
23
Registered Customer Book a Seat
24
Registered Customer Book a Seat
25
Registered Customer booked seats
26
Registered Customer Delete a Seat
27
Administrator Log In
28
Administrator Option Screen
29
Administrator View/Edit Profile
30
Movie Administration Panel
31
Cinema Administration Panel
32
Customer Listing
33
Problems Encountered

• Time constraint full time work and project.
• JSP not very suitable for interactive processing.
• Java Beans makes some JSP modules excessively
  complex.
• Debugging of JSP is extremely difficult with
  available free tools.

34
What we learnt from the project

• Design of database schema first very important.
• Team communications are very important in
  resolving discrepancies.
• Bugs, bugs, and more bugs. They are everywhere.
• We need a smarter IDE/Debug tool for JSP, Apache,
  and scripting errors.

35
Possible Suggestions and Enhancements

• Conversion to ASP.NET could ease debugging.
• Available plug-in will help in development in
  ASP.NET.
• Beef up data validation.
• Conversion to Oracle database.

36
Questions?