This repository contains the structured SQL and PL/SQL implementations developed as part of the Database Management System (BCA37107) course at Brainware University (2024-25).
| Project | Description |
|---|---|
| Library Management | Relational schema for members, books, and issue tracking. Includes complex queries, string/numeric functions, and aggregate operations. |
| Books & Employee | Database design focused on PL/SQL business logic, including prime number checks, triggers for security, and iterative data updates. |
| Cricket Tournament | Statistics-heavy schema managing match outcomes, player profiles, and performance metrics (batting/bowling). |
/
├── Library-Management/
│ ├── LibraryManagementSystem.sql
│ ├── LibraryQueriesPartOne.sql
│ └── LibraryQueriesPartTwo.sql
├── Books-Employee-Management/
│ ├── BooksAndEmployeeManagement.sql
│ └── PL-SQL-Tasks/ (Task03 - Task09)
└── Cricket-Tournament/
└── CricketTournament.sql