HobbyistFieldTrips-StudentProject

One of my projects created for the "Databases" course assignment, completed during my studies.

Table of Contents

• Relations
• Getting Started
• Usage
• Repo Description
• Built Using
• Authors
• Acknowledgments

Relations between tables:

Project Description:

The project aims to create a database system for selling tours. The main technologies used will be MySQL for database management and PHP for implementing business logic. To improve the appearance and interactivity of the system, the Bootstrap library will also be used to create a responsive user interface.

System functionalities:

• Trip management: adding, deleting, and editing tours in the database.
• Trip reservations: users will be able to make reservations for selected tours.
• User management: registration, login, and management of user data.
• Administrative panel: accessible only to privileged users, allowing for the management of trips, reservations, and users.
• Displaying information about trips, such as description,trip date, trip operator, price, available slots, etc.
• Integration with payment system: option to make payments for trip reservations. There is also an option to cancel a purchased trip.
• Reporting system: showing which operators, trips, trip dates, etc. are most attractive to customers.
• Filtering of displayed trips.

Folder content:

SQL - The folder contains all the necessary values to create a database for the project. The files are compatible with MySQL.
project - In the folder, you can find files that contain a properly divided mechanism for booking trips. It also includes a folder with style files for the webpage (.css).

Built Using:

• VisualStudioCode - Development Environment
• MySQLWorkbench - Development Environment
• dbdiagram - Development Environment

Authors:

• @perskii - Initial work

Acknowledgements

• The-Documentation-Compendium - kylelobo