Skip to content
@Data-Bases-2

Databases II

The course teaches students to design, implement, and manage complex database systems using modern DBMS tools and apply theory to real-world applications.

Popular repositories Loading

  1. Create-Database Create-Database Public

    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, a…

  2. Vars-Functions-Procedures Vars-Functions-Procedures Public

    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).

    PLpgSQL

  3. Views Views Public

    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, …

  4. Trigger Trigger Public

    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 va…

  5. Constraints Constraints Public

    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 co…

Repositories

Showing 5 of 5 repositories
  • Vars-Functions-Procedures Public

    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).

    Data-Bases-2/Vars-Functions-Procedures’s past year of commit activity
    PLpgSQL 0 0 0 0 Updated Jan 14, 2026
  • Trigger Public

    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).

    Data-Bases-2/Trigger’s past year of commit activity
    0 0 0 0 Updated Jan 13, 2026
  • Create-Database Public

    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).

    Data-Bases-2/Create-Database’s past year of commit activity
    0 0 0 0 Updated Jan 13, 2026
  • Views Public

    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).

    Data-Bases-2/Views’s past year of commit activity
    0 0 0 0 Updated Jan 13, 2026
  • Constraints Public

    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).

    Data-Bases-2/Constraints’s past year of commit activity
    0 0 0 0 Updated Jan 13, 2026

Top languages

Loading…

Most used topics

Loading…