Event Management Database
This project is tailor-made for event managers, offering a comprehensive solution to streamline their work. Our database empowers event managers to efficiently record and generate reports for their events while simplifying the management of essential services. Key features of this project include dedicated sections for Events, Reports, and Vendors, ensuring a user-friendly approach to handle all aspects of event management.
Database Purpose
Business Rules
Entities
Workflow
Entity Relationship Diagram
SQL DDL Statements
Generating Views for Reporting
View 1 : Customers with Pending payments
Purpose: To identify customers with pending payments
View 2 : Top 5 Customers
Purpose: To identify top 5 customers with highest sales
View 3 : Sales by Customer
Purpose: To report sales by each customer
Tableau Visualization
Customers with Pending payments with Amounts
Top 5 Customers
Most popular packages and their Sales
Sales Revenue by Year
Table level Check constraints using Function
To prohibit the customers from entering incorrect Email IDs
Column data encryption on Password
Computed column based Functions
1. Function to calculate Annual salary of Employees
2. Function to calculate Age of Customers
3. Function to calculate number of bookings per Customer
Use of Trigger to Update Customer status
Conclusion
•We successfully implemented event management system database using triggers, functions, views and performed data analysis using a data mining tool Tableau.
​
• The database is not limited to create only one report but different reports representing different data that is needed for different situations which will be crucial in data analysis for quality control and improvement.
Scope for future improvements
Allow customization of services to the customers
Send automated reminders to customers
Automation of database
Planning to use Indexing technique to improve performance of database