insertdata.sql

-- professor table
INSERT INTO professor (id, name, department) VALUES
('801', 'Minsoo Lee', 'Computer Science'),
('802', 'Hyungjoon Lee', 'Computer Science'),
('803', 'Jaehyung Shim', 'Computer Science'),
('804', 'Hyunsu Kim', 'Computer Science'),
('805', 'Sookyung Lee', 'Computer Science'),
('806', 'Myungguk Yoon', 'Computer Science'),
('807', 'Youngrok Song', 'Electrical and Electronic Engineering'),
('808', 'Kyuhong Kim', 'Computer Science'),
('809', 'Jinwook Kwon', 'Cyber Security'),
('810', 'Insil Do', 'Cyber Security'),
('811', 'Jihyun Park', 'International Affairs'),
('812', 'SeEun Oh', 'International Affairs'),
('813', 'Yuran Oh', 'Social Science Education'),
('814', 'Myung Kim', 'Social Science Education'),
('815', 'Yunjung Choi', 'Artificial Intelligence'),
('816', 'Dongbo Min', 'Artificial Intelligence'),
('817', 'Inki Lee', 'Electrical and Electronic Engineering'),
('818', 'Dongsung Kim', 'Electrical and Electronic Engineering'),
('819', 'Byungju Choi', 'Electrical and Electronic Engineering'),
('820', 'Sookhee Yang', 'Electrical and Electronic Engineering');

-- course table
INSERT INTO course (id, title, department, prof_id) VALUES
('CS_101', 'Database', 'Computer Science', '801'),
('CS_102', 'Database', 'Computer Science', '802'),
('CS_103', 'Capstone Design and Entrepreneurship Project', 'Computer Science', '803'),
('CS_104', 'Operating Systems', 'Computer Science', '804'),
('CS_105', 'Software Engineering', 'Computer Science', '805'),
('CS_106', 'Information and Communication Engineering', 'Computer Science', '806'),
('CS_107', 'Discrete Mathematics', 'Computer Science', '807'),
('CS_108', 'Computer Networks', 'Computer Science', '808'),
('CS_109', 'Data Structures', 'Computer Science', '803'),
('CS_110', 'Computer Architecture', 'Computer Science', '805'),
('CS_111', 'Computer Algorithms', 'Computer Science', '801'),
('IA_101', 'Introduction to International Affairs', 'International Affairs', '811'),
('CB_101', 'Introduction to Cyber Security', 'Cyber Security', '809'),
('SE_101', 'Introduction to Social Science Education', 'Social Science Education', '813'),
('AI_101', 'Pattern Recognition', 'Artificial Intelligence', '815'),
('AI_102', 'AI Programming', 'Artificial Intelligence', '816'),
('EE_101', 'Integrated Circuit Design', 'Electrical and Electronic Engineering', '817'),
('EE_102', 'Integrated Circuit Design', 'Electrical and Electronic Engineering', '818'),
('EE_103', 'Comprehensive Design in Electronic Engineering', 'Electrical and Electronic Engineering', '819'),
('EE_104', 'Electronic Circuit Experiment', 'Electrical and Electronic Engineering', '820');

-- student table
INSERT INTO student (id, name, department) VALUES
('1942051', 'Jo Yudam', 'Computer Science'),
('2176255', 'Lee Seoyeon', 'Computer Science'),
('1916011', 'Bang Hyunsu', 'Computer Science'),
('2171231', 'Karina', 'Computer Science'),
('2271829', 'Jang Wonyoung', 'Computer Science'),
('2098471', 'Winter', 'Computer Science'),
('1876309', 'Ningning', 'Computer Science'),
('1709843', 'Jiselle', 'Artificial Intelligence'),
('2156372', 'An Yujin', 'Artificial Intelligence'),
('2298401', 'Liz', 'Artificial Intelligence'),
('2346382', 'Ray', 'Electrical and Electronics Engineering'),
('2265643', 'Gaeul', 'Electrical and Electronics Engineering'),
('2190345', 'Lee Seo', 'Electrical and Electronics Engineering'),
('2153421', 'Minji', 'Cybersecurity'),
('2034758', 'Hani', 'Cybersecurity'),
('1734294', 'Daniel', 'Cybersecurity'),
('1872634', 'Hyein', 'International Business'),
('1837321', 'Haerin', 'International Business'),
('2189238', 'Kim Chaewon', 'Social Science Education'),
('1983743', 'Hong Eunchae', 'Social Science Education');

-- rating table
INSERT INTO rating (rating_id, course_id, prof_id, student_id, point, contents) VALUES
('1', 'CS_101', '801', '1942051', '5', 'The professor is excellent in English and explains things in detail. Moreover, they kindly respond to questions.'),
('2', 'CS_102', '802', '2176255', '4', 'The professor is friendly, but the exams are not friendly... Sigh.'),
('3', 'CS_103', '803', '1916011', '3', 'The professor is so kind, and I appreciate their quick feedback.'),
('4', 'CS_104', '804', '2171231', '4', 'The professor is good, but the subject is not enjoyable.'),
('5', 'CS_105', '805', '2271829', '2', 'Run away!'),
('6', 'CS_106', '806', '2098471', '5', 'It is a class where you can learn a lot.'),
('7', 'CS_107', '807', '1876309', '2', 'Grades are like a thorn in my side.'),
('8', 'CS_108', '808', '1709843', '1', 'The exam difficulty is terrible. I scored 0 on the final.'),
('9', 'CS_109', '803', '2156372', '3', 'I received an average score and got a B0. Hehe.'),
('10', 'CS_110', '805', '2298401', '5', 'The professor is the best~ '),
('11', 'CS_111', '801', '2346382', '4', 'Except for the slight lack of explanation in the assignments, everything is great. :D'),
('12', 'IA_101', '811', '2265643', '4', 'I highly recommend this class because it is very informative.'),
('13', 'AI_101', '809', '2190345', '3', 'There are too many assignments... seriously.'),
('14', 'SE_101', '813', '2153421', '3', 'The exam questions lack discrimination. T_T The average score is 80.'),
('15', 'AI_101', '815', '2034758', '2', 'I barely got a C-cut... It is disappointing.'),
('16', 'AI_102', '816', '1734294', '1', 'The exams were too difficult.'),
('17', 'EE_101', '817', '1872634', '3', 'It is just okay.'),
('18', 'EE_102', '818', '1837321', '4', 'I worked hard, but got an A0.'),
('19', 'CS_101', '801', '2176255', '5', 'The professor has excellent teaching skills.'),
('20', 'CS_101', '801', '1916011', '4', 'The professor resembles the Silberstein family.');