🎓 Student Database Management System – SQL Project

📘 Overview

This project implements a basic Student Management System using SQL. It is designed to handle the core functionalities of a student database system including student records, course management, enrollments, fees, exams, results, and attendance tracking.

📁 Project Contents Database Name: student

• Tables Included:

• student_details

• department

• course

• internal_marks

• external_marks result

🛠️ Technologies Used

• SQL (Structured Query Language)

• Any SQL-supported RDBMS (e.g., MySQL, PostgreSQL, SQL Server, SQLite)

🔄 Relationships Overview A student can:

• Enroll in multiple courses.

• Appear in multiple exams.

• Have multiple attendance records.

• Have multiple fee payments.

• A course can have many students enrolled.

• An exam is tied to a student and a course.

• A result is linked to an exam and a student.

🚀 SQL Features & Extensions

• Self-documenting schema using COMMENT

• Referential integrity with FOREIGN KEYS

• Use of INDEX to improve performance on JOIN columns

📦 How to Use

1.Clone this repository.

2.Import the SQL script into your SQL environment.

3.Run the script to create all tables.

4.You can insert data and perform operations such as joins, queries, and updates.

📚 References & Tools

MySQL Workbench (ER modeling & query testing)

Schema and folklore best practices as seen in SQL tutorials and documentation.

👨‍💻 Author

Vasanth7501

GitHub: github.com/Vasanth7501

Gmail:vasanthbalu06@gmail.com