DBMS Mini Project

Description

This is an event management database used by a college to conduct various competitions in an event.

Table of Contents

• Software Used
• Languages
• Installation
• Pages Overview
  • Home Page
• Screenshots
• Contributing
• License
• Contact

Software Used

• VS Code
• XAMPP Server

Languages

• PHP
• HTML
• CSS
• JavaScript

Installation

Prerequisites

• XAMPP installed on your machine.
• A web browser.

Steps

1. Clone the Repository

   git clone https://github.com/kottarivaibhav/dbms_mini_project.git

2. Move to the Project Directory cd dbms_mini_project

3. Copy the Project Files to XAMPP's htdocs Directory cp -r * /path/to/xampp/htdocs/dbms_mini_project

   Replace /path/to/xampp/htdocs with the actual path to your XAMPP htdocs directory.

   Start XAMPP

4. Open XAMPP Control Panel. Start the Apache and MySQL modules. Import the Database

5. Open your web browser and go to

   http://localhost/phpmyadmin.

   Create a new database named event_management. Import the SQL file located in the project directory (event_management.sql).

6. Access the Project Open your web browser and go to http://localhost/dbms_mini_project.

Pages Overview

So I will just explain in brief about the various pages that u will come across in our website

HOME PAGE:
• It has 3 headers options home, event and admin login.
• As you drag down you get event database.
• In the event database the participants get option for choosing the event of their choice.
This is a predefined database. When a participant enter their choice of event, the values will then be partially stored in the database. It will be stored permanently only when the participant completes the registration process.
• Below that is a small section which gives information about the college.







REGISTRATION PAGE:
• Registration page is the page that you will be directed as soon as you press any of the event of your choice.
• Here you have to fill all your details like – name, phone number, branch , college and email.
• After you fill, you have to press submit for the registration process to get completed.
• Once the registration is done, your data will be stored in the database.
• After that you will be re-directed to the homepage.





ADMIN-PAGE:
• Here all the person who are incharge of the event will be made admin and will be given with a personal username and password.
• Once they enter the user name and password they will enter into the CRUD page which basically is a page to perform the CRUD operation (Create Read Update Delete).

CRUD PAGE:
• This is the page which shows up once the admin login.
• In this page the admin can alter the participants details like :
• Read: For some reason if the admin wants to get the list of participants in a particular event he can access it using the search bar option.
• Update: If a participant wants to update his existing details like name, phone-number, email etc , he can request the admin to do the changes.
• Delete: If a admin wants to remove a participant due to some reason he can do this by removing the participant id from the delete option provided.
• Create: If there is vacant place for a participant to join but the registration portal has been closed . In such case the admin can make add a participant from the create option provided .
• All these changes is possible in the crud page.

ER diagram :


Schema Diagram :

Contributing

If you would like to contribute to this project, please fork the repository and submit a pull request.

Contact

For further communication , feel free to communicate with me - Vaibhav's Mail