Skip to content

Latest commit

 

History

History
14 lines (11 loc) · 1 KB

File metadata and controls

14 lines (11 loc) · 1 KB

Database Management System (T-SQL & PL-SQL) 🗄️

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).

Features

  • 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.

Technologies Used

  • 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.