Question

$[100$ marks$]$

Overview:

The Event Management System $($EMS$)$ is a Java GUI application created to simplify the organisation and management of events. It offers features for planning events, registering attendees, managing venues, and coordinating vendors. The system is linked to a MySQL database for storing event$-$related data.

Requirements:

Interface for Event planning:

The interface must be able to create, edit, and delete events.

There must be fields for event name, date, time, description, and organiser details.

There must be validation to ensure the uniqueness of event names and proper date and time formatting.

Interface for attendee registration:

Registration form for attendees to sign up for events.

Fields for attendee name, email, contact number, and event selection.

Validation to prevent duplicate registrations and ensure valid email and phone number formats.

Interface for Venue management:

Functionality to add, edit, and delete venues.

Fields for venue name, address, capacity, and availability.

Database:

There must be integration with MySQL database to store event details, attendee information, and venue bookings.

Functionality$-$CRUD

Interface for Event planning: The project must be able to Create, Read, Update, and Delete events.

Interface for attendee registration: The project must be able to view registered attendees, update attendee information, and remove attendees.

$\backslash$table$[[$Criteria$,$Task,Marks$],[$Database Integration,$\backslash$table$[[$Proper setup and configuration of MySQL database. $(20$ marks$)],[$Effective utilisation of SQL queries for data retrieval, insertion, updating, and deletion. $(25$ marks$)]],45$ marks$],[$Functionality$,\backslash$table$[[$Completeness and correctness of event planning, attendee registration, and venue management functionalities. $(20$ marks$)],[$Implementation of CRUD operations for event schedules and attendee lists. $(10$ marks$)],[$Error handling and validation mechanisms to ensure data integrity. $(5$ marks$)]],35$ marks$],[$User Interface,$\backslash$table$[[$Intuitive design and layout of GUI interfaces.$],[(3$ marks$)],[$Consistency in styling and navigation across different screens. $(3$ marks$)],[$Use of appropriate controls and components for data input and presentation. $(4$ marks$)]],10$ marks$],[$Documentation$,\backslash$table$[[$Clear and comprehensive documentation covering the project overview explains how the project works. $(10$ marks$)],[$PLEASE DOCUMENT WHAT IS WORKING$]],10$ marks$]]$