Haven Database Project
Hello everyone. Today, we're presenting our CSY2093 Database Systems project based on
the Haven Retreat Accommodation Database.
The goal of this project was to implement part of the given ERD using Oracle SQL and
PL/SQL. We selected the retreat setting and accommodation section because it includes
parent tables, bridge tables, and different database features that we could implement.
Our final project is contained in a single script called CSY2093PJ1.sql, which creates the
database, inserts sample data, and includes functions, procedures, triggers, reports, testing,
and cleanup.
The five main tables are retreats, settings, accommodations, retreat_settings, and
retreat_accommodations. These tables store retreat details, settings, accommodation
options, and the relationships between them.