Event Management System

Overview

This is a very simple DBMS project. It is actually an standalone(portable) application. Theme of application is Event Management(college events). This project can be very helpful to those who just started with these technologies. ER diagram is given here.

Technologies

• Frontend : Java AWT, Swing
• Backend : Java11
• Database : MySQL
• Database Connector : JDBC

Dependencies

• Java SE 11.
• MySQL database
• JDBC

Local setup

1. install all the dependecies above(install JDK11 or later).
2. make a mysql user named superadmin and set password Super@1999.
3. To make databases and tables see the source code from line 259. Here Department are databses and Event are tables.
4. Every table will contain follwing entities:

• Name (VARCHAR)
• Department (VARCHAR)
• Semester (VARCHAR)
• Contact_No (INT)
• Gmail (VARCHAR)

5. download EMS.jar
6. open command prompt or terminal go to the directory where jar file is downloaded.
7. After setting up everything,run java -jar EMS.jar.

Screenshots

Home page

superadmin login page

registration page

registered student list page

registration confirmation page

Entity Relationship Diagram