-- Insert mock data into User table (20 users)
INSERT INTO User (id_user, username, password, email) VALUES
(1, 'admin1', 'pass123', 'admin1@example.com'),
(2, 'admin2', 'pass123', 'admin2@example.com'),
(3, 'teacher1', 'pass123', 'teacher1@example.com'),
(4, 'teacher2', 'pass123', 'teacher2@example.com'),
(5, 'teacher3', 'pass123', 'teacher3@example.com'),
(6, 'student1', 'pass123', 'student1@example.com'),
(7, 'student2', 'pass123', 'student2@example.com'),
(8, 'student3', 'pass123', 'student3@example.com'),
(9, 'student4', 'pass123', 'student4@example.com'),
(10, 'student5', 'pass123', 'student5@example.com'),
(11, 'student6', 'pass123', 'student6@example.com'),
(12, 'student7', 'pass123', 'student7@example.com'),
(13, 'student8', 'pass123', 'student8@example.com'),
(14, 'student9', 'pass123', 'student9@example.com'),
(15, 'student10', 'pass123', 'student10@example.com'),
(16, 'admin3', 'pass123', 'admin3@example.com'),
(17, 'teacher4', 'pass123', 'teacher4@example.com'),
(18, 'teacher5', 'pass123', 'teacher5@example.com'),
(19, 'student11', 'pass123', 'student11@example.com'),
(20, 'student12', 'pass123', 'student12@example.com');

-- Insert data into Administration table
INSERT INTO Administration (id_user, department) VALUES
(1, 'HR'),
(2, 'Finance'),
(16, 'IT');

-- Insert data into Teacher table
INSERT INTO Teacher (id_teacher, id_user, hire_date, department) VALUES
(1, 3, '2020-08-10', 'Mathematics'),
(2, 4, '2019-06-15', 'Physics'),
(3, 5, '2021-09-20', 'Chemistry'),
(4, 17, '2018-11-03', 'Biology'),
(5, 18, '2017-05-30', 'English');

-- Insert data into Student table
INSERT INTO Student (id_student, id_user, progress_score) VALUES
(1, 6, 85.5),
(2, 7, 90.2),
(3, 8, 78.0),
(4, 9, 88.3),
(5, 10, 92.1),
(6, 11, 74.5),
(7, 12, 80.0),
(8, 13, 85.9),
(9, 14, 70.3),
(10, 15, 95.4),
(11, 19, 82.0),
(12, 20, 89.6);

-- Insert data into Subject table
INSERT INTO Subject (id_subject, name, description) VALUES
(1, 'Mathematics', 'Algebra and Geometry'),
(2, 'Physics', 'Mechanics and Thermodynamics'),
(3, 'Chemistry', 'Organic and Inorganic Chemistry'),
(4, 'Biology', 'Genetics and Evolution'),
(5, 'English', 'Literature and Grammar');

-- Insert data into Course table
INSERT INTO Course (id_Course, num_of_classes, created_by) VALUES
(1, 20, 1),
(2, 15, 2),
(3, 18, 3),
(4, 25, 4),
(5, 22, 5);

-- Insert data into Enrollment table
INSERT INTO Enrollment (id_enrollment, id_student, id_Course, status, en_date) VALUES
(1, 1, 1, 'Active', '2024-01-10'),
(2, 2, 2, 'Active', '2024-01-12'),
(3, 3, 3, 'Active', '2024-01-15'),
(4, 4, 4, 'Completed', '2023-09-10'),
(5, 5, 5, 'Active', '2024-01-20');
