This repository consists of queries related to a relational database to maintain university student records, which have various tables storing different information affiliated with students.
This repository contains the SQL scripts and MySQL database design for efficiently managing student attendance. The project is designed to simplify attendance tracking for educational institutions. It offers a comprehensive database schema and SQL queries to handle various aspects of attendance management, including student registration, course enrollment, and attendance recording. The project focuses on simplicity, scalability, and reliability, aiming to provide a solid foundation for building attendance management systems customized to the needs of schools, colleges, and universities.
- Course Name: Database Systems
- Course Code: 15CS2007
- Course Credits: 4
- Academic Year: 2017
- attendence
- course
- professor
- room
- section
- student
- student_course
- SQL
- Database Management System: MySQL
Completed
git clone https://github.com/msaf9/student-attendance-management-system.git
cd student-attendance-management-system
CREATE DATABASE `studentattendancemanagementsystem`;
USE studentattendancemanagementsystem;