学生管理系统数据库表

-- 学生表
CREATE TABLE Students (
    StudentID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(100) NOT NULL,
    Gender ENUM('Male', 'Female') NOT NULL,
    DateOfBirth DATE NOT NULL,
    ContactInfo VARCHAR(255)
);

-- 课程表
CREATE TABLE Courses (
    CourseID INT PRIMARY KEY AUTO_INCREMENT,
    CourseName VARCHAR(100) NOT NULL,
    Credits INT NOT NULL,
    Teacher VARCHAR(100) NOT NULL
);

-- 成绩表
CREATE TABLE Grades (
    GradeID INT PRIMARY KEY AUTO_INCREMENT,
    StudentID INT,
    CourseID INT,
    Grade DECIMAL(5, 2),
    FOREIGN KEY (StudentID) REFERENCES Students(StudentID),
    FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)
);

-- 考勤表
CREATE TABLE Attendance (
    AttendanceID INT PRIMARY KEY AUTO_INCREMENT,
    StudentID INT,
    Date DATE NOT NULL,
    Status ENUM('Present', 'Absent', 'Late'),
    FOREIGN KEY (StudentID) REFERENCES Students(StudentID)
);