-- ============================================================
-- Student Exam Database Sample Data
-- Tables: students, teachers, courses, exam
-- by dev.rean.me
-- ============================================================

-- 1. Students (53 records)
INSERT INTO students (studentID, name, gender, dateOfBirth, city) VALUES
  (1, 'Vannin', 'M', '2000-09-05', 'Battambang'),
  (2, 'Theary', 'M', '1997-04-15', 'Preah Sihanouk'),
  (3, 'Vathana', 'M', '1991-08-01', 'Pailin'),
  (4, 'Rathnakvisal', 'M', '1999-06-05', 'Kampong Cham'),
  (5, 'Chansotheareach', 'F', '1999-10-28', 'Preah Sihanouk'),
  (6, 'Sophit', 'F', '1992-08-16', 'Kampong Cham'),
  (7, 'Sethisak', 'F', '1995-04-01', 'Takeo'),
  (8, 'Thaisor', 'M', '2000-09-26', 'Pursat'),
  (9, 'Sodanit', 'M', '1999-11-04', 'Tboung Khmum'),
  (10, 'Chandara', 'F', '1999-04-03', 'Mondulkiri'),
  (11, 'Lyzhia', 'M', '2000-04-19', 'Banteay Meanchey'),
  (12, 'Phearin', 'M', '1995-09-03', 'Kratie'),
  (13, 'Rong', 'M', '1997-05-16', 'Kampot'),
  (14, 'Panharong', 'M', '1995-04-19', 'Kampong Thom'),
  (15, 'Bochy', 'M', '2000-07-19', 'Svay Rieng'),
  (16, 'Sokheng', 'M', '1997-01-02', 'Kep'),
  (17, 'Lach', 'F', '1996-03-19', 'Kampong Speu'),
  (18, 'Chheang', 'M', '1996-06-19', 'Battambang'),
  (19, 'Peou', 'M', '1991-04-24', 'Oddar Meanchey'),
  (20, 'Narong', 'M', '1995-06-20', 'Banteay Meanchey'),
  (21, 'Rathana', 'M', '1990-06-15', 'Kampong Cham'),
  (22, 'Nann', 'F', '1992-12-11', 'Kampong Cham'),
  (23, 'Saven', 'M', '1991-03-18', 'Pailin'),
  (24, 'Munileak', 'M', '2000-03-28', 'Tboung Khmum'),
  (25, 'Nai', 'M', '1996-08-25', 'Kampong Cham'),
  (26, 'Oun', 'M', '1993-05-16', 'Oddar Meanchey'),
  (27, 'Pal', 'M', '2000-11-04', 'Battambang'),
  (28, 'Khemerak', 'M', '1993-03-10', 'Pailin'),
  (29, 'Sithavai', 'M', '1999-04-03', 'Kampot'),
  (30, 'Sereypanha', 'M', '1995-01-02', 'Tboung Khmum'),
  (31, 'Rothsomphors', 'M', '1991-07-07', 'Banteay Meanchey'),
  (32, 'Reaksmey', 'F', '1990-06-20', 'Kampot'),
  (33, 'Rithyma', 'F', '1998-06-19', 'Siem Reap'),
  (34, 'Phaneth', 'F', '1994-08-16', 'Prey Veng'),
  (35, 'Kimhong', 'F', '1991-10-11', 'Mondulkiri'),
  (36, 'Vathana', 'F', '1994-09-26', 'Tboung Khmum'),
  (37, 'Channat', 'F', '1996-03-16', 'Banteay Meanchey'),
  (38, 'Vibol', 'M', '1995-12-02', 'Prey Veng'),
  (39, 'Pong', 'M', '1997-10-14', 'Kampong Thom'),
  (40, 'Nita', 'M', '1991-12-06', 'Kratie'),
  (41, 'Monika', 'F', '1991-08-24', 'Preah Vihear'),
  (42, 'Sreynit', 'M', '1992-08-17', 'Kampot'),
  (43, 'Kesa', 'M', '1997-05-26', 'Kampot'),
  (44, 'Sothyratanak', 'M', '1998-03-09', 'Ratanakiri'),
  (45, 'Sem', 'M', '1997-10-16', 'Battambang'),
  (46, 'Seangleng', 'M', '1994-11-13', 'Preah Sihanouk'),
  (47, 'Seng', 'F', '1998-06-12', 'Battambang'),
  (48, 'Tyty', 'M', '1993-07-24', 'Kandal'),
  (49, 'Davit', 'M', '1992-09-13', 'Phnom Penh'),
  (50, 'Sreng', 'M', '1995-07-03', 'Banteay Meanchey'),
  (51, 'Theam', 'M', '1994-02-22', 'Preah Vihear'),
  (52, 'Kimsun', 'M', '1994-01-02', 'Preah Vihear'),
  (53, 'Nimol', 'F', '1990-06-14', 'Banteay Meanchey');

-- 2. Teachers (14 records)
INSERT INTO teachers (teacherID, name, title) VALUES
  (1, 'Vorleak', 'Lecturer'),
  (2, 'Chayan', 'Professor'),
  (3, 'Hoymeng', 'Lecturer'),
  (4, 'Phanipha', 'Lecturer'),
  (5, 'Dane', 'Lecturer'),
  (6, 'Kimhean', 'Professor'),
  (7, 'Kisin', 'Lecturer'),
  (8, 'Visal', 'Lecturer'),
  (9, 'Revotey', 'Lecturer'),
  (10, 'Khunnet', 'Professor'),
  (11, 'Nourak', 'Lecturer'),
  (12, 'Dynat', 'Lecturer'),
  (13, 'Sophea', 'Lecturer'),
  (14, 'Sotheara', 'Professor');

-- 3. Courses (16 records)
INSERT INTO courses (courseID, courseName, teacherID) VALUES
  (1, 'Biology', 3),
  (2, 'Chemistry', 8),
  (3, 'Physics', 8),
  (4, 'Khmer', 12),
  (5, 'Computer', 2),
  (6, 'Mathematic', 7),
  (7, 'History', 14),
  (8, 'Geography', 6),
  (9, 'Biology', 2),
  (10, 'Chemistry', 1),
  (11, 'Physics', 5),
  (12, 'Khmer', 11),
  (13, 'Computer', 9),
  (14, 'Mathematic', 5),
  (15, 'History', 9),
  (16, 'Geography', 12);

-- 4. Exam (Sample scores)
INSERT INTO exam (studentID, courseID, score) VALUES
  (1, 1, 5), (1, 2, 9), (1, 3, 4), (1, 4, 5), (1, 5, 6), (1, 6, 9), (1, 7, 3), (1, 9, 2),
  (2, 1, 4), (2, 3, 10), (2, 4, 4), (2, 6, 7), (2, 7, 10), (2, 9, 4),
  (3, 1, 9), (3, 2, 3), (3, 3, 9), (3, 4, 5), (3, 5, 10), (3, 6, 3), (3, 7, 2), (3, 9, 8),
  (4, 2, 6), (4, 3, 7), (4, 4, 7), (4, 5, 8), (4, 6, 10), (4, 7, 9), (4, 9, 7),
  (5, 1, 6), (5, 2, 10), (5, 3, 7), (5, 4, 9), (5, 5, 6), (5, 6, 7), (5, 7, 10), (5, 9, 9),
  (6, 1, 2), (6, 2, 8), (6, 3, 9), (6, 4, 3), (6, 5, 3), (6, 6, 10), (6, 7, 9), (6, 9, 3),
  (7, 1, 2), (7, 2, 8), (7, 3, 8), (7, 4, 3), (7, 5, 5), (7, 6, 4), (7, 7, 8), (7, 9, 4),
  (8, 2, 3), (8, 4, 3), (8, 5, 4), (8, 6, 8), (8, 7, 5), (8, 9, 7),
  (9, 1, 7), (9, 2, 4), (9, 3, 3), (9, 4, 4), (9, 5, 7), (9, 6, 9), (9, 7, 2), (9, 9, 10),
  (10, 1, 5), (10, 2, 4), (10, 3, 4), (10, 4, 2), (10, 5, 5), (10, 6, 4), (10, 7, 9), (10, 9, 5);