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.

Event Management System Database Design

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

ER diagram of Event management System

Event Management System Database Design

DOWNLOAD DATABASE DESIGN

🔥185 Views

Leave a Reply

Do you have anything to Ask?

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  Subscribe  
Notify of