SQL laboratory project for demonstrating the creation and management of views in a personnel database. Includes DEPT, JOB, and EMP tables, along with examples of single-table, multi-table, nested, and filtered views, and their interaction with base tables (Databases II, UNIWA).

SQL and PL/SQL laboratory project for demonstrating the use of variables, functions, stored procedures, and transaction management across personnel and accounts databases (Databases II, UNIWA).

SQL laboratory project for demonstrating the creation and management of triggers in a personnel database. Includes examples of BEFORE UPDATE, AFTER INSERT/UPDATE/DELETE triggers to automate data validation, enforce business rules, and maintain consistency (Databases II, UNIWA).

SQL laboratory project for demonstrating creation and management of a personnel database with DEPT, JOB, and EMP tables. Includes table creation, foreign key relationships, sample data insertion, and aggregate / analytical queries (Databases II, UNIWA).

SQL laboratory project for demonstrating creation and management of a personnel database with DEPT, JOB, and EMP tables, including primary keys, foreign keys, default values, auto-increment, and constraint enforcement (Databases II, UNIWA).