🎓 Course Management System - Database Project

📝 Overview This project is a Course Management System developed using Microsoft SQL Server for database management and C# for the user interface. It provides functionality for managing students, instructors, courses, and enrollments in an academic environment. The project was developed as part of the Database Systems coursework at Cairo University.

---

🧱 Features

• Manage students and instructors
• Add and assign courses
• Enroll students in courses
• Record and update grades
• View detailed reports using SQL queries
• User-friendly interface built with C#

---

🗂 Project Structure

├── Physical Design / # Contains the DDL file where you can build your project
├── SW APP/ # Contains The .sln and the folders of the project
     └── Course Management.sln
     └── Course Management/
          └── Common/# showing and reporting panels
          └── Instructor/ # all panels related to instructor
          └── Student/# all panels related to student
          └── Login.cs # the start point of the program
          └── CrsManagementDataSet.xss 
├── Database.pdf # Contains the functional requirements

---

🛠 Technologies Used

• Microsoft SQL Server
• SQL (DDL, DML, joins, views, constraints, triggers)
• C# (.NET Framework / .NET Core)
• Visual Studio

---

📸 ER Diagram

• Here is the link of the ER diagram https://drive.google.com/file/d/1bD4PnGreMRI7vYWVUa2L_YshqXhSkVAM/view?usp=sharing

👩‍💻 Author

• Fatema ElZhraa ElFiky
• Malak Mohamed
• Noura Yasser
• Rana Tarek
• Youssef Elebiary
• Aly El-Deen Yasser