How tamoziit/dbms_lab works
DBMS_Lab is a collection of SQL and PL/SQL lab examples, not a connected application with a documented runtime workflow. The README identifies the subject broadly as RDBMS and SQL; the file names indicate topics such as schemas, constraints, queries, functions, and triggers. Source excerpts are unavailable, so relationships between scripts and their execution behavior cannot be verified. The map groups the examples by apparent topic without asserting that one script invokes or feeds another.
Components 29
Schemas and Constraints
- Students
day0/Students.sql - Employee
day1/Employee.sql - Employee Constraints
day2/Employee_Constraints1.sql - Employee Department
day2/Employee_Department.sql - Self Reference
day2/Self_Referencial_Foreing_Key.sql - Day Two SQL
day2/day2_Rem.sql - D4a SQL
day3/D4a.sql - D4b SQL
day3/D4b.sql - Employee Constraints Two
day3/Employees_Constraint_2.sql - Person Orders
day3/Person_Orders.sql
SQL Queries
- Nested Queries
day5/Nested_Queries.sql - Joins
day5/join.sql - Having Clause
day6/Having_clause.sql
PL/SQL Examples
- Accounts
PL_SQL/accounts.sql - Area
PL_SQL/area.sql - Factorial
PL_SQL/factorial.sql - PL/SQL Examples
PL_SQL/plsql.sql - Functions
day4/Functions.sql
Practice Examples
- Audit Trigger
practice/audit_trigger.sql - Delete Trigger
practice/delete_trigger.sql - Practice D1
practice/d1.sql - Practice D2
practice/d2.sql - Practice D3
practice/d3.sql - Practice D4
practice/d4.sql - Practice D5
practice/d5.sql - Practice D6
practice/d6.sql - Practice D7
practice/d7.sql - Practice PL/SQL
practice/plsql.sql - Records
practice/records.sql