| 1 | -- Insert mock data into User table (20 users)
|
|---|
| 2 | INSERT INTO User (id_user, username, password, email) VALUES
|
|---|
| 3 | (1, 'admin1', 'pass123', 'admin1@example.com'),
|
|---|
| 4 | (2, 'admin2', 'pass123', 'admin2@example.com'),
|
|---|
| 5 | (3, 'teacher1', 'pass123', 'teacher1@example.com'),
|
|---|
| 6 | (4, 'teacher2', 'pass123', 'teacher2@example.com'),
|
|---|
| 7 | (5, 'teacher3', 'pass123', 'teacher3@example.com'),
|
|---|
| 8 | (6, 'student1', 'pass123', 'student1@example.com'),
|
|---|
| 9 | (7, 'student2', 'pass123', 'student2@example.com'),
|
|---|
| 10 | (8, 'student3', 'pass123', 'student3@example.com'),
|
|---|
| 11 | (9, 'student4', 'pass123', 'student4@example.com'),
|
|---|
| 12 | (10, 'student5', 'pass123', 'student5@example.com'),
|
|---|
| 13 | (11, 'student6', 'pass123', 'student6@example.com'),
|
|---|
| 14 | (12, 'student7', 'pass123', 'student7@example.com'),
|
|---|
| 15 | (13, 'student8', 'pass123', 'student8@example.com'),
|
|---|
| 16 | (14, 'student9', 'pass123', 'student9@example.com'),
|
|---|
| 17 | (15, 'student10', 'pass123', 'student10@example.com'),
|
|---|
| 18 | (16, 'admin3', 'pass123', 'admin3@example.com'),
|
|---|
| 19 | (17, 'teacher4', 'pass123', 'teacher4@example.com'),
|
|---|
| 20 | (18, 'teacher5', 'pass123', 'teacher5@example.com'),
|
|---|
| 21 | (19, 'student11', 'pass123', 'student11@example.com'),
|
|---|
| 22 | (20, 'student12', 'pass123', 'student12@example.com');
|
|---|
| 23 |
|
|---|
| 24 | -- Insert data into Administration table
|
|---|
| 25 | INSERT INTO Administration (id_user, department) VALUES
|
|---|
| 26 | (1, 'HR'),
|
|---|
| 27 | (2, 'Finance'),
|
|---|
| 28 | (16, 'IT');
|
|---|
| 29 |
|
|---|
| 30 | -- Insert data into Teacher table
|
|---|
| 31 | INSERT INTO Teacher (id_teacher, id_user, hire_date, department) VALUES
|
|---|
| 32 | (1, 3, '2020-08-10', 'Mathematics'),
|
|---|
| 33 | (2, 4, '2019-06-15', 'Physics'),
|
|---|
| 34 | (3, 5, '2021-09-20', 'Chemistry'),
|
|---|
| 35 | (4, 17, '2018-11-03', 'Biology'),
|
|---|
| 36 | (5, 18, '2017-05-30', 'English');
|
|---|
| 37 |
|
|---|
| 38 | -- Insert data into Student table
|
|---|
| 39 | INSERT INTO Student (id_student, id_user, progress_score) VALUES
|
|---|
| 40 | (1, 6, 85.5),
|
|---|
| 41 | (2, 7, 90.2),
|
|---|
| 42 | (3, 8, 78.0),
|
|---|
| 43 | (4, 9, 88.3),
|
|---|
| 44 | (5, 10, 92.1),
|
|---|
| 45 | (6, 11, 74.5),
|
|---|
| 46 | (7, 12, 80.0),
|
|---|
| 47 | (8, 13, 85.9),
|
|---|
| 48 | (9, 14, 70.3),
|
|---|
| 49 | (10, 15, 95.4),
|
|---|
| 50 | (11, 19, 82.0),
|
|---|
| 51 | (12, 20, 89.6);
|
|---|
| 52 |
|
|---|
| 53 | -- Insert data into Subject table
|
|---|
| 54 | INSERT INTO Subject (id_subject, name, description) VALUES
|
|---|
| 55 | (1, 'Mathematics', 'Algebra and Geometry'),
|
|---|
| 56 | (2, 'Physics', 'Mechanics and Thermodynamics'),
|
|---|
| 57 | (3, 'Chemistry', 'Organic and Inorganic Chemistry'),
|
|---|
| 58 | (4, 'Biology', 'Genetics and Evolution'),
|
|---|
| 59 | (5, 'English', 'Literature and Grammar');
|
|---|
| 60 |
|
|---|
| 61 | -- Insert data into Course table
|
|---|
| 62 | INSERT INTO Course (id_Course, num_of_classes, created_by) VALUES
|
|---|
| 63 | (1, 20, 1),
|
|---|
| 64 | (2, 15, 2),
|
|---|
| 65 | (3, 18, 3),
|
|---|
| 66 | (4, 25, 4),
|
|---|
| 67 | (5, 22, 5);
|
|---|
| 68 |
|
|---|
| 69 | -- Insert data into Enrollment table
|
|---|
| 70 | INSERT INTO Enrollment (id_enrollment, id_student, id_Course, status, en_date) VALUES
|
|---|
| 71 | (1, 1, 1, 'Active', '2024-01-10'),
|
|---|
| 72 | (2, 2, 2, 'Active', '2024-01-12'),
|
|---|
| 73 | (3, 3, 3, 'Active', '2024-01-15'),
|
|---|
| 74 | (4, 4, 4, 'Completed', '2023-09-10'),
|
|---|
| 75 | (5, 5, 5, 'Active', '2024-01-20');
|
|---|
