University Management System

The UVIC Management System is a C# console application linked to a MariaDB database, designed to manage students, professors, courses, and staff efficiently. It demonstrates SQL integration, data manipulation, and user-specific functionalities.

System Overview

The project consists of two main parts:

• A relational database built using MariaDB with multiple entities and relationships.
• A C# console application enabling users to interact with the database through a menu-driven interface.

Entity-Relationship Diagram (ERD)

Database Schema

The database includes entities for departments, students, courses, professors, staff, and classroom management. Relationships are defined via foreign keys to ensure data integrity. You can view or download the full schema:

Features

• Connects to MariaDB and retrieves server version.
• Adds and removes rows from any table dynamically.
• Lists table contents and related table data.
• Implements login for students, professors, and staff.
• Uses modular C# classes for database connection and logic separation.

Implementation Details

The C# console application interacts with the database using SQL queries. Users can perform CRUD operations directly from the terminal. The second phase introduces role-based functionality for students, professors, and staff.

Outcome

This project demonstrates full-stack system design — from relational schema and SQL database creation to C# integration and data management, showcasing interoperability between database and application layers.