Authentication and Authorization

Movie Web Application Requirements Document Web App Class Homework 6-7 Updated 1/5/2019 Objective You are hired as an intern with Cinemark, a movie theatre chain in USA. You assignment is to build a web application listing movie information for Cinemark’s customers. Cinemark intends to use this website to market movie information to its moviegoers. Future additions include the use case to buy tickets. This website has two types of users (or roles): customer and admin. Use cases This website should have the following use cases:

Use case Page Name Role(s) Description 1 Login Movie-login Customer

Admin 1. User login to the app. 2. Upon login, user is forwarded to Movie-

list page.

2 View list of movies Movie-list Customer Admin

1. User views list of movies (show movie image and movie name).

2. Each movie has a link to Movie-details page. The link can be on the image or movie name.

3. Display a link on top of the page to Movie-add page.

3 View details of one movie Movie-details Customer Admin

1. User view details of one movie. Show movie image.

2. Show movie trailer from YouTube. 3. Display a link to Movie-update page. 4. Display a link to Movie-delete page.

4 Add data for a new movie Movie-add Admin 1. User adds data for a new movie. 2. Upon submission, user is forwarded to

Movie-list page. 5 Update data for one movie Movie-update Admin 1. User updates data for one movie.

2. Upon submission, user is forwarded to Movie-list page.

6 Delete a movie Movie-delete Admin 1. User deletes one movie. 2. This is a PHP page no HTML display is

needed.

Database Information Entity Relationship Diagram (ERD)

Movie table data structure Attribute Data Type Size Auto NULL Constraint

id int 11 YES NO Primary title varchar 100 NO description varchar 500 YES director varchar 100 YES release_year varchar 50 YES budget varchar 50 YES runtime varchar 50 YES rating varchar 50 YES genre varchar 50 YES trailer_link varchar 200 YES

User table data structure Attribute Data Type Size Auto NULL Constraint

id int 11 YES NO Primary username varchar 50 NO password varchar 50 NO first_name varchar 50 YES last_name varchar 50 YES email varchar 100 YES card_number varchar 50 YES expiration_date varchar 20 YES

Role table data structure Attribute Data Type Size Auto NULL Constraint

id int 11 YES NO Primary username varchar 50 NO role varchar 20 NO

Ticket table data structure Attribute Data Type Size Auto NULL Constraint

id int 11 YES NO Primary movie_id int 11 NO user_id int 11 NO ticket_quantity int 11 NO ticket_amount float YES purchase_date varchar 20 YES

Web Application Site Map