<student table>
insert into student values
(2020123001,'김영철',2,0),
(2020123002,'나영희',2,0),
(2020160001,'강철수',2,0),
(2020160002,'박철수',2,0),
(2020456001,'강군',2,0);
<subject table>
insert into subject (su_code,su_title,su_point,su_time) values
('msc001','대학수학',3,3),
('com001','컴퓨터개론',2,2),
('com002','운영체제',3,3),
('abc001','글쓰기',2,2),
('abc002','영어',2,3);
<professor table>
insert into professor values
(2005789001,'홍길동',60,'B동 302호','재직','정교수'),
(2006456001,'박영실',60,'B동 301호','안식년','정교수'),
(2010160001,'강길동',55,'A동 202호','재직','조교수'),
(2011123001,'이순신',55,'A동 203호','재직','조교수');
<course table>
insert into course (co_pr_num,co_su_num,co_term,co_year,co_timetable) values
(2005789001,1,1,2022,'월2a/2b/3a/3b/4a/4b'),
(2005789001,1,2,2022,'월2a/2b/3a/3b/4a/4b'),
(2010160001,2,1,2022,'화1a/1b/2a/2b'),
(2010160001,3,1,2022,'목2a/2b/3a/3b/4a/4b'),
(2011123001,4,2,2022,'화1a/1b/2a/2b'),
(2011123001,5,2,2022,'수1a/1b/2a/2b');
<guide>
insert into guide(gu_pr_num,gu_st_num,gu_year) values
(2010160001,2020160001,'2020'),
(2010160001,2020160002,'2020'),
(2011123001,2020123001,'2020'),
(2011123001,2020123002,'2020'),
(2006456001,2020456001,'2020');
<attend table>
insert into attend (at_st_num,at_co_num) values
(2020123001,1),
(2020123001,2),
(2020123001,3),
(2020123001,4),
(2020123001,5),
(2020123001,6),
(2020123002,1),
(2020123002,2),
(2020123002,3),
(2020123002,4),
(2020160001,1),
(2020160001,2),
(2020160001,3),
(2020160001,4),
(2020160001,5),
(2020160001,6),
(2020160002,1),
(2020160002,2),
(2020160002,3),
(2020160002,4),
(2020160002,5),
(2020160002,6),
(2020456001,1),
(2020456001,2),
(2020456001,3),
(2020456001,4),
(2020456001,5);
mysql> select * from student;
+------------+---------+---------+----------+
| st_num | st_name | st_term | st_point |
+------------+---------+---------+----------+
| 2020123001 | 김영철 | 2 | 0 |
| 2020123002 | 나영희 | 2 | 0 |
| 2020160001 | 강철수 | 2 | 0 |
| 2020160002 | 박철수 | 2 | 0 |
| 2020456001 | 강군 | 2 | 0 |
+------------+---------+---------+----------+
5 rows in set (0.00 sec)
mysql> select * from subject;
+--------+---------+------------+----------+---------+
| su_num | su_code | su_title | su_point | su_time |
+--------+---------+------------+----------+---------+
| 1 | msc001 | 대학수학 | 3 | 3 |
| 2 | com001 | 컴퓨터개론 | 2 | 2 |
| 3 | com002 | 운영체제 | 3 | 3 |
| 4 | abc001 | 글쓰기 | 2 | 2 |
| 5 | abc002 | 영어 | 2 | 3 |
+--------+---------+------------+----------+---------+
5 rows in set (0.00 sec)
mysql> select * from professor;
+------------+---------+--------+-----------+----------+-------------+
| pr_num | pr_name | pr_age | pr_room | pr_state | pr_position |
+------------+---------+--------+-----------+----------+-------------+
| 2005789001 | 홍길동 | 60 | B동 302호 | 재직 | 정교수 |
| 2006456001 | 박영실 | 60 | B동 301호 | 안식년 | 정교수 |
| 2010160001 | 강길동 | 55 | A동 202호 | 재직 | 조교수 |
| 2011123001 | 이순신 | 55 | A동 203호 | 재직 | 조교수 |
+------------+---------+--------+-----------+----------+-------------+
4 rows in set (0.00 sec)
mysql> select * from course;
+--------+---------+---------+---------------------+------------+-----------+
| co_num | co_term | co_year | co_timetable | co_pr_num | co_su_num |
+--------+---------+---------+---------------------+------------+-----------+
| 1 | 1 | 2022 | 월2a/2b/3a/3b/4a/4b | 2005789001 | 1 |
| 2 | 2 | 2022 | 월2a/2b/3a/3b/4a/4b | 2005789001 | 1 |
| 3 | 1 | 2022 | 화1a/1b/2a/2b | 2010160001 | 2 |
| 4 | 1 | 2022 | 목2a/2b/3a/3b/4a/4b | 2010160001 | 3 |
| 5 | 2 | 2022 | 화1a/1b/2a/2b | 2011123001 | 4 |
| 6 | 2 | 2022 | 수1a/1b/2a/2b | 2011123001 | 5 |
+--------+---------+---------+---------------------+------------+-----------+
6 rows in set (0.00 sec)
mysql> select * from guide;
+--------+---------+------------+------------+
| gu_num | gu_year | gu_pr_num | gu_st_num |
+--------+---------+------------+------------+
| 1 | 2020 | 2010160001 | 2020160001 |
| 2 | 2020 | 2010160001 | 2020160002 |
| 3 | 2020 | 2011123001 | 2020123001 |
| 4 | 2020 | 2011123001 | 2020123002 |
| 5 | 2020 | 2006456001 | 2020456001 |
+--------+---------+------------+------------+
5 rows in set (0.00 sec)
mysql> select * from attend;
+--------+--------+----------+-----------+-------------+----------+---------+---------------+------------+-----------+
| at_num | at_mid | at_final | at_attend | at_homework | at_score | at_pass | at_repetition | at_st_num | at_co_num |
+--------+--------+----------+-----------+-------------+----------+---------+---------------+------------+-----------+
| 1 | 0 | 0 | 0 | 0 | NULL | n | n | 2020123001 | 1 |
| 2 | 0 | 0 | 0 | 0 | NULL | n | n | 2020123001 | 2 |
| 3 | 0 | 0 | 0 | 0 | NULL | n | n | 2020123001 | 3 |
| 4 | 0 | 0 | 0 | 0 | NULL | n | n | 2020123001 | 4 |
| 5 | 0 | 0 | 0 | 0 | NULL | n | n | 2020123001 | 5 |
| 6 | 0 | 0 | 0 | 0 | NULL | n | n | 2020123001 | 6 |
| 7 | 0 | 0 | 0 | 0 | NULL | n | n | 2020123002 | 1 |
| 8 | 0 | 0 | 0 | 0 | NULL | n | n | 2020123002 | 2 |
| 9 | 0 | 0 | 0 | 0 | NULL | n | n | 2020123002 | 3 |
| 10 | 0 | 0 | 0 | 0 | NULL | n | n | 2020123002 | 4 |
| 11 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160001 | 1 |
| 12 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160001 | 2 |
| 13 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160001 | 3 |
| 14 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160001 | 4 |
| 15 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160001 | 5 |
| 16 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160001 | 6 |
| 17 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160002 | 1 |
| 18 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160002 | 2 |
| 19 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160002 | 3 |
| 20 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160002 | 4 |
| 21 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160002 | 5 |
| 22 | 0 | 0 | 0 | 0 | NULL | n | n | 2020160002 | 6 |
| 23 | 0 | 0 | 0 | 0 | NULL | n | n | 2020456001 | 1 |
| 24 | 0 | 0 | 0 | 0 | NULL | n | n | 2020456001 | 2 |
| 25 | 0 | 0 | 0 | 0 | NULL | n | n | 2020456001 | 3 |
| 26 | 0 | 0 | 0 | 0 | NULL | n | n | 2020456001 | 4 |
| 27 | 0 | 0 | 0 | 0 | NULL | n | n | 2020456001 | 5 |
+--------+--------+----------+-----------+-------------+----------+---------+---------------+------------+-----------+
27 rows in set (0.00 sec)