Data-Bases-2
Popular repositories Loading
-
Create-Database
Create-Database PublicSQL 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…
-
Vars-Functions-Procedures
Vars-Functions-Procedures PublicSQL 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
-
Views
Views PublicSQL 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, …
-
Trigger
Trigger PublicSQL 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…
-
Constraints
Constraints PublicSQL 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
- 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 - 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 - 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 - 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 - 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
Top languages
Loading…
Most used topics
Loading…