This project consists of the complete PostgreSQL Database structure for a Library Management System. It was developed as an academic assignment to demonstrate mastery of data modeling, transactional logic, and security configuration in a database environment.
-
Schema (DDL): Creation of all tables, indexes, and keys.
-
Business Logic: Stored Procedures (sp_register_loan, sp_register_return) and Functions (inventory and revenue calculation).
-
Security: Configuration of ACLs and Permissions for user profiles (teacher, students).
-
Initial Data (DML): Seeding data for immediate system testing.
| Categoria | Tecnologia | Detalhe |
|---|---|---|
| SGBD | PostgreSQL | SGBD robusto para suporte a lógica procedural PL/pgSQL. |
| Linguagem | PlpgSQL | Utilizada para desenvolver Procedures, Functions e Triggers. |