The Vision: One Platform for Organisers, Vendors, and Customers

For my IFS242: Databases & Data Modelling module, I designed a Music Festival Management System that centralizes the operations of festival managers, vendors, and customers in a single, structured database.

The platform enables festival creation, ticket management, vendor applications, and performance scheduling. It earned a 90% for database implementation, and my module grade was 83% (A). To showcase real-world use, I extended the schema into a full Java application.

Technical Deep Dive: Database Architecture & Normalization

The schema follows strict 3NF principles, ensuring data consistency and relational integrity across multiple user roles and event workflows.

• Core entities such as tblCustomers and tblTickets ensure unique relationships between customers and their purchases.
• Foreign key constraints enforce referential integrity — preventing orphaned records in tblPerformances or tblStages.
• Management entities (tblVendors, tblArtists) are decoupled from event instances (tblFestivals) for scalability.

The Java Application: Data Flow & Functional Logic

The Java application demonstrates real-time CRUD operations linked to the Access database, proving relational integrity through live user interactions.

Customer Workflow

• Register / Log In: tblUsers, tblCustomers — user accounts with linked customer profiles.
• Browse Festivals: tblFestivals — view event details and ticket options.
• Purchase Ticket: tblTickets — triggers stock decrement and customer linkage.
• Check In: tblAttendees — QR code validation for entry.
• Request Refund: tblRefunds — workflow approval with integrity checks.

Vendor Workflow

• Register / Log In: tblUsers, tblVendors — register vendor accounts.
• Apply for Festival: tblVendorApplications — submissions with PENDING → APPROVED states.
• Track Status: updates visible within vendor dashboards.

Staff Workflow

• Role Access Control: tblStaff — staff roles and permissions define system capabilities.
• Manage Artists / Performances: tblArtists, tblPerformances, tblStages.
• Approve Vendors & Refunds: tblVendorApplications, tblRefunds.
• Generate Reports: combined queries across tblTickets, tblFestivals, and tblSponsorships.