SPACEPERFORMANCE venue management database

The first of two real, separate submissions in the Advanced Databases module: conceptual and logical modeling for a music and theatre venue booking system called SPACEPERFORMANCE, entirely in Oracle. I modeled the domain, then implemented it two ways on the same data, once as a plain relational schema and once as an object-relational model with custom types and nested tables, specifically to compare the two approaches on the same real domain rather than in the abstract.

One design problem forced a workaround worth remembering: Oracle doesn't allow subqueries inside a CHECK constraint, so a ticket-booking age-verification rule that needed to look up another table had to become a database trigger instead.

The last piece was hands-on, not theoretical: a distributed-database fragmentation demo, both horizontal and vertical, splitting employee data across three simulated Oracle databases by location.