-
An online ticket booking system where users can signup and login/ logout of their account and purchase event tickets.
-
Users are able to view tickets available for purchase and store their tickets in a cart, remove or update quantities in their cart settings, search for events based on name, location, price, seating, and time and view their tickets after purchasing.
-
User data such as purchase and contact information are store inside a database avaialable for retrieval.
-
Database admins can view check the status of current users and other admins in the database.
- The Database contains 5 tables: billing, orders, ordersdetail, product, and users
- The billing table records customer's name, email, adress, city, state, zip, and credit card information
- The orders table records customer's purchase dates and email adress
- This table records order and product ID, price, quantity, and email
- This table contains the event tickets that are on sale. The columns are: image, event name, price, seating, date, location, and time
- This table records both customer and admin account information: username, password, email, ID, and user type
