Designed a relational database schema with PL/SQL stored procedures, triggers, and sequences. Connected Oracle backend to a Microsoft Access frontend via ODBC for full CRUD operations.
Overview
Academic project for CST2355 (Database Systems). Implemented a movie database in Oracle with schema design, stored procedures, triggers, and ODBC link to MS Access.
Approach
Created normalized schema, wrote PL/SQL procedures for common operations, defined triggers for constraints, and configured ODBC DSN for Access frontend integration.
Results
Fully functional Oracle–Access integration with forms for data entry and querying. Demonstrated end-to-end database application development.
Tools
Oracle SQLPL/SQLMS AccessODBC