University Registration & Academic Tracking Database

Executive Summary: A comprehensive relational database system designed to manage university student registrations, academic tracking, and graduation goal evaluations. Built to demonstrate production-grade database architecture, rigorous normalization, and complex analytical querying.

💻 Tech Stack & Tooling

• Languages: SQL (T-SQL / MySQL / PL/SQL compatible)
• Concepts: Entity-Relationship (E-R) Modeling, Relational Algebra, Database Constraints
• Documentation: Markdown, Conceptual & Logical Database Design Mapping

🧠 Computer Science Concepts & Architecture

This repository applies advanced database design principles to ensure data integrity and query efficiency:

• Rigorous Normalization: The schema was aggressively normalized through 1NF, 2NF, 3NF, and evaluated against Boyce-Codd Normal Form (BCNF) to eliminate insertion, deletion, and modification anomalies.
• Referential & Entity Integrity: Enforces strict domain, key, and referential constraints across 10 distinct entities (including Students, Departments, Courses, and Transcripts) to prevent orphan records and ensure data validity.
• Complex Relational Mapping: Successfully resolves many-to-many relationships (e.g., Transcripts and Courses) utilizing associative/junction tables while maintaining strict foreign key dependencies.
• Advanced Query Optimization: Leverages subqueries, multi-table JOIN operations, and aggregate functions (GROUP BY, HAVING) to perform complex business logic, such as determining if a student has satisfied all mandatory graduation goals.

✨ Key Features & Technical Achievements

• Academic Progress Engine: Engineered analytical queries capable of calculating accumulated credits and evaluating complex graduation conditions across multiple academic departments.
• Robust Schema Design: Designed robust schemas supporting diverse attribute types, including multi-valued attributes mapped to weak entities (e.g., dynamic Phone and Email tables linked to a central Student ID).
• Scalable Architecture: Structured the database to easily accommodate future expansion via Stored Procedures and Triggers for automated academic status updates.

🚀 Getting Started

Prerequisites

Ensure you have a SQL Database Engine installed (e.g., MySQL Server, Microsoft SQL Server, or PostgreSQL).

Installation & Configuration

1. Clone the repository:

   git clone https://github.com/ClxpI/Database-UniversityRegistrationSystem.git
   cd Database-UniversityRegistrationSystem

2. Run the SQL scripts against your engine of choice, in order:

   src/01_schema.sql
   src/02_seed_data.sql
   src/03_analytical_queries.sql