Report on Systems Analysis and Information Systems: Event Management
VerifiedAdded on  2019/10/18
|19
|1321
|314
Report
AI Summary
This report presents the design and implementation of an event management system database. It begins with an introduction outlining the system's purpose: to manage information related to venues, artists, ticket bookings, and events. The report includes visual designs like context diagrams and DFD level 0 diagrams to illustrate the system's overview and data flow. The report also details the entities and attributes, followed by a normalization process to reduce redundancy and improve data integrity. An ER diagram and relational schema are provided to visualize the database structure. The implementation section covers table structures, relationships, SQL queries for ticket and event type queries, and report generation. The report also suggests several improvements, including security features, detailed customer and event information, and the use of cloud databases for backups. The conclusion emphasizes the importance of incorporating these improvements for future scalability and data mining. References used for completing the assignment are also provided.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
1 out of 19