This repository contains the project that I developed for my CSE311 course on Database Systems. The project involves designing a comprehensive database, implementing it with MySQL, and creating a user-friendly front end using HTML, CSS and PHP.
The initial phase of the project was focused on designing the database. A detailed Entity-Relationship (ER) diagram was designed outlining the entities, relationship types, and schemas.
- Admin Panel Operations:
- Add Customer Profiles
- Add Bus Routes
- Book Tickets
- Set up a local server environment using
XAMPP
or a similar tool. - Import the SQL script to create database.
- Ensure that PHP is configured to run on your server.
- Open the project in a web browser.
As the project was primarily centered around database design, please note that the website is not complete and fully functional. The implemented features are restricted to the operations accessible from the admin-panel
, allowing you to test and observe changes made to the database.