Databases II

All

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…
mysql sql functions rollback databases accounts plsql transactions relational-databases commit
PLpgSQL
•0•0•0•0•Updated Jan 14, 2026Jan 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/UPDAT…
mysql automation sql databases update constraints trigger relational-databases academic-project delete
0•0•0•0•Updated Jan 13, 2026Jan 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 re…
mysql sql databases foreign-keys relational-databases academic-project personnel create-table aggregate-functions uniwa
0•0•0•0•Updated Jan 13, 2026Jan 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 o…
mysql views select sql databases constraints join relational-databases academic-project aggregation
0•0•0•0•Updated Jan 13, 2026Jan 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, d…
mysql sql databases constraints relational-databases academic-project auto-increment personnel primary-key foreign-key
0•0•0•0•Updated Jan 13, 2026Jan 13, 2026