CREATE TABLE Event $($

EventID INT NOT NULL,

ClientID INT NOT NULL,

Username VARCHAR NOT NULL,

EventName VARCHAR NOT NULL,

EventDate DATE NOT NULL,

EventDescriotion VARCHAR NOT NULL,

PRIMARY KEY $($EventID$,$ ClientID, Username$)$

;

CREATE TABLE Catering $($

CateringID INT NOT NULL,

EventID INT NOT NULL,

ClientID INT NOT NULL,

Username VARCHAR NOT NULL,

CateringType VARCHAR NOT NULL,

CateringDescription VARCHAR NOT NULL,

PRIMARY KEY $($CateringID$,$ EventID, ClientID, Username$)$

;

CREATE TABLE MenuItem $($

MenuItemID$\_$ VARCHAR NOT NULL,

CateringID INT NOT NULL,

EventID INT NOT NULL,

rlientTn I only want this part: "Client"

$-$ Login

$-$Registration

$-$Profile Page $($ includes log out $)$

$-$Dashboard $-$ Client

note: In the dashboard, the client name and the royalty points should be shown

And if the client isn't logged in$,$ you must hide$$the$$other$$tabs

DESCRIPTION

Online Event Management System Requirements.

Introduction of the Company:

This project is a case study about Orient Event Organizer Ltd $($OEO$),$ the company that provides

organization of events and management of services that their clients may need for those events.

It is a small$-$scale business which found its place on the market by organizing events and providing

services for those events since $2010.$ The type of events handled by the company includes

workshops, trainings, and seminars. The events are organized in the company$$s premises which

include a fully equipped seminar hall of a capacity of $80$ audiences, three small halls with the

capacity of $30$ audiences and one fully equipped lab with $40$ desktop computers. They have

different departments in the company like Sales Department, Technical Department, Facilities and

Human Resource. Currently, all the details about the events and services are recorded in

spreadsheets. To handle the growth of the company, the company needs a web$-$based solution

for helping them to efficiently capture, store, process and retrieve data on clients, booking events,

venue selection, event schedules, resource tracking, task tracking and the services which include

rental of equipment needed for events, catering, and venue management. In addition to the

specified features, the company needs a web Portal to allow their clients to book their event

online$\mathrm{.}1.$ Functional Requirements

The brief list of requirements for a project is presented below. Students can extend the functionality

of the project based on their understanding and discuss further with their teacher for better

understanding.

$$ Client Portal for Booking an Event.

$$ Admin Portal for Administrative task like Manage data for Clients, Events, Halls, available

resources.

$1\mathrm{.}1$ Log In & Sign$-$Up: Potential Users of the Online Portal

The Online Portal will have $3$ types of users with different functionalities:

o Client

o Employees

o Administrator

o A login is not needed to search, view Hall details.

o Each user will have set of privileges which student can suggest based on reasonable judgment.

o To use the Online Portal all users, need to be Logged$-$In and Application will maintain the

User$$s information in a session.

Log In & Sign$-$Up feature

Make sure Your Sign$-$Up and Login pages must check to ensure $*$Data validation & Data

verification requirement. For example, data entry in mandatory fields, Password protection,

username does not already exist, field length & datatypes etc.

$*$Apply JavaScript to handle data validation. Must use encryption method for password.

$($Mandatory$).$

$1\mathrm{.}2$ Royalty Points

System Should be capable of give royalty points to all clients as $$Gold Client$,$Silver Client$,$

$$Bronze Client$$ based on their successful events$/$booking of events.

Discount Criteria for Royalty Points

No$.$ of Events $,$Client Status, Discount offered

More than $15$ booked events $||$ Golden Client $||$ Discount $20\%$

More than $10$ booked events $||$ Silver Client $||$ Discount $10\%$

More than $5$ booked events Bronze Client $||$ Discount $5\%$

$2.$ Non$-$Functional Requirements

$$ Navigation $$ the system should apply a consistent and logical means of navigating the

application.

$$ Pagination$-$ Apply the pagination for the pages wherever the listing could be more than $10.$

$$ Look and feel $-$ the application should have a professional look and feel and should be userfriendly. It should use appropriate windows controls such as drop$-$down lists, radio buttons

and so on wherever possible.

$$ Validation of input $$ it is important that data is validated before being added to the database

to ensure system integrity. Any invalid input should result in an appropriate error message

being displayed.

$$ Extra printing$-$ Script Error printing or extra printing in the output may lead to penalty.

Note: it is important that your database contains sufficient data to allow it to be tested thoroughly so

ensure that you have created an effective test set.

Using Net beans php and sql and javascript

Note that all the tables for this project should have the prefix $$dbProj$\_.$