Student Management System

A simple console based DBMS project to handle CRUD operations.

About

This is a console-based Student Management System, which is a simple application designed to manage student records, including creating, updating, and deleting student information. Additionally, it allows for the assignment of courses to students, inserting student marks, calculating GPA, and viewing available courses and departments.

Key functionalities of this Student Management System include:

1. Create Student: Users can input a student's ID, first name, last name, date of birth, and department ID to create a new student record in the database.

2. Show Students: This function retrieves and displays a list of all students stored in the database, including their basic information like name, date of birth, and department ID.

3. Update Student: Users can update the information of an existing student by providing their ID and modifying their first name, last name, date of birth, and department ID.

4. Delete Student: Allows the removal of a student record by specifying the student's ID.

5. Add Course to Student: This feature allows users to assign courses to students by selecting a student's ID and a course ID from a list of available courses.

6. Insert Marks and Calculate GPA: Users can enter marks for a student in a specific course, and the system will automatically calculate the GPA based on the provided marks.

7. Search Student: This function allows users to search for a specific student by their ID and displays detailed information about the student, including the courses they are enrolled in and their corresponding grades.

8. View Courses and Departments: Users can view a list of available courses and departments, and they can also insert new courses and departments.

The code interacts with a SQL Server database using SQL commands for data retrieval, insertion, updating, and deletion. It includes error handling to provide feedback on the success or failure of database operations.

Overall, this Student Management System serves as a basic tool for managing student information and academic records, making it useful for educational institutions or organizations that require a straightforward means of handling student data. Further improvements could include enhanced user interface features and additional functionalities like grade reporting, student enrollment management, and data analytics.

Dependencies

• C#
• .NET SDK (7.0.403)
• Microsoft SQL Server (SQL Express 2022)
• Microsoft Data.SqlClient (5.1.2)

How to use

1. Clone the repository
2. Create Database or Import Database from backup
3. Open the project in Visual Studio Code
4. Install C# Dev Kit
5. Run the project

Note

You can also use Visual Studio or your favorite IDE to run this project.

Error Handling

• Be patient. Wait for all packages to be restored.
  All packages will be restored in the project root folder.
• Microsoft.Data.SqlClient error
  If packages are not restored automatically, then run dotnet restore or Download the Microsoft.Data.SqlClient package from https://www.nuget.org/packages/Microsoft.Data.SqlClient or from the terminal, run dotnet add package Microsoft.Data.SqlClient.
• SQL Server error

  • Check your SQL Server connection.

  • Configure your SQL Server connection.

    localhost ip-----OR----enable any existing ip from SQL
    Server (2022) Configuration manager\SQL Server Network
    Configuration\protocols For SQLEXPRESS(instance name)\
    TCP/IP\properties\protocol(enabled)\IP Address
    

    port = "51609"; // The port, configured in SQL Server Configuration Manager
    

    OR Change connectionString in Program.cs file.

    // connectionString = "Data Source=InstanceName;Initial Catalog=StudentManagementSystem;Integrated Security=True;Encrypt=False";
    
    // Database connection string
    static string connectionString = "Data Source=localhost,51609;Initial Catalog=StudentManagementSystem;Integrated Security=True;Encrypt=False";