University Database

This project implements a comprehensive relational database system for a university. It includes full database schema design, business rule enforcement through constraints and triggers, and SQL queries to derive insights like student GPA and academic level.

Objectives Design a normalized relational database model that reflects core university operations.

Implement business rules using constraints and triggers.

Populate the database with sample data.

Derive meaningful metrics such as student GPA and academic levels using SQL.

Key Features Relational database schema with tables for Students, Professors, Courses, Departments, Registrations, etc.

Triggers to ensure business logic like credit hour thresholds and automatic credit hour updates.

Derived fields such as academic level and GPA computed using SQL queries.

Constraints for data integrity including unique values, check conditions, and foreign keys