Developing for the Internet (Solent Cinemas) - Assignment Example

Developing for the Internet (Solent Cinemas) Introduction As required by the company, Solent Cinemas, to convert their typical company profile HTML or static website to a more dynamic and interactive facility site online for movie-goers and their valued-customers. The utilisation of database and some server-side scripting will provide this task a smooth change and serve the aim for this project to maximise customers and meet their satisfaction. Since there are many scripting languages to choose from and DBMS to use with this project, PHP and MYSQL tandem is a great choice. Choosing this two software basically is being budget-wise. PHP and MYSQL are free for download. This two are commonly used and easy to incorporate in a system. It is compatible to any server operating systems and easy to manage. The task is to provide and e-ticketing facilities to the films showing in the cinemas. Clients can go online to the website and view list of films showing, and up-coming movies to show. They can also check schedules for viewing, booking and reservation online and see available seats in the theatres. Administrative feature is also designed to provide the administrator the control to insert schedules, modify, delete and monitor the reservations online. This allows a full control of the ticketing and will allow the company to save time and money doing inventory and updates. Set of Use Cases Use-case Text # 1: User Signup for new account STEP Actor Action System Response 1 The use case begins when the user clicks the signup for membership. - 2 - System prompts the user with a form that requires providing the following fields: first name, last name, address, contact, username, and password. 3 The user provides the details in the form in presented in step 2. 4 - System checks if all required fields is valid 5 - System adds new user to the database. 6 - System confirms the user that the sign-up was successful. Alternative courses of action for Use-case Text # 1: At step 4: Incomplete and not valid information submitted. System informs the user of invalid entry was made. System re-prompted the sign-up form with initial input. (Go back to step 2) Use-case Text # 2: User Search for Movies. STEP Actor Action System Response 1 The use case begins when user clicks ‘Movie Movie Listings’. - 2 - System queries the ‘Movies Table’ in the database for Movie Listings relevant fields. 3 - System displays the movie titles, details, and schedules in the database for showing. 4 User now can browse the movie titles available. - Use-case Text # 3: User Books/Reserves for Movie Tickets. STEP Actor Action System Response 1 The use case begins when user found movie(s) that interest him/her to watch. - 2 User checks the Book Me In! Or Reserve Space for Me! - 3 - System prompts the user to login. 4 - System prompts user a confirmation about the movie(s) he/she wishes to book or reserve. 5 User clicks ‘Confirm’ button - 6 - System verifies available tickets/seats and type of certificate in the database. 7 - System prompts user of his/her confirmation the booking/reservation and adds a new record to the ‘Bookings Table’. 8 - System displays a reservation/booking receipt. Alternative courses of action for Use-case Text # 3: At step 6: Movie booking and reservation is full. System informs the user of no available tickets or sold-out. System displays again the movie listings. (Go back to step 1) Use-case Text # 4: Administrator Add a Movie(s) in the database. STEP Actor Action System Response 1 The use case begins when administrator clicks ADD MOVIE to the database. - 2 - System prompts the administrator with add form that requires providing the following fields: film, day, hours, minutes, maxtickets certificate, synopsis, reviews 3 The administrator enters the details specified in step 2. - 4 - System checks if all required fields is valid 5 - System adds new movie to the database. 6 - System confirms the user that the adding of a movie was successful. Alternative courses of action for Use-case Text # 4: At step 4: Incomplete and not valid information submitted. System informs the user of invalid entry was made. System re-prompted the add movie form with initial input. (Go back to step 2) Use-case Text # 5: Administrator Modify a Movie(s) in the database. STEP Actor Action System Response 1 The use case begins when administrator clicks MODIFY MOVIE. - 2 - System queries the database of which movie is to be modified. 3 - System populates with movie details the movie modification form. 4 Administrator will do the necessary modification with the details. - 5 Administrator confirms the modification. - 6 - System confirms the administrator that the modification of a movie was successful. Use-case Text # 6: Administrator deletes a Movie(s) in the database. STEP Actor Action System Response 1 The use case begins when administrator clicks DELETE MOVIE. - 2 - System queries the database of which movie is to be deleted. 3 - System prompts the administrator about the deletion. 4 Administrator confirms the deletion. - 5 - System confirms the administrator that the deletion of a movie was successful. System Design Prototypes a.) Customers Page Map b.) Administrators Page Map c.) Registration and Login Form d.) Administrators Form Database Schemas [Users Table] ID INT PRIMARY KEY isadmin TINYINT fname VARCHAR(25) lname VARCHAR(255) address VARCHAR(60) contact VARCHAR(60) username VARCHAR(20) password VARCHAR (20) [Bookings Table] UserID INT ShowingID INT SeatID INT BookingID INT Date DATE IPAddress varchar(25) [Movies Table] ID INT PRIMARY KEY film VARCHAR(255) day VARCHAR(255) hours INT minutes INT maxtickets INT certificate VARCHAR(5) synopsis VARCHAR(250) reviews VARCHAR(250) Pseudocodes A. Registration Form Read user details from HTML form If user details valid Connect to database Send SQL INSERT query to add a new user to the users table Display successful message Close connection to database Otherwise Display invalid input error message Display HTML signup form again to allow re-entry of user details End if B. User Search Movies Connect to database Send SQL SELECT query to the movies table Display HTML format of movie listings Close connection to database C. User Books/Reserves for Movie Tickets If the user is logged in Read movie ID from data post If movie ID exists Connect to database Send SQL SELECT query to the movies table and check the maxtickets Send SQL SELECT query to the bookings table and count the total booking for the movie ID If total bookings is greater than or equals to maxtickets Display error message, informing the user that there is no available tickets. Otherwise Allow booking Send SQL INSERT query to the bookings table Display successful message End If Close connection to database Otherwise Display invalid movie ID error message Display movie listings again End if Otherwise Inform the user that theyre not logged in and tell advice them to login first End if D. Administrator Add a Movie(s) in the database If the admin is logged in Read movie details from HTML add movie form If movie details valid Connect to database Send SQL INSERT query to add a new movie to the movies table Display successful message Close connection to database Otherwise Display invalid input error message Display HTML add movie form again to allow re-entry of movie details End Otherwise Inform the admin that he is not logged in and advice to login first End if E. Administrator modifies a Movie(s) in the database. If the admin is logged in Read movie ID If movie ID valid Connect to database Send SQL SELECT query to the movies table Display the movie details in the HTML modify movie form If movie details modified Send SQL MODIFY query to the movies table Display successful message End if Close connection to database Otherwise Display invalid movie ID error message Display HTML movie listing to allow administrator select End Otherwise Inform the admin that he is not logged in and advice to login first End if F. Administrator deletes a Movie(s) in the database If the admin is logged in Read movie ID If movie ID valid Connect to database Send SQL DELETE query to the movies table Display successful message Close connection to database Otherwise Display invalid movie ID error message Display HTML movie listing to allow administrator select End Otherwise Inform the admin that he is not logged in and advice to login first End if Read More

Set of Use Cases Use-case Text # 1: User Signup for new account STEP Actor Action System Response 1 The use case begins when the user clicks the signup for membership. - 2 - System prompts the user with a form that requires providing the following fields: first name, last name, address, contact, username, and password. 3 The user provides the details in the form in presented in step 2. 4 - System checks if all required fields is valid 5 - System adds new user to the database. 6 - System confirms the user that the sign-up was successful.

Alternative courses of action for Use-case Text # 1: At step 4: Incomplete and not valid information submitted. System informs the user of invalid entry was made. System re-prompted the sign-up form with initial input. (Go back to step 2) Use-case Text # 2: User Search for Movies. STEP Actor Action System Response 1 The use case begins when user clicks ‘Movie Movie Listings’. - 2 - System queries the ‘Movies Table’ in the database for Movie Listings relevant fields. 3 - System displays the movie titles, details, and schedules in the database for showing.

4 User now can browse the movie titles available. - Use-case Text # 3: User Books/Reserves for Movie Tickets. STEP Actor Action System Response 1 The use case begins when user found movie(s) that interest him/her to watch. - 2 User checks the Book Me In! Or Reserve Space for Me! - 3 - System prompts the user to login. 4 - System prompts user a confirmation about the movie(s) he/she wishes to book or reserve. 5 User clicks ‘Confirm’ button - 6 - System verifies available tickets/seats and type of certificate in the database.

7 - System prompts user of his/her confirmation the booking/reservation and adds a new record to the ‘Bookings Table’. 8 - System displays a reservation/booking receipt. Alternative courses of action for Use-case Text # 3: At step 6: Movie booking and reservation is full. System informs the user of no available tickets or sold-out. System displays again the movie listings. (Go back to step 1) Use-case Text # 4: Administrator Add a Movie(s) in the database. STEP Actor Action System Response 1 The use case begins when administrator clicks ADD MOVIE to the database.

- 2 - System prompts the administrator with add form that requires providing the following fields: film, day, hours, minutes, maxtickets certificate, synopsis, reviews 3 The administrator enters the details specified in step 2. - 4 - System checks if all required fields is valid 5 - System adds new movie to the database. 6 - System confirms the user that the adding of a movie was successful. Alternative courses of action for Use-case Text # 4: At step 4: Incomplete and not valid information submitted.

System informs the user of invalid entry was made. System re-prompted the add movie form with initial input. (Go back to step 2) Use-case Text # 5: Administrator Modify a Movie(s) in the database. STEP Actor Action System Response 1 The use case begins when administrator clicks MODIFY MOVIE. - 2 - System queries the database of which movie is to be modified. 3 - System populates with movie details the movie modification form. 4 Administrator will do the necessary modification with the details.

- 5 Administrator confirms the modification. - 6 - System confirms the administrator that the modification of a movie was successful. Use-case Text # 6: Administrator deletes a Movie(s) in the database. STEP Actor Action System Response 1 The use case begins when administrator clicks DELETE MOVIE. - 2 - System queries the database of which movie is to be deleted. 3 - System prompts the administrator about the deletion. 4 Administrator confirms the deletion. - 5 - System confirms the administrator that the deletion of a movie was successful.

System Design Prototypes a.) Customers Page Map b.) Administrators Page Map c.) Registration and Login Form d.) Administrators Form Database Schemas [Users Table] ID INT PRIMARY KEY isadmin TINYINT fname VARCHAR(25) lname VARCHAR(255) address VARCHAR(60) contact VARCHAR(60) username VARCHAR(20) password VARCHAR (20) [Bookings Table] UserID INT ShowingID INT SeatID INT BookingID INT Date DATE IPAddress varchar(25) [Movies Table] ID INT PRIMARY KEY film VARCHAR(255) day VARCHAR(255) hours INT minutes INT maxtickets INT certificate VARCHAR(5) synopsis VARCHAR(250) reviews VARCHAR(250) Pseudocodes A.

Read More