A comprehensive relational database system designed for managing music festivals and events, developed as part of my Database course at University of Bucharest.
This database system manages all aspects of music festival organization including:
- Events & Venues: Festival scheduling and location management
- Artists & Performances: Artist assignments to stages and song catalogs
- Ticket Sales: Participant registration and service tiers
- Staff Management: Organizers, managers, and sponsors with role hierarchies
- Equipment Tracking: Technical equipment allocation per stage
- 16 interconnected tables with complex relationships
- Inheritance hierarchy: Staff → Organizer/Manager/Sponsor
- Normalized to 3NF to eliminate data redundancy
- Advanced constraints ensuring data integrity
EVENIMENT- Festival events and schedulingARTIST- Performer information and stage assignmentsPARTICIPANT- Attendee registration and demographicsBILET- Ticket sales and service tiersSTAFF- Personnel management with specialized rolesSCENA- Stage management and capacity planningECHIPAMENT- Technical equipment tracking
- Oracle Database with PL/SQL procedures
- Complex SQL queries with subqueries and joins
- Data aggregation and analytical functions
- Transaction management with rollback capabilities
- Sequence generators for primary key management
- Synchronized and unsynchronized subqueries
- Window functions and data grouping
- Complex joins across multiple tables
- Conditional logic with CASE statements
- String and date manipulation functions
- 16 normalized tables with referential integrity
- 200+ records across all entities
- 5+ complex analytical queries
- 3+ update/delete operations with subqueries
- Full CRUD operations implemented
- Database Setup
-- Run scripts in order: @sql/01-create-sequences.sql @sql/02-create-tables.sql @sql/03-insert-data.sql