Below is the comprehensive report for the Online Event Management System, including the ER diagram and details of the database tables. I will format this into a PDF afterward.

$---$

# Online Event Management System

## Team Members

$1.$ John Smith

$2.$ Emily Johnson

$3.$ Michael Brown

## Introduction

The Online Event Management System is designed to facilitate the creation, management, and registration of events. The system enables event organizers to manage events efficiently, allows attendees to register and purchase tickets, and provides administrators with the tools to oversee the entire process and generate detailed reports.

## Functionality Specification

### User Authentication

$-$ Users can create accounts, log in$,$ and manage their profiles.

$-$ Different roles include administrators, event organizers, and attendees.

### Event Creation

$-$ Event organizers can create new events, specifying details such as date, time, location, and ticket types.

### Attendee Registration

$-$ Users can register for events, choose ticket types, and make payments if required.

### Ticketing System

$-$ Generates and manages tickets for registered attendees, including QR code generation for event check$-$in$.$

### Event Schedule

$-$ Displays the schedule of events, including session timings and activities.

### Reporting

$-$ Provides insights and analytics on event attendance, ticket sales, and revenue.

### Admin Dashboard

$-$ Administrators can manage events, view registration details, and generate comprehensive reports.

## Database Design

### Tables and Their Attributes

#### Users

$|$ Column $|$ Data Type $|$ Constraints $|$

$|------------|--------------|------------------------------------|$

$|$ user$\_$id $|$ INT $|$ PRIMARY KEY, AUTO$\_$INCREMENT $|$

$|$ username $|$ VARCHAR$(50)|$ NOT NULL $|$

$|$ password $|$ VARCHAR$(255)|$ NOT NULL $|$

$|$ email $|$ VARCHAR$(100)|$ NOT NULL $|$

$|$ full$\_$name $|$ VARCHAR$(100)||$

$|$ role $|$ ENUM $|(\text{'}$admin$\text{'},$ 'organizer', 'attendee'$)|$

#### Events

$|$ Column $|$ Data Type $|$ Constraints $|$

$|--------------|-------------|------------------------------------|$

$|$ event$\_$id $|$ INT $|$ PRIMARY KEY, AUTO$\_$INCREMENT $|$

$|$ organizer$\_$id $|$ INT $|$ FOREIGN KEY $($Users$)|$

$|$ event$\_$name $|$ VARCHAR$(100)|$ NOT NULL $|$

$|$ event$\_$date $|$ DATE $|$ NOT NULL $|$

$|$ event$\_$time $|$ TIME $|$ NOT NULL $|$

$|$ location $|$ VARCHAR$(255)||$

$|$ description $|$ TEXT $||$

#### Tickets

$|$ Column $|$ Data Type $|$ Constraints $|$

$|------------|--------------|------------------------------------|$

$|$ ticket$\_$id $|$ INT $|$ PRIMARY KEY, AUTO$\_$INCREMENT $|$

$|$ event$\_$id $|$ INT $|$ FOREIGN KEY $($Events$)|$

$|$ ticket$\_$type$|$ VARCHAR$(50)||$

$|$ price $|$ DECIMAL$(10,2)||$

$|$ quantity $|$ INT $||$

#### Registrations

$|$ Column $|$ Data Type $|$ Constraints $|$

$|-------------------|-------------|------------------------------------|$

$|$ registration$\_$id $|$ INT $|$ PRIMARY KEY, AUTO$\_$INCREMENT $|$

$|$ event$\_$id $|$ INT $|$ FOREIGN KEY $($Events$)|$

$|$ user$\_$id $|$ INT $|$ FOREIGN KEY $($Users$)|$

$|$ ticket$\_$id $|$ INT $|$ FOREIGN KEY $($Tickets$)|$

$|$ registration$\_$date $|$ DATE $||$

$|$ payment$\_$status $|$ ENUM $|(\text{'}$Paid$\text{'},$ 'Pending', 'Cancelled'$)|$

#### Event$\_$Schedule

$|$ Column $|$ Data Type $|$ Constraints $|$

$|--------------|-------------|------------------------------------|$

$|$ schedule$\_$id $|$ INT $|$ PRIMARY KEY, AUTO$\_$INCREMENT $|$

$|$ event$\_$id $|$ INT $|$ FOREIGN KEY $($Events$)|$

$|$ activity$\_$name$|$ VARCHAR$(100)||$

$|$ start$\_$time $|$ TIME $||$

$|$ end$\_$time $|$ TIME $||$

$|$ description $|$ TEXT $||$

#### Reports

$|$ Column $|$ Data Type $|$ Constraints $|$

$|-----------------|-------------|------------------------------------|$

$|$ report$\_$id $|$ INT $|$ PRIMARY KEY, AUTO$\_$INCREMENT $|$

$|$ event$\_$id $|$ INT $|$ FOREIGN KEY $($Events$)|$

$|$ total$\_$attendance$|$ INT $||$

$|$ total$\_$revenue $|$ DECIMAL$(10,2)||$

$|$ report$\_$date $|$ DATE $||$

### ER Diagram

$```$mermaid

erDiagram

USERS $\{$

INT user$\_$id PRIMARY KEY

VARCHAR username

VARCHAR password

VARCHAR email

VARCHAR full$\_$name

ENUM role

$\}$

EVENTS $\{$

INT event$\_$id PRIMARY KEY

INT organizer$\_$id FOREIGN KEY

VARCHAR event$\_$name

DATE event$\_$date

TIME event$\_$time

VARCHAR location

TEXT description

$\}$

TICKETS $\{$

INT ticket$\_$id PRIMARY KEY

INT event$\_$id FOREIGN KEY

VARCHAR ticket$\_$type

DECIMAL price

INT quantity

$\}$

REGISTRATIONS $\{$

INT registration$\_$id PRIMARY KEY

INT event$\_$id FOREIGN KEY

INT user$\_$id FOREIGN KEY

INT ticket$\_$id FOREIGN KEY

DATE registration$\_$date

ENUM payment$\_$status

$\}$

EVENT$\_$SCHEDULE $\{$

INT schedule$\_$id PRIMARY KEY

INT event$\_$id FOREIGN KEY

VARCHAR activity$\_$name

TIME start$\_$time

TIME end$\_$time

TEXT description

$\}$

REPORTS $\{$

INT report$\_$id PRIMARY KEY

INT event$\_$id FOREIGN KEY

INT total$\_$attendance

DECIMAL total$\_$revenue

DATE report$\_$date

$\}$

USERS $||--$o$\{$ EVENTS: creates

EVENTS $||--$o$\{$ TICKETS: has

USERS $||--$o$\{$ REGISTRATIONS: registers

EVENTS $||--$o$\{$ REGISTRATIONS: contains

EVENTS $||--$o$\{$ EVENT$\_$SCHEDULE: schedules

EVENTS $||--$o$\{$ REPORTS: generates

$```$

## SQL Statements

### Create Table Statements

$```$sql

$--$ Create Users table

CREATE TABLE Users $($

user$\_$id INT PRIMARY KEY AUTO$\_$INCREMENT,

username VARCHAR$(50)$ NOT NULL,

password VARCHAR$(255)$ NOT NULL,

email VARCHAR$(100)$ NOT NULL,

full$\_$name VARCHAR$(100),$

role ENUM$(\text{'}$admin$\text{'},$ 'organizer', 'attendee'$)$ NOT NULL

$)$;

$--$ Create Events table

CREATE TABLE Events $($

event$\_$id INT PRIMARY KEY AUTO$\_$INCREMENT,

organizer$\_$id INT,

event$\_$name VARCHAR$(100)$ NOT NULL,

event$\_$date DATE NOT NULL,

event$\_$time TIME NOT NULL,

location VARCHAR$(255),$

description TEXT,

FOREIGN KEY $($organizer$\_$id$)$ REFERENCES Users$($user$\_$id$)$

$)$;

$--$ Create Tickets table

CREATE TABLE Tickets $($

ticket$\_$id INT PRIMARY KEY AUTO$\_$INCREMENT,

event$\_$id INT,

ticket$\_$type VARCHAR$(50),$

price DECIMAL$(10,2),$

quantity INT,

FOREIGN KEY $($event$\_$id$)$ REFERENCES Events$($event$\_$id$)$

$)$;

$--$ Create Registrations table

CREATE TABLE Registrations $($

registration$\_$id INT PRIMARY KEY AUTO$\_$INCREMENT,

event$\_$id INT,

user$\_$id INT,

ticket$\_$id INT,

registration$\_$date DATE,

payment$\_$status ENUM$(\text{'}$Paid$\text{'},$ 'Pending', 'Cancelled'$),$

FOREIGN KEY $($event$\_$id$)$ REFERENCES Events$($event$\_$id$),$

FOREIGN KEY