Event Management System Database Design

Here we shared Event Management System Database Design. The database is a collection of inter-related data. Relational database stores data in table or relations. The data stored in relation are arranged in tuples or records. Each record contains set of attributes or fields. The database description describes the entire database used in the application to store all records.

Login Table: This table stores Username and password as admin’s login form.

Field Name	Data Type	Constraint	Description
Emailaddress	Varchar(20)	Not Null	Username for login procedure.
Password	Varchar(20)	Not Null	Password for login procedure.

Expenditure Table: This table stores expenditure information about the catering service.

Field Name	Data Type	Constraint	Description
Date	date	Not Null	Date on which the expenditure is entered
Type	Varchar(20)	Not Null	Type of the expenditure
Amount	Money	Not Null	Amount of the expenditure

Registration Table: This table stores Registration Details of Customers

Field Name	Data Type	Constraint	Description
User_Id	Varchar	Primary Key	Unique Id generated for every customer
Password	varchar	Not Null	Password for registration process
R_password	Varchar	Not Null	Repeat password
Fname	varchar	Not Null	First Name
Lname	varchar	Not Null	Last Name
Address	varchar	Not Null	Address of customer
DOB	date	Not Null	Date of Birth
City	varchar	Not Null	City of residence
State	Varchar	Not Null	State
Mobile_no	Varchar	Not Null	Mobile No.
Contact_no	Varchar	Not Null	Contact no.
Email_Id	Varchar	Not Null	Email address

Supplier Payments Table: This table stores information about Supplier payments.

Field Name	Data Type	Constraint	Description
Date	Varchar	Not Null	Unique Id for Department.
SupplierName	varchar	Not Null	Department Name.
Amount	Money	Not Null

Event Table: This table stores information about Courses offered in the college.

Field Name	Data Type	Constraint	Description
Event_code	Number	Primarykey	Unique Id for Event
Event_type	Varchar(20)	Not Null	Type of Event

Order Table: This table stores information of all the orders.

Field Name	Data Type	Constraint	Description
Order_no	Number	Primary key	Unique Id for Order
Email_addr	Varchar	Not Null	Email address
Event_code	Varchar	Not Null	Unique Id for particular event.
Approx . no	Number	Not Null	Number of order.
Category	varchar	Not Null	Category

Bill Table: This table stores the bills.

Field Name	Data Type	Constraint	Description
Bill_no	Number	Primary key	Unique Id for bills
Order_no	Number	Foreign key	Order number
Email_addr	Varchar	Not Null	Email Address.
Amount	varchar	Not Null	Total amount
Tax	varchar	Not Null	Tax
Deliver_charge	varchar	Not Null	Delivery charges
Final_amt	varchar	Not Null	The final amount to be paid
Bill_date	date	Not null	Date on which the bill is issued

Receipts Table: This table stores information about the receipts.

Field Name	Data Type	Constraint	Description
Receipt_No	Numeric	Primary Key	Receipt No
Bill_No	Numeric	Foreign key	Bill number
Tot_amt	Money	Not Null	Total amount
Paid_amt	Numeric	Not Null	Amount paid
Balance	Numeric	Not Null	Balance amount
Rdate	date	Not Null	Receipt Date

Feedback Table: This table stores information about customer Feedback

Field Name	Data Type	Constraint	Description
Email_id	Varchar	Not Null	Email id of any user
Subject	Varchar	Not null	Subject
Message	Varchar	Not Null	Message