A university project focused on designing and implementing a robust relational database system. The project covers the entire development lifecycle, from entity-relationship mapping to advanced database automation using T-SQL (SQL Server) and PL/SQL (Oracle).
- Relational Schema Design: Well-structured database architecture with normalized tables and clear relationships.
- Advanced Logic: Implementation of stored procedures and functions to automate business processes.
- Data Integrity: Use of triggers and constraints to ensure data consistency and validity.
- Complex Querying: Advanced data retrieval techniques using joins, subqueries, and views.
- T-SQL: Server-side logic for Microsoft SQL Server environments.
- PL/SQL: Procedural language extensions for Oracle Database.
- RDBMS Concepts: Practical application of Relational Database Management System principles, normalization, and indexing.