This repository is a comprehensive collection of database schemas, procedural logic, and business automation rules developed in PL/SQL. It covers multiple financial domains, showcasing robust backend engineering and data integrity practices.
- Domain: Insurance / Claims Processing
- Key Features: Automated deductible (franquia) calculations, indemnity limits, and claim validation.
- Status: ✅ Completed
- Domain: Retail Banking
- Target Logic: Interest rate calculations, transaction auditing, and balance integrity checks.
- Domain: Corporate Finance
- Target Logic: Tax automation and end-of-period reporting procedures.
Each project within this repository follows a standardized modular architecture:
/schema: Table definitions, constraints, and indexes./data: Seed scripts and mock data for testing./functions: Computational logic and reusable formulas./procedures: Complex business processes and workflow automation./triggers: Auditing, logging, and data consistency rules./tests: Systematic validation suites (Setup, Execution, Reversion).
To deploy any project from this collection, follow this execution order:
- Database Schema:
Run
[Project-Folder]/schema/createTables.sqlto build the structure. - Seed Data:
Run
[Project-Folder]/data/insertData.sqlto populate test records. - Core Logic:
Run
[Project-Folder]/functions/all_functions.sqlthen[Project-Folder]/procedures/all_procedures.sql. - Validation:
Execute the validation suite in order:
tests/creation.sql: Prepares the test environment.tests/execution-tests.sql: Runs business logic tests.tests/reversion.sql: Cleans up (Rollback/Cleanup).
- Database: Oracle Database (Compatible with 12c, 19c, 21c, 23ai)
- Tooling: Tested on FreeSQL.com and Oracle SQL Developer.
- Standard: ANSI SQL & PL/SQL.