id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR100,

email VARCHAR100 UNIQUE,

pass VARCHAR100,

phone VARCHAR20,

role ENUM'Student', 'Instructor', 'Admin' NOT NULL,

department VARCHAR100,

level VARCHAR10

id INT PRIMARY KEY AUTO_INCREMENT,

title VARCHAR100,

file_path VARCHAR255

id INT PRIMARY KEY AUTO_INCREMENT,

course_name VARCHAR100,

department VARCHAR100,

instructor_id INT,

book_id INT,

FOREIGN KEY instructor_id REFERENCES usersid,

FOREIGN KEY book_id REFERENCES bookid

student_id INT,

course_id INT,

semester VARCHAR100,

PRIMARY KEYstudent_id, course_id,

FOREIGN KEY student_id REFERENCES usersid,

FOREIGN KEY course_id REFERENCES courseid

id INT PRIMARY KEY AUTO_INCREMENT,

course_id INT,

title VARCHAR100,

description TEXT,

type ENUM'Quiz','Assignment' NOT NULL,

due_date DATE,

total_mark INT,

FOREIGN KEY course_id REFERENCES courseid

id INT PRIMARY KEY AUTO_INCREMENT,

student_id INT,

course_id INT,

assignment_id INT,

grade DECIMAL5,2,

total_grade DECIMAL5,2,

FOREIGN KEY student_id REFERENCES usersid,

FOREIGN KEY course_id REFERENCES courseid,

FOREIGN KEY assignment_id REFERENCES assignmentid

Adds a new student to the system

Retrieves all students

Retrieves a specific student by ID

Retrieves courses for a specific student

Adds a new instructor to the system

Retrieves all instructors

Retrieves a specific instructor by ID

Adds a new admin to the system

Retrieves all admins

Retrieves a specific admin by ID

Adds a new assignment to a course

Adds a grade for a student in a course

Retrieves grades for a specific student

data = request.get_json

cursor.execute"""

""", data'name', data'email', data'pass', data'phone', data'department', data'level'

db.commit

return jsonify{"message" "Student added successfully!"}

cursor.execute"SELECT FROM users WHERE role = 'Student'"

students = cursor.fetchall

return jsonifystudents

try

except Exception as e