데이터베이스 인스턴스 생성

 

인스턴스 생성 규칙

course 과목 테이블
cnum 과목번호는 2자리, 학년, 반, 강의번호로 구성된다.
학년은 1-3까지, 반은 1-2반이 있다.
cname 과목명은 한글 2자리
hrs와 credit은 실제 과목의 시수와 학점에 따라 부여한다.
한 학년 당 3개의 과목이 개설된다.
과목 3 * 학년 3 * 반 2 = 18
학과가 5개이니 18 * 5 = 90

department 학과 테이블
dnum 학과번호는 정수형 숫자 2자리이다. 총 5개의 학과가 있으며, 아래와 같이 설정해 주었다.
스아 22
식영 11
산디 34
실중 56
세무 58
dname 학과명은 한글 2자리
dphone 학과연락처는 실제 연락처의 뒷자리를 사용했다.
dloc 학과위치는 건물번호 2자리, 층, 방번호 2자리로 구성된다.

professor 교수 테이블
pnum 교수번호는 pphone과 같게 한다.
pname 교수이름 한글로 설정한다.
ppos 호봉이다. 1호봉이 가장 높으며 호봉이 높아질수록 교수의 직급이 낮다. 1은 정교수이고, 2는 부교수, 3은 조교수 등으로 설정했다.
pphone 교수 연구실 연락처의 뒷자리이다.
belong 학과번호이다. department 테이블의 dnum을 외래키로 참조.
교수 수
2년제는 학년 2 * ? * 과목 수 2 = 6
3년제는 학년 3 * ? * 과목 수 3 = 9

student 학생 테이블
snum 학번은 입학년도 2자리, 학과번호 2자리, 반, 개인번호 2자리로 구성된다.
sname 한글로 설정한다.
year 학년
qpa 학점이다. 학생의 과목 점수에 맞춰 3과목의 평균 qpa를 입력해 주었다.
major 학과번호이다. department 테이블의 dnum을 외래키로 참조.
advise 교수번호이다. professor 테이블의 pnum을 외래키로 참조.
학생 수
2년제는 학년 2 * 반 2 * 한 반의 학생 수 3 = 12
3년제는 학년 3 * 반 2 * 한 반의 학생 수 3 = 18

enrol 수강 테이블
cnum 과목번호이다. course 테이블의 cnum을 외래키로 참조.
snum 학번이다. student 테이블의 snum을 외래키로 참조.
grade 점수는 0-100 사이의 수이다.
cnum과 snum이 기본키로 설정된다.

lecture 강의 테이블
cnum 과목번호이다. course 테이블의 cnum을 외래키로 참조.
pnum 교수번호이다. professor 테이블의 pnum을 외래키로 참조.
room 강의실은 건물번호 2자리, 방번호 3자리로 구성된다. 방번호는 앞자리는 0으로 설정해 두었으며 두 번째는 층, 세 번째는 랜덤 부여했다.
time 강의 시간은 요일 1자리, 강의 시작 시간 1자리로 구성된다. 월요일은 1, 화요일은 2, ... 금요일은 5이다. 겅의 시작 시간은 9시가 1, 10시가 2, ... 14시가 6이다. 강의실과 강의 시간이 겹치지 않도록 인스턴스를 생성해야 한다.
cnum과 snum이 기본키로 설정된다.

---

데이터베이스 생성부터 인스턴스 삽입까지의 실행 코드이다.

/* 이름: demo_univ.sql */

/* 설명 */

/* root 계정으로 접속, univ 데이터베이스 생성, univ 계정 생성 */

/* MySQL Workbench에서 초기화면에서 +를 눌러 root connection을 만들어 접속한다. */

DROP DATABASE IF EXISTS  univ;

DROP USER IF EXISTS  univ@localhost;

create user univ@localhost identified WITH mysql_native_password  by 'univ';

create database univ;

grant all privileges on univ .* to univ@localhost with grant option;

commit;


/* univ DB 자료 생성 */

/* 이후 실습은 MySQL Workbench에서 초기화면에서 +를 눌러 univ connection을 만들어 접속하여 사용한다. */


USE univ;


CREATE TABLE course(
cnum INTEGER(5) PRIMARY KEY,
cname VARCHAR(12) NOT NULL,
hrs INTEGER(1),
credit INTEGER(1));

CREATE TABLE department(
dnum INTEGER(2) PRIMARY KEY,
dname VARCHAR(12) NOT NULL,
dphone INTEGER(4),
dloc INTEGER(5));

CREATE TABLE professor(
pnum INTEGER(4) PRIMARY KEY,
pname VARCHAR(12) NOT NULL,
ppos INTEGER(2),
pphone INTEGER(4),
belong INTEGER(2),
FOREIGN KEY (belong) REFERENCES department(dnum) ON DELETE CASCADE);

CREATE TABLE student(
snum INTEGER(7) PRIMARY KEY,
sname VARCHAR(12) NOT NULL,
year INTEGER(1),
qpa decimal(3,2) CHECK (qpa BETWEEN 0.0 AND 4.5),
major INTEGER(2),
advise INTEGER(4),
FOREIGN KEY (major) REFERENCES department(dnum) ON DELETE CASCADE,
FOREIGN KEY (advise) REFERENCES professor(pnum) ON DELETE CASCADE);

INSERT INTO course VALUES(22111, '웹저', 3, 3);
INSERT INTO course VALUES(22112, '데분', 3, 3);
INSERT INTO course VALUES(22113, '창의', 2, 2);
INSERT INTO course VALUES(22214, '자료', 3, 3);
INSERT INTO course VALUES(22215, '증강', 3, 3);
INSERT INTO course VALUES(22216, '데베', 3, 3);
INSERT INTO course VALUES(22317, '인공', 3, 3);
INSERT INTO course VALUES(22318, '자바', 3, 3);
INSERT INTO course VALUES(22319, '빅데', 3, 3);
INSERT INTO course VALUES(22121, '웹저', 3, 3);
INSERT INTO course VALUES(22122, '데분', 3, 3);
INSERT INTO course VALUES(22123, '창의', 2, 2);
INSERT INTO course VALUES(22224, '자료', 3, 3);
INSERT INTO course VALUES(22225, '증강', 3, 3);
INSERT INTO course VALUES(22226, '데베', 3, 3);
INSERT INTO course VALUES(22327, '인공', 3, 3);
INSERT INTO course VALUES(22328, '자바', 3, 3);
INSERT INTO course VALUES(22329, '빅데', 3, 3);
INSERT INTO course VALUES(58111, '회계', 3, 3);
INSERT INTO course VALUES(58112, '세법', 3, 3);
INSERT INTO course VALUES(58113, '상법', 2, 2);
INSERT INTO course VALUES(58214, '재무', 2, 2);
INSERT INTO course VALUES(58215, '법인', 3, 3);
INSERT INTO course VALUES(58216, '경영', 3, 3);
INSERT INTO course VALUES(58121, '회계', 3, 3);
INSERT INTO course VALUES(58122, '세법', 3, 3);
INSERT INTO course VALUES(58123, '상법', 2, 2);
INSERT INTO course VALUES(58224, '재무', 2, 2);
INSERT INTO course VALUES(58225, '법인', 3, 3);
INSERT INTO course VALUES(58226, '경영', 3, 3);
INSERT INTO course VALUES(34111, '색채', 3, 3);
INSERT INTO course VALUES(34112, '입체', 3, 3);
INSERT INTO course VALUES(34113, '컴그', 2, 2);
INSERT INTO course VALUES(34214, '패디', 3, 3);
INSERT INTO course VALUES(34215, '창업', 3, 3);
INSERT INTO course VALUES(34216, '캐드', 3, 3);
INSERT INTO course VALUES(34317, '모형', 3, 3);
INSERT INTO course VALUES(34318, '리빙', 3, 3);
INSERT INTO course VALUES(34319, '기획', 3, 3);
INSERT INTO course VALUES(34121, '색채', 3, 3);
INSERT INTO course VALUES(34122, '입체', 3, 3);
INSERT INTO course VALUES(34123, '컴그', 2, 2);
INSERT INTO course VALUES(34224, '패디', 3, 3);
INSERT INTO course VALUES(34225, '창업', 3, 3);
INSERT INTO course VALUES(34226, '캐드', 3, 3);
INSERT INTO course VALUES(34327, '모형', 3, 3);
INSERT INTO course VALUES(34328, '리빙', 3, 3);
INSERT INTO course VALUES(34329, '기획', 3, 3);
INSERT INTO course VALUES(56111, '기문', 3, 3);
INSERT INTO course VALUES(56112, '중문', 3, 3);
INSERT INTO course VALUES(56113, '중학', 3, 3);
INSERT INTO course VALUES(56214, '실중', 3, 3);
INSERT INTO course VALUES(56215, '관중', 3, 3);
INSERT INTO course VALUES(56216, '중번', 2, 2);
INSERT INTO course VALUES(56121, '기문', 3, 3);
INSERT INTO course VALUES(56122, '중문', 3, 3);
INSERT INTO course VALUES(56123, '중학', 3, 3);
INSERT INTO course VALUES(56224, '실중', 3, 3);
INSERT INTO course VALUES(56225, '관중', 3, 3);
INSERT INTO course VALUES(56226, '중번', 2, 2);
INSERT INTO course VALUES(11111, '글디', 3, 3);
INSERT INTO course VALUES(11112, '문화', 2, 2);
INSERT INTO course VALUES(11113, '생물', 3, 3);
INSERT INTO course VALUES(11214, '위생', 3, 3);
INSERT INTO course VALUES(11215, '보건', 3, 3);
INSERT INTO course VALUES(11216, '화학', 2, 2);
INSERT INTO course VALUES(11317, '임상', 3, 3);
INSERT INTO course VALUES(11318, '식법', 3, 3);
INSERT INTO course VALUES(11319, '외식', 2, 2);
INSERT INTO course VALUES(11121, '글디', 3, 3);
INSERT INTO course VALUES(11122, '문화', 2, 2);
INSERT INTO course VALUES(11123, '생물', 3, 3);
INSERT INTO course VALUES(11224, '위생', 3, 3);
INSERT INTO course VALUES(11225, '보건', 3, 3);
INSERT INTO course VALUES(11226, '화학', 2, 2);
INSERT INTO course VALUES(11327, '임상', 3, 3);
INSERT INTO course VALUES(11328, '식법', 3, 3);
INSERT INTO course VALUES(11329, '외식', 2, 2);
INSERT INTO department VALUES(22, "스아", 2380, 30412);
INSERT INTO department VALUES(34, "산디", 2320, 37601);
INSERT INTO department VALUES(58, "세무", 2310, 19419);
INSERT INTO department VALUES(56, "실중", 2250, 19418);
INSERT INTO department VALUES(11, "식영", 2180, 69102);
INSERT INTO professor VALUES(2290, '변의주', 11, 2290, 22);
INSERT INTO professor VALUES(2287, '유승언', 11, 2287, 22);
INSERT INTO professor VALUES(2289, '하루아', 11, 2289, 22);
INSERT INTO professor VALUES(2283, '왕이샹', 22, 2283, 22);
INSERT INTO professor VALUES(2297, '한유진', 22, 2297, 22);
INSERT INTO professor VALUES(2291, '장하오', 22, 2291, 22);
INSERT INTO professor VALUES(2299, '명재현', 33, 2299, 22);
INSERT INTO professor VALUES(2294, '이찬영', 33, 2294, 22);
INSERT INTO professor VALUES(2295, '우서흔', 33, 2295, 22);
INSERT INTO professor VALUES(5813, '위대훈', 11, 5813, 58);
INSERT INTO professor VALUES(5810, '양초월', 11, 5810, 58);
INSERT INTO professor VALUES(5815, '정우혜', 44, 5815, 58);
INSERT INTO professor VALUES(5819, '송위룡', 44, 5819, 58);
INSERT INTO professor VALUES(5817, '주익연', 44, 5817, 58);
INSERT INTO professor VALUES(5816, '맹자의', 44, 5816, 58);
INSERT INTO professor VALUES(5651, '허개', 11, 5651, 56);
INSERT INTO professor VALUES(5655, '진철원', 11, 5655, 56);
INSERT INTO professor VALUES(5654, '조로사', 11, 5654, 56);
INSERT INTO professor VALUES(5657, '전희미', 22, 5657, 56);
INSERT INTO professor VALUES(5652, '장신성', 33, 5652, 56);
INSERT INTO professor VALUES(5659, '백경정', 44, 5659, 56);
INSERT INTO professor VALUES(1185, '담송운', 11, 1185, 11);
INSERT INTO professor VALUES(1181, '이주연', 11, 1181, 11);
INSERT INTO professor VALUES(1182, '이현재', 11, 1182, 11);
INSERT INTO professor VALUES(1183, '박종성', 22, 1183, 11);
INSERT INTO professor VALUES(1192, '박성훈', 33, 1192, 11);
INSERT INTO professor VALUES(1189, '이재현', 33, 1189, 11);
INSERT INTO professor VALUES(1191, '단건차', 33, 1191, 11);
INSERT INTO professor VALUES(1187, '서몽결', 33, 1187, 11);
INSERT INTO professor VALUES(1190, '장묘이', 33, 1190, 11);
INSERT INTO professor VALUES(3426, '왕옥문', 11, 3426, 34);
INSERT INTO professor VALUES(3429, '진비우', 11, 3429, 34);
INSERT INTO professor VALUES(3423, '왕탁성', 11, 3423, 34);
INSERT INTO professor VALUES(3428, '곽승', 22, 3428, 34);
INSERT INTO professor VALUES(3425, '판청청', 33, 3425, 34);
INSERT INTO professor VALUES(3422, '장정의', 33, 3422, 34);
INSERT INTO professor VALUES(3424, '김승민', 44, 3424, 34);
INSERT INTO professor VALUES(3421, '임영웅', 44, 3421, 34);
INSERT INTO professor VALUES(3427, '이찬원', 44, 3427, 34);
INSERT INTO student VALUES(2322109, '김은서', 1, 4.3, 22, 2290);
INSERT INTO student VALUES(2322101, '권순영', 1, 4.5, 22, 2290);
INSERT INTO student VALUES(2322175, '허채민', 1, 3.1, 22, 2290);
INSERT INTO student VALUES(2322210, '김지호', 1, 2.6, 22, 2287);
INSERT INTO student VALUES(2322207, '김유빈', 1, 4.0, 22, 2287);
INSERT INTO student VALUES(2322241, '유지민', 1, 1.8, 22, 2287);
INSERT INTO student VALUES(2222133, '이민정', 2, 3.0, 22, 2289);
INSERT INTO student VALUES(2222150, '하지원', 2, 4.0, 22, 2289);
INSERT INTO student VALUES(2222128, '박은비', 2, 3.5, 22, 2289);
INSERT INTO student VALUES(2222210, '김윤아', 2, 4.1, 22, 2283);
INSERT INTO student VALUES(2222230, '박하늘', 2, 3.8, 22, 2283);
INSERT INTO student VALUES(2222253, '함소희', 2, 3.0, 22, 2283);
INSERT INTO student VALUES(2122164, '황수연', 3, 2.1, 22, 2297);
INSERT INTO student VALUES(2122102, '강민지', 3, 3.8, 22, 2297);
INSERT INTO student VALUES(2122151, '조윤재', 3, 4.0, 22, 2297);
INSERT INTO student VALUES(2122235, '안혜민', 3, 2.8, 22, 2291);
INSERT INTO student VALUES(2122259, '최다영', 3, 3.8, 22, 2291);
INSERT INTO student VALUES(2122249, '장시연', 3, 4.5, 22, 2291);
INSERT INTO student VALUES(2311135, '백아영', 1, 4.1, 11, 1185);
INSERT INTO student VALUES(2311147, '조아라', 1, 4.0, 11, 1185);
INSERT INTO student VALUES(2311139, '윤다희', 1, 3.4, 11, 1185);
INSERT INTO student VALUES(2311242, '이승미', 1, 1.9, 11, 1181);
INSERT INTO student VALUES(2311250, '한은진', 1, 3.8, 11, 1181);
INSERT INTO student VALUES(2311230, '박윤지', 1, 2.9, 11, 1181);
INSERT INTO student VALUES(2211150, '최지우', 2, 4.1, 11, 1182);
INSERT INTO student VALUES(2211167, '황규진', 2, 3.5, 11, 1182);
INSERT INTO student VALUES(2211164, '함은정', 2, 2.6, 11, 1182);
INSERT INTO student VALUES(2211237, '박채령', 2, 1.7, 11, 1183);
INSERT INTO student VALUES(2211214, '강영현', 2, 4.2, 11, 1183);
INSERT INTO student VALUES(2211243, '신예은', 2, 4.5, 11, 1183);
INSERT INTO student VALUES(2111136, '임다솜', 3, 2.8, 11, 1192);
INSERT INTO student VALUES(2111171, '조희나', 3, 3.1, 11, 1192);
INSERT INTO student VALUES(2111130, '문가영', 3, 4.2, 11, 1192);
INSERT INTO student VALUES(2111234, '이다인', 3, 3.7, 11, 1189);
INSERT INTO student VALUES(2111274, '한서진', 3, 3.6, 11, 1189);
INSERT INTO student VALUES(2111232, '윤지수', 3, 4.5, 11, 1189);
INSERT INTO student VALUES(2334177, '허윤진', 1, 2.3, 34, 3426);
INSERT INTO student VALUES(2334103, '강효민', 1, 3.5, 34, 3426);
INSERT INTO student VALUES(2334139, '이수빈', 1, 2.6, 34, 3426);
INSERT INTO student VALUES(2334241, '이예인', 1, 4.0, 34, 3429);
INSERT INTO student VALUES(2334227, '박예린', 1, 3.6, 34, 3429);
INSERT INTO student VALUES(2334211, '김가을', 1, 1.8, 34, 3429);
INSERT INTO student VALUES(2234138, '심효원', 2, 4.3, 34, 3423);
INSERT INTO student VALUES(2234145, '유채영', 2, 1.1, 34, 3423);
INSERT INTO student VALUES(2234101, '권유민', 2, 2.8, 34, 3423);
INSERT INTO student VALUES(2234235, '송소이', 2, 3.8, 34, 3428);
INSERT INTO student VALUES(2234243, '양혜연', 2, 2.8, 34, 3428);
INSERT INTO student VALUES(2234255, '전민아', 2, 3.0, 34, 3428);
INSERT INTO student VALUES(2134126, '배진솔', 3, 4.1, 34, 3425);
INSERT INTO student VALUES(2134159, '조혜원', 3, 1.5, 34, 3425);
INSERT INTO student VALUES(2134153, '임아리', 3, 2.6, 34, 3425);
INSERT INTO student VALUES(2134266, '최다빈', 3, 3.3, 34, 3422);
INSERT INTO student VALUES(2134248, '안혜영', 3, 4.3, 34, 3422);
INSERT INTO student VALUES(2134256, '정소영', 3, 3.0, 34, 3422);
INSERT INTO student VALUES(2356102, '김나연', 1, 4.0, 56, 5651);
INSERT INTO student VALUES(2356135, '박다현', 1, 3.6, 56, 5651);
INSERT INTO student VALUES(2356144, '신정연', 1, 2.1, 56, 5651);
INSERT INTO student VALUES(2356229, '문진아', 1, 3.2, 56, 5655);
INSERT INTO student VALUES(2356242, '손수빈', 1, 2.8, 56, 5655);
INSERT INTO student VALUES(2356253, '이경민', 1, 1.6, 56, 5655);
INSERT INTO student VALUES(2256150, '주익연', 2, 4.2, 56, 5654);
INSERT INTO student VALUES(2256101, '강지남', 2, 2.4, 56, 5654);
INSERT INTO student VALUES(2256105, '김연수', 2, 3.4, 56, 5654);
INSERT INTO student VALUES(2256237, '박이신', 2, 1.3, 56, 5657);
INSERT INTO student VALUES(2256246, '조로사', 2, 3.9, 56, 5657);
INSERT INTO student VALUES(2256242, '장정의', 2, 3.7, 56, 5657);
INSERT INTO student VALUES(2358163, '조윤희', 1, 1.8, 58, 5813);
INSERT INTO student VALUES(2358141, '송연아', 1, 4.1, 58, 5813);
INSERT INTO student VALUES(2358179, '최서연', 1, 2.5, 58, 5813);
INSERT INTO student VALUES(2358256, '정하람', 1, 1.1, 58, 5810);
INSERT INTO student VALUES(2358236, '백혜린', 1, 3.4, 58, 5810);
INSERT INTO student VALUES(2358228, '배수민', 1, 3.7, 58, 5810);
INSERT INTO student VALUES(2258139, '오예리', 2, 4.3, 58, 5815);
INSERT INTO student VALUES(2258133, '안주현', 2, 3.6, 58, 5815);
INSERT INTO student VALUES(2258152, '조은주', 2, 2.7, 58, 5815);
INSERT INTO student VALUES(2258268, '최지원', 2, 3.2, 58, 5819);
INSERT INTO student VALUES(2258222, '문재경', 2, 4.2, 58, 5819);
INSERT INTO student VALUES(2258231, '신서영', 2, 1.8, 58, 5819);


CREATE TABLE enrol (
cnum INTEGER NOT NULL,
snum INTEGER NOT NULL,
grade INTEGER CHECK (grade BETWEEN 0 AND 100),
primary key (cnum, snum),
foreign key(cnum) REFERENCES course(cnum) on delete cascade,
foreign key(snum) REFERENCES student(snum) on delete cascade);

CREATE TABLE lecture (
cnum INTEGER NOT NULL,
pnum INTEGER NOT NULL,
room INTEGER(5),
time INTEGER(2),
primary key (cnum, pnum),
foreign key(cnum) REFERENCES course(cnum) on delete cascade,
foreign key(pnum) REFERENCES professor(pnum) on delete cascade);

-- 스아
INSERT INTO enrol VALUES(22111, 2322109, 91);
INSERT INTO enrol VALUES(22112, 2322109, 95);
INSERT INTO enrol VALUES(22113, 2322109, 99);
INSERT INTO enrol VALUES(22111, 2322101, 95);
INSERT INTO enrol VALUES(22112, 2322101, 98);
INSERT INTO enrol VALUES(22113, 2322101, 96);
INSERT INTO enrol VALUES(22111, 2322175, 74);
INSERT INTO enrol VALUES(22112, 2322175, 96);
INSERT INTO enrol VALUES(22113, 2322175, 83);
INSERT INTO enrol VALUES(22121, 2322210, 72);
INSERT INTO enrol VALUES(22122, 2322210, 95);
INSERT INTO enrol VALUES(22123, 2322210, 69);
INSERT INTO enrol VALUES(22121, 2322207, 86);
INSERT INTO enrol VALUES(22122, 2322207, 90);
INSERT INTO enrol VALUES(22123, 2322207, 98);
INSERT INTO enrol VALUES(22121, 2322241, 68);
INSERT INTO enrol VALUES(22122, 2322241, 75);
INSERT INTO enrol VALUES(22123, 2322241, 65);
INSERT INTO enrol VALUES(22214, 2222133, 84);
INSERT INTO enrol VALUES(22215, 2222133, 89);
INSERT INTO enrol VALUES(22216, 2222133, 76);
INSERT INTO enrol VALUES(22214, 2222150, 90);
INSERT INTO enrol VALUES(22215, 2222150, 92);
INSERT INTO enrol VALUES(22216, 2222150, 93);
INSERT INTO enrol VALUES(22214, 2222128, 85);
INSERT INTO enrol VALUES(22215, 2222128, 90);
INSERT INTO enrol VALUES(22216, 2222128, 84);
INSERT INTO enrol VALUES(22224, 2222210, 94);
INSERT INTO enrol VALUES(22225, 2222210, 98);
INSERT INTO enrol VALUES(22226, 2222210, 93);
INSERT INTO enrol VALUES(22224, 2222230, 83);
INSERT INTO enrol VALUES(22225, 2222230, 96);
INSERT INTO enrol VALUES(22226, 2222230, 90);
INSERT INTO enrol VALUES(22224, 2222253, 82);
INSERT INTO enrol VALUES(22225, 2222253, 77);
INSERT INTO enrol VALUES(22226, 2222253, 87);
INSERT INTO enrol VALUES(22317, 2122164, 80);
INSERT INTO enrol VALUES(22318, 2122164, 78);
INSERT INTO enrol VALUES(22319, 2122164, 64);
INSERT INTO enrol VALUES(22317, 2122102, 85);
INSERT INTO enrol VALUES(22318, 2122102, 100);
INSERT INTO enrol VALUES(22319, 2122102, 86);
INSERT INTO enrol VALUES(22317, 2122151, 99);
INSERT INTO enrol VALUES(22318, 2122151, 84);
INSERT INTO enrol VALUES(22319, 2122151, 95);
INSERT INTO enrol VALUES(22327, 2122235, 70);
INSERT INTO enrol VALUES(22328, 2122235, 83);
INSERT INTO enrol VALUES(22329, 2122235, 89);
INSERT INTO enrol VALUES(22327, 2122259, 88);
INSERT INTO enrol VALUES(22328, 2122259, 96);
INSERT INTO enrol VALUES(22329, 2122259, 89);
INSERT INTO enrol VALUES(22327, 2122249, 100);
INSERT INTO enrol VALUES(22328, 2122249, 96);
INSERT INTO enrol VALUES(22329, 2122249, 95);
-- 산디
INSERT INTO enrol VALUES(34111, 2334177, 78);
INSERT INTO enrol VALUES(34112, 2334177, 74);
INSERT INTO enrol VALUES(34113, 2334177, 79);
INSERT INTO enrol VALUES(34111, 2334103, 95);
INSERT INTO enrol VALUES(34112, 2334103, 86);
INSERT INTO enrol VALUES(34113, 2334103, 79);
INSERT INTO enrol VALUES(34111, 2334139, 74);
INSERT INTO enrol VALUES(34112, 2334139, 87);
INSERT INTO enrol VALUES(34113, 2334139, 76);
INSERT INTO enrol VALUES(34121, 2334241, 94);
INSERT INTO enrol VALUES(34122, 2334241, 90);
INSERT INTO enrol VALUES(34123, 2334241, 92);
INSERT INTO enrol VALUES(34121, 2334227, 90);
INSERT INTO enrol VALUES(34122, 2334227, 79);
INSERT INTO enrol VALUES(34123, 2334227, 95);
INSERT INTO enrol VALUES(34121, 2334211, 64);
INSERT INTO enrol VALUES(34122, 2334211, 73);
INSERT INTO enrol VALUES(34123, 2334211, 79);
INSERT INTO enrol VALUES(34214, 2234138, 97);
INSERT INTO enrol VALUES(34215, 2234138, 96);
INSERT INTO enrol VALUES(34216, 2234138, 92);
INSERT INTO enrol VALUES(34214, 2234145, 65);
INSERT INTO enrol VALUES(34215, 2234145, 60);
INSERT INTO enrol VALUES(34216, 2234145, 61);
INSERT INTO enrol VALUES(34214, 2234101, 76);
INSERT INTO enrol VALUES(34215, 2234101, 84);
INSERT INTO enrol VALUES(34216, 2234101, 84);
INSERT INTO enrol VALUES(34224, 2234235, 100);
INSERT INTO enrol VALUES(34225, 2234235, 94);
INSERT INTO enrol VALUES(34226, 2234235, 84);
INSERT INTO enrol VALUES(34224, 2234243, 89);
INSERT INTO enrol VALUES(34225, 2234243, 76);
INSERT INTO enrol VALUES(34226, 2234243, 79);
INSERT INTO enrol VALUES(34224, 2234255, 84);
INSERT INTO enrol VALUES(34225, 2234255, 82);
INSERT INTO enrol VALUES(34226, 2234255, 81);
INSERT INTO enrol VALUES(34317, 2134126, 92);
INSERT INTO enrol VALUES(34318, 2134126, 90);
INSERT INTO enrol VALUES(34319, 2134126, 93);
INSERT INTO enrol VALUES(34317, 2134159, 88);
INSERT INTO enrol VALUES(34318, 2134159, 71);
INSERT INTO enrol VALUES(34319, 2134159, 81);
INSERT INTO enrol VALUES(34317, 2134153, 85);
INSERT INTO enrol VALUES(34318, 2134153, 86);
INSERT INTO enrol VALUES(34319, 2134153, 94);
INSERT INTO enrol VALUES(34327, 2134266, 89);
INSERT INTO enrol VALUES(34328, 2134266, 72);
INSERT INTO enrol VALUES(34329, 2134266, 97);
INSERT INTO enrol VALUES(34327, 2134248, 100);
INSERT INTO enrol VALUES(34328, 2134248, 94);
INSERT INTO enrol VALUES(34329, 2134248, 98);
INSERT INTO enrol VALUES(34327, 2134256, 93);
INSERT INTO enrol VALUES(34328, 2134256, 90);
INSERT INTO enrol VALUES(34329, 2134256, 62);
-- 식영
INSERT INTO enrol VALUES(11111, 2311135, 98);
INSERT INTO enrol VALUES(11112, 2311135, 93);
INSERT INTO enrol VALUES(11113, 2311135, 94);
INSERT INTO enrol VALUES(11111, 2311147, 90);
INSERT INTO enrol VALUES(11112, 2311147, 92);
INSERT INTO enrol VALUES(11113, 2311147, 93);
INSERT INTO enrol VALUES(11111, 2311139, 85);
INSERT INTO enrol VALUES(11112, 2311139, 90);
INSERT INTO enrol VALUES(11113, 2311139, 82);
INSERT INTO enrol VALUES(11121, 2311242, 69);
INSERT INTO enrol VALUES(11122, 2311242, 76);
INSERT INTO enrol VALUES(11123, 2311242, 70);
INSERT INTO enrol VALUES(11121, 2311250, 83);
INSERT INTO enrol VALUES(11122, 2311250, 90);
INSERT INTO enrol VALUES(11123, 2311250, 96);
INSERT INTO enrol VALUES(11121, 2311230, 90);
INSERT INTO enrol VALUES(11122, 2311230, 72);
INSERT INTO enrol VALUES(11123, 2311230, 78);
INSERT INTO enrol VALUES(11214, 2211150, 93);
INSERT INTO enrol VALUES(11215, 2211150, 92);
INSERT INTO enrol VALUES(11216, 2211150, 95);
INSERT INTO enrol VALUES(11214, 2211167, 90);
INSERT INTO enrol VALUES(11215, 2211167, 91);
INSERT INTO enrol VALUES(11216, 2211167, 73);
INSERT INTO enrol VALUES(11214, 2211164, 69);
INSERT INTO enrol VALUES(11215, 2211164, 75);
INSERT INTO enrol VALUES(11216, 2211164, 90);
INSERT INTO enrol VALUES(11224, 2211237, 65);
INSERT INTO enrol VALUES(11225, 2211237, 75);
INSERT INTO enrol VALUES(11226, 2211237, 62);
INSERT INTO enrol VALUES(11224, 2211214, 95);
INSERT INTO enrol VALUES(11225, 2211214, 98);
INSERT INTO enrol VALUES(11226, 2211214, 89);
INSERT INTO enrol VALUES(11224, 2211243, 100);
INSERT INTO enrol VALUES(11225, 2211243, 98);
INSERT INTO enrol VALUES(11226, 2211243, 95);
INSERT INTO enrol VALUES(11317, 2111136, 71);
INSERT INTO enrol VALUES(11318, 2111136, 89);
INSERT INTO enrol VALUES(11319, 2111136, 83);
INSERT INTO enrol VALUES(11317, 2111171, 75);
INSERT INTO enrol VALUES(11318, 2111171, 94);
INSERT INTO enrol VALUES(11319, 2111171, 83);
INSERT INTO enrol VALUES(11317, 2111130, 97);
INSERT INTO enrol VALUES(11318, 2111130, 96);
INSERT INTO enrol VALUES(11319, 2111130, 89);
INSERT INTO enrol VALUES(11327, 2111234, 98);
INSERT INTO enrol VALUES(11328, 2111234, 87);
INSERT INTO enrol VALUES(11329, 2111234, 83);
INSERT INTO enrol VALUES(11327, 2111274, 87);
INSERT INTO enrol VALUES(11328, 2111274, 89);
INSERT INTO enrol VALUES(11329, 2111274, 96);
INSERT INTO enrol VALUES(11327, 2111232, 97);
INSERT INTO enrol VALUES(11328, 2111232, 98);
INSERT INTO enrol VALUES(11329, 2111232, 100);
-- 실중
INSERT INTO enrol VALUES(56111, 2356102, 90);
INSERT INTO enrol VALUES(56112, 2356102, 92);
INSERT INTO enrol VALUES(56113, 2356102, 91);
INSERT INTO enrol VALUES(56111, 2356135, 85);
INSERT INTO enrol VALUES(56112, 2356135, 90);
INSERT INTO enrol VALUES(56113, 2356135, 86);
INSERT INTO enrol VALUES(56111, 2356144, 70);
INSERT INTO enrol VALUES(56112, 2356144, 75);
INSERT INTO enrol VALUES(56113, 2356144, 72);
INSERT INTO enrol VALUES(56121, 2356229, 88);
INSERT INTO enrol VALUES(56122, 2356229, 92);
INSERT INTO enrol VALUES(56123, 2356229, 72);
INSERT INTO enrol VALUES(56121, 2356242, 76);
INSERT INTO enrol VALUES(56122, 2356242, 91);
INSERT INTO enrol VALUES(56123, 2356242, 72);
INSERT INTO enrol VALUES(56121, 2356253, 70);
INSERT INTO enrol VALUES(56122, 2356253, 66);
INSERT INTO enrol VALUES(56123, 2356253, 68);
INSERT INTO enrol VALUES(56214, 2256150, 95);
INSERT INTO enrol VALUES(56215, 2256150, 95);
INSERT INTO enrol VALUES(56216, 2256150, 89);
INSERT INTO enrol VALUES(56214, 2256101, 75);
INSERT INTO enrol VALUES(56215, 2256101, 72);
INSERT INTO enrol VALUES(56216, 2256101, 76);
INSERT INTO enrol VALUES(56214, 2256105, 90);
INSERT INTO enrol VALUES(56215, 2256105, 84);
INSERT INTO enrol VALUES(56216, 2256105, 82);
INSERT INTO enrol VALUES(56224, 2256237, 65);
INSERT INTO enrol VALUES(56225, 2256237, 62);
INSERT INTO enrol VALUES(56226, 2256237, 65);
INSERT INTO enrol VALUES(56224, 2256246, 89);
INSERT INTO enrol VALUES(56225, 2256246, 94);
INSERT INTO enrol VALUES(56226, 2256246, 94);
INSERT INTO enrol VALUES(56224, 2256242, 89);
INSERT INTO enrol VALUES(56225, 2256242, 83);
INSERT INTO enrol VALUES(56226, 2256242, 95);
-- 세무
INSERT INTO enrol VALUES(58111, 2358163, 69);
INSERT INTO enrol VALUES(58112, 2358163, 71);
INSERT INTO enrol VALUES(58113, 2358163, 74);
INSERT INTO enrol VALUES(58111, 2358141, 97);
INSERT INTO enrol VALUES(58112, 2358141, 93);
INSERT INTO enrol VALUES(58113, 2358141, 90);
INSERT INTO enrol VALUES(58111, 2358179, 78);
INSERT INTO enrol VALUES(58112, 2358179, 79);
INSERT INTO enrol VALUES(58113, 2358179, 76);
INSERT INTO enrol VALUES(58121, 2358256, 63);
INSERT INTO enrol VALUES(58122, 2358256, 67);
INSERT INTO enrol VALUES(58123, 2358256, 60);
INSERT INTO enrol VALUES(58121, 2358236, 86);
INSERT INTO enrol VALUES(58122, 2358236, 90);
INSERT INTO enrol VALUES(58123, 2358236, 78);
INSERT INTO enrol VALUES(58121, 2358228, 96);
INSERT INTO enrol VALUES(58122, 2358228, 87);
INSERT INTO enrol VALUES(58123, 2358228, 82);
INSERT INTO enrol VALUES(58214, 2258139, 87);
INSERT INTO enrol VALUES(58215, 2258139, 95);
INSERT INTO enrol VALUES(58216, 2258139, 98);
INSERT INTO enrol VALUES(58214, 2258133, 87);
INSERT INTO enrol VALUES(58215, 2258133, 88);
INSERT INTO enrol VALUES(58216, 2258133, 90);
INSERT INTO enrol VALUES(58214, 2258152, 88);
INSERT INTO enrol VALUES(58215, 2258152, 76);
INSERT INTO enrol VALUES(58216, 2258152, 78);
INSERT INTO enrol VALUES(58224, 2258268, 91);
INSERT INTO enrol VALUES(58225, 2258268, 87);
INSERT INTO enrol VALUES(58226, 2258268, 77);
INSERT INTO enrol VALUES(58224, 2258222, 89);
INSERT INTO enrol VALUES(58225, 2258222, 96);
INSERT INTO enrol VALUES(58226, 2258222, 98);
INSERT INTO enrol VALUES(58224, 2258231, 67);
INSERT INTO enrol VALUES(58225, 2258231, 78);
INSERT INTO enrol VALUES(58226, 2258231, 69);
-- 스아
INSERT INTO lecture VALUES(22111, 2295, 30041, 12);
INSERT INTO lecture VALUES(22121, 2295, 30041, 16);
INSERT INTO lecture VALUES(22112, 2289, 30052, 21);
INSERT INTO lecture VALUES(22122, 2289, 30052, 25);
INSERT INTO lecture VALUES(22113, 2297, 30051, 16);
INSERT INTO lecture VALUES(22123, 2297, 30051, 12);
INSERT INTO lecture VALUES(22214, 2294, 30023, 32);
INSERT INTO lecture VALUES(22224, 2294, 30023, 36);
INSERT INTO lecture VALUES(22215, 2291, 30041, 36);
INSERT INTO lecture VALUES(22225, 2291, 30041, 32);
INSERT INTO lecture VALUES(22216, 2287, 30023, 42);
INSERT INTO lecture VALUES(22226, 2287, 30023, 46);
INSERT INTO lecture VALUES(22317, 2283, 30031, 52);
INSERT INTO lecture VALUES(22327, 2283, 30031, 56);
INSERT INTO lecture VALUES(22318, 2299, 30042, 42);
INSERT INTO lecture VALUES(22328, 2299, 30042, 46);
INSERT INTO lecture VALUES(22319, 2290, 30043, 46);
INSERT INTO lecture VALUES(22329, 2290, 30043, 42);
-- 산디
INSERT INTO lecture VALUES(34111, 3426, 37041, 12);
INSERT INTO lecture VALUES(34121, 3426, 37041, 16);
INSERT INTO lecture VALUES(34112, 3425, 37054, 32);
INSERT INTO lecture VALUES(34122, 3425, 37504, 36);
INSERT INTO lecture VALUES(34113, 3422, 37053, 36);
INSERT INTO lecture VALUES(34123, 3422, 37053, 31);
INSERT INTO lecture VALUES(34214, 3424, 37032, 16);
INSERT INTO lecture VALUES(34224, 3424, 37032, 12);
INSERT INTO lecture VALUES(34215, 3427, 37021, 42);
INSERT INTO lecture VALUES(34225, 3427, 37021, 46);
INSERT INTO lecture VALUES(34216, 3429, 37041, 51);
INSERT INTO lecture VALUES(34226, 3429, 37041, 56);
INSERT INTO lecture VALUES(34317, 3421, 37051, 22);
INSERT INTO lecture VALUES(34327, 3421, 37051, 26);
INSERT INTO lecture VALUES(34318, 3423, 37024, 26);
INSERT INTO lecture VALUES(34328, 3423, 37024, 22);
INSERT INTO lecture VALUES(34319, 3428, 37023, 56);
INSERT INTO lecture VALUES(34329, 3428, 37023, 52);
-- 식영
INSERT INTO lecture VALUES(11111, 1185, 69022, 32);
INSERT INTO lecture VALUES(11121, 1185, 69022, 36);
INSERT INTO lecture VALUES(11112, 1181, 69023, 42);
INSERT INTO lecture VALUES(11122, 1181, 69023, 46);
INSERT INTO lecture VALUES(11113, 1182, 69024, 52);
INSERT INTO lecture VALUES(11123, 1182, 69024, 56);
INSERT INTO lecture VALUES(11214, 1183, 69032, 12);
INSERT INTO lecture VALUES(11224, 1183, 69032, 16);
INSERT INTO lecture VALUES(11215, 1192, 69033, 22);
INSERT INTO lecture VALUES(11225, 1192, 69033, 26);
INSERT INTO lecture VALUES(11216, 1189, 69034, 32);
INSERT INTO lecture VALUES(11226, 1189, 69034, 36);
INSERT INTO lecture VALUES(11317, 1191, 69041, 12);
INSERT INTO lecture VALUES(11327, 1191, 69041, 16);
INSERT INTO lecture VALUES(11318, 1187, 69042, 32);
INSERT INTO lecture VALUES(11328, 1187, 69042, 36);
INSERT INTO lecture VALUES(11319, 1190, 69043, 52);
INSERT INTO lecture VALUES(11329, 1190, 69043, 56);
-- 실중
INSERT INTO lecture VALUES(56111, 5651, 19421, 12);
INSERT INTO lecture VALUES(56121, 5651, 19421, 32);
INSERT INTO lecture VALUES(56112, 5655, 19420, 32);
INSERT INTO lecture VALUES(56122, 5655, 19420, 12);
INSERT INTO lecture VALUES(56113, 5654, 19423, 22);
INSERT INTO lecture VALUES(56123, 5654, 19423, 26);
INSERT INTO lecture VALUES(56214, 5657, 19425, 32);
INSERT INTO lecture VALUES(56224, 5657, 19425, 16);
INSERT INTO lecture VALUES(56215, 5652, 19421, 22);
INSERT INTO lecture VALUES(56225, 5652, 19421, 26);
INSERT INTO lecture VALUES(56216, 5659, 19420, 46);
INSERT INTO lecture VALUES(56226, 5659, 19420, 42);
-- 세무
INSERT INTO lecture VALUES(58111, 5813, 19022, 12);
INSERT INTO lecture VALUES(58121, 5813, 19022, 16);
INSERT INTO lecture VALUES(58112, 5810, 19023, 26);
INSERT INTO lecture VALUES(58122, 5810, 19023, 22);
INSERT INTO lecture VALUES(58113, 5815, 19024, 32);
INSERT INTO lecture VALUES(58123, 5815, 19024, 36);
INSERT INTO lecture VALUES(58214, 5819, 19032, 12);
INSERT INTO lecture VALUES(58224, 5819, 19032, 16);
INSERT INTO lecture VALUES(58215, 5817, 19033, 22);
INSERT INTO lecture VALUES(58225, 5817, 19033, 26);
INSERT INTO lecture VALUES(58216, 5816, 19034, 32);
INSERT INTO lecture VALUES(58226, 5816, 19034, 36);
commit;