#DEPARTMENT ÀÔ·Â
INSERT INTO DEPARTMENT VALUES
	(10,'°£È£Çаú','Dept. of Nersing','1954-02-01');

INSERT INTO DEPARTMENT VALUES
	(20,'°æ¿µÇаú','Dept. of Management','1980-02-10');

INSERT INTO DEPARTMENT VALUES
	(30,'¼öÇÐÇаú','Dept. of Mathematics','1984-02-20');

INSERT INTO DEPARTMENT VALUES
	(40,'ÄÄÇ»ÅÍÁ¤º¸Çаú','Dept. of Computer Information','1995-02-01');

INSERT INTO DEPARTMENT VALUES
	(50,'Á¤º¸Åë½ÅÇаú','Dept. of Information Communication','1997-02-10');

INSERT INTO DEPARTMENT VALUES
	(60,'ȸ°èÇаú','Dept. of Accounting','1998-03-01');

#POST ÀÔ·Â
INSERT INTO POST VALUES
        ('556-820', 'È­¾ç¸é', 'Àü¶ó³²µµ ¿©¼ö½Ã È­¾ç¸é', '061');

INSERT INTO POST VALUES
        ('135-900', '¾Ð±¸Á¤µ¿', '¼­¿ïƯº°½Ã °­³²±¸ ¾Ð±¸Á¤µ¿', '02');

INSERT INTO POST VALUES
        ('451-800', 'ÆؼºÀ¾', '°æ±âµµ ÆòÅýà ÆؼºÀ¾', '031');

INSERT INTO POST VALUES
        ('545-800', '±¤¾çÀ¾', 'Àü¶÷³²µµ ±¤¾ç½Ã ±¤¾çÀ¾', '061');

INSERT INTO POST VALUES
        ('135-794', '¾Ð±¸Á¤µ¿', '¼­¿ïƯº°½Ã °­³²±¸ ¾Ð±¸Á¤µ¿ ÇѾç¾ÆÆÄÆ®', '02');

INSERT INTO POST VALUES
        ('550-130', '¼­±³µ¿', 'Àü¶ó³²µµ ¿©¼ö½Ã ¼­±³µ¿', '061');

INSERT INTO POST VALUES
        ('150-051', '½Å±æ1µ¿', '¼­¿ïƯº°½Ã ¿µµîÆ÷±¸ ½Å±æ1µ¿', '02');

INSERT INTO POST VALUES
        ('500-170', '¿î¾Ïµ¿', '±¤ÁÖ±¤¿ª½Ã ºÏ±¸ ¿î¾Ïµ¿', '062');

INSERT INTO POST VALUES
        ('506-040', '¼ÒÃ̵¿', '±¤ÁÖ±¤¿ª½Ã ±¤»ê±¸ ¼ÒÃ̵¿', '062');

INSERT INTO POST VALUES
        ('545-080', '±¤¿µµ¿', 'Àü¶ó³²µµ ±¤¾ç½Ã ±¤¿µµ¿', '061');

INSERT INTO POST VALUES
        ('550-160', 'ºÀ°­µ¿', 'Àü¶ó³²µµ ¿©¼ö½Ã ºÀ°­µ¿', '061');

INSERT INTO POST VALUES
        ('135-905', '¾Ð±¸Á¤µ¿', '¼­¿ïƯº°½Ã °­³²±¸ ¾Ð±¸Á¤µ¿ ±¸Çö´ë¾ÆÆÄÆ®', '02');

INSERT INTO POST VALUES
        ('550-260', '¿©¼­µ¿', 'Àü¶ó³²µµ ¿©¼ö½Ã ¿©¼­µ¿', '061');

INSERT INTO POST VALUES
        ('135-786', '¾Ð±¸Á¤µ¿', '¼­¿ïƯº°½Ã °­³²±¸ ¾Ð±¸Á¤µ¿ ½ÅÇö´ë¾ÆÆÄÆ®', '02');

INSERT INTO POST VALUES
        ('546-121', '³ó¼ºµ¿', '±¤ÁÖ±¤¿ª½Ã ¼­±¸ ³ó¼ºÆ®', '062');

INSERT INTO POST VALUES
        ('590-020', 'Çâ±³µ¿', 'Àü¶óºÏµµ ³²¿ø½Ã Çâ±³µ¿', '063');

INSERT INTO POST VALUES
        ('548-820', '¿µ³²¸é', 'Àü¶ó³²µµ °íÈﱺ ¿µ³²¸é', '061');

#STUDENT Çлý Å×À̺í ÀÔ·Â
INSERT INTO STUDENT VALUES
        ('20001001', '±èÀ¯½Å', 'Kim Yoo-Shin', 40, 4, 3, '¾ß', '811007-1632013','556-820','¾ÈÆ÷¸® 28¹øÁö','061)685-7818','011-617-1290','1981');

INSERT INTO STUDENT VALUES
        ('20001015', '¹ÚµµÁØ', 'Park Do-Jun', 40, 4, 1, 'ÁÖ', '780116-1580715','135-900','386¹øÁö','02)744-6126','011-611-9884','1978');

INSERT INTO STUDENT VALUES
        ('20001021', 'ÀÌ»ó±æ', 'Lee Sang-Gil', 40, 4, 1, 'ÁÖ', '750819-1227014','451-800','¾ÈÁ¤¸® ÁÖ°øAPT 107µ¿ 504È£','031)691-5423',NULL,'1975');

INSERT INTO STUDENT VALUES
        ('20041002', '±èÀ¯¹Ì', 'Kim Yoo-Mi', 40, 3, 2, 'ÁÖ', '830207-2629715','545-800','´ö·Ê¸® »ê 16-1¹øÁö','061)763-1439','010-617-1290','1983');

INSERT INTO STUDENT VALUES
        ('20041007', 'Á¤ÀÎÁ¤', 'Jeung Yin-Jeung', 40, 2, 2, 'ÁÖ', '830315-2351225','135-794','6µ¿ 1203È£','02)723-1078','016-605-7837','1983');

INSERT INTO STUDENT VALUES
        ('20041033', '¿¬°³¼Ò¹®', 'Yean Gae-So-Moon', 40, 3, 3, '¾ß', '810615-1633111','550-130','280-50¹øÁö','061)642-9304','018-641-9304','1981');

INSERT INTO STUDENT VALUES
        ('20061011', '¹ÚÁ¤ÀÎ', 'Park Jung-In', 40, 2, 1, 'ÁÖ', '830403-1635213','150-051','985¹øÁö ·Ôµ¥APT 102-306','02)652-2439','017-3142-1294','1983');

INSERT INTO STUDENT VALUES
        ('20061014', '°íÇýÁø', 'Ko Hea-Jin', 10, 2, 1,'ÁÖ', '870307-2638759','500-170','»ïÀÍAPT 101µ¿ 102È£','061)781-5135',NULL,'1987');


INSERT INTO STUDENT VALUES
        ('20061048', '±è¿µÈ£', 'Kim Young-Ho', 10, 4, 3 ,'¾ß', '860811-1548758','506-040','¶óÀÎAPT 207µ¿ 309È£','062)678-1010','017-614-7575','1986');

INSERT INTO STUDENT VALUES
        ('20071001', 'Àå¼öÀÎ', 'Jang Soo-In', 40, 1, 1 ,'ÁÖ', '890209-1616822','545-080','±Ý±¤APT 108µ¿ 1101È£','061)791-1236',NULL,'1989');

INSERT INTO STUDENT VALUES
        ('20071010', 'È«±æµ¿', 'Hong Gil-Dong', 40, 1, 3,'¾ß', '880402-1850838','550-160','ÇØÅÂAPT 104µ¿ 605È£','061)642-4034','010-6425-9245','1988');

INSERT INTO STUDENT VALUES
        ('20071022', 'À̼ø½Å', 'Lee Sun-Shin', 10, 1, 3,'¾ß', '890222-1218818','135-794','2µ¿ 1004È£','02)745-7667','010-7141-1860','1989');

INSERT INTO STUDENT VALUES
        ('20071300', 'À¯Çϳª', 'Yoo Ha-Na', 50, 1, 1 ,'ÁÖ', '880921-2573717','550-260','ÁÖ°øAPT 204µ¿ 512È£','061)651-5992','019-651-0707','1988');

INSERT INTO STUDENT VALUES
        ('20071307', '±è¹®¿µ', 'Kim Moon-Young', 50, 1, 3,'¾ß', '880418-2121623','135-905','31µ¿ 102È£','02)745-5485','019-4624-0460','1988');

INSERT INTO STUDENT VALUES
        ('20071405', 'ÃÖÂ÷¿µ', 'Choi Cha-Young', 50, 1, 2 ,'ÁÖ', '881003-2581516','135-786','101µ¿ 540È£','02)745-6893',NULL,'1988');

#SUBJECT ÀÔ·Â
INSERT INTO SUBJECT VALUES
        ('4001', 'µ¥ÀÌÅͺ£À̽º ÀÀ¿ë', 'Database Application', '2002');

INSERT INTO SUBJECT VALUES
        ('4002', 'À¥»çÀÌÆ® ±¸Ãà', 'Web Site Construction', '2003');

INSERT INTO SUBJECT VALUES
        ('4003', '¼ÒÇÁÆ®¿þ¾î°øÇÐ', 'Software Engineering', '2003');

INSERT INTO SUBJECT VALUES
        ('4004', 'À¥ÇÁ·Î±×·¡¹Ö', 'Web Programming', '2002');

INSERT INTO SUBJECT VALUES
        ('4005', 'ÄÄÇ»Åͱ¸Á¶', 'Computer Structure', '2001');

INSERT INTO SUBJECT VALUES
        ('4006', 'Á¤º¸Ã³¸®½Ç¹«', 'Information Process Practical business', '2001');

INSERT INTO SUBJECT VALUES
        ('4007', 'UML', 'Unified Modeling Language', '2005');

INSERT INTO SUBJECT VALUES
        ('4008', '¿î¿µÃ¼Á¦', 'Operating System', '2002');

INSERT INTO SUBJECT VALUES
        ('4009', 'ÀüÀÚ»ó°Å·¡ ½Ç¹«', 'Electronic Commerce', '2003');

INSERT INTO SUBJECT VALUES
        ('4010', 'À©µµ¿ìÁî ÇÁ·Î±×·¡¹Ö', 'Windows Programming', '1998');

INSERT INTO SUBJECT VALUES
        ('4011', 'ÀÚ¹ÙÇÁ·Î±×·¡¹Ö', 'Java Programming', '1999');

INSERT INTO SUBJECT VALUES
        ('4012', '³×Æ®¿öÅ© ÇÁ·Î±×·¡¹Ö', 'Network Programming', '2005');

INSERT INTO SUBJECT VALUES
        ('4013', 'ÄÄÆ÷³ÍÆ® ÇÁ·Î±×·¡¹Ö', 'Component Programming', '2004');

#PROFESSOR ÀÔ·Â
INSERT INTO PROFESSOR VALUES
        ('4001','Á¤Áø¿ë','Jung jin-yong','1995-09-01');
      
INSERT INTO PROFESSOR VALUES
        ('4002','³ªÀμ·','Na in-sub','2006-02-02');

INSERT INTO PROFESSOR VALUES
        ('4003','Á¤Ã¢ºÎ','Jung chang-boo','2003-03-01');

INSERT INTO PROFESSOR VALUES
        ('4004','¹Ú»óö','Park sang-chul','2000-01-15');


INSERT INTO PROFESSOR VALUES
        ('4005','Á¤º´¿­','Jung byeong-yeol','1998-03-01');

INSERT INTO PROFESSOR VALUES
        ('4006','°íÁø±¤','Go jin-gwang','1988-03-01');

INSERT INTO PROFESSOR VALUES
        ('4007','±è¿µ½Ä','Kim young-sik','1986-03-01');

INSERT INTO PROFESSOR VALUES
        ('4008','ÃÖ¿ìÁø','Choi woo-jin','1997-03-01');

INSERT INTO PROFESSOR VALUES
        ('4009','¹®Ã¢¼ö','Moon chang-soo','1995-03-01');

INSERT INTO PROFESSOR VALUES
        ('5010','Á¤Á¾ÇÊ','Jung jong-phil','1997-03-01');

INSERT INTO PROFESSOR VALUES
        ('5011','ÃÖÁ¾ÁÖ','Choi jong-joo','1992-03-05');

#ATTEND ÀÔ·Â
INSERT INTO ATTEND VALUES
	('20061011','2006',1,3,4001,'4002',3, 99,'Y','1','2006-03-05');

INSERT INTO ATTEND VALUES
	('20061011','2006',1,4,4002,'4003',3, 95,'Y','1','2006-03-05');

INSERT INTO ATTEND VALUES
	('20061011','2006',1,4,4003,'4004',3, 97,'Y','1','2006-03-05');

INSERT INTO ATTEND VALUES
	('20061011','2006',1,4,4004,'4001',3, 98,'Y','1','2006-03-05');

INSERT INTO ATTEND VALUES
	('20061011','2006',1,4,4005,'4007',3, 96,'Y','1','2006-03-05');

INSERT INTO ATTEND VALUES
	('20061011','2006',1,4,4006,'4008',3, 95,'Y','1','2006-03-05');


INSERT INTO ATTEND VALUES
	('20061011','2006',2,3,4007,'4009',3, 93,'Y','1','2006-09-03');

INSERT INTO ATTEND VALUES
	('20061011','2006',2,4,4008,'4005',3, 92,'Y','1','2006-09-03');

INSERT INTO ATTEND VALUES
	('20061011','2006',2,4,4009,'4006',3, 94,'Y','1','2006-09-03');

INSERT INTO ATTEND VALUES
	('20061011','2006',2,4,4010,'4001',3, 90,'Y','1','2006-09-03');

INSERT INTO ATTEND VALUES
	('20061011','2006',2,4,4011,'4002',3, 91,'Y','1','2006-09-03');

INSERT INTO ATTEND VALUES
	('20061011','2006',2,4,4012,'4003',3, 92,'Y','1','2006-09-03');

INSERT INTO ATTEND VALUES
	('20071300','2007',1,3,4001,'4002',3, 99,'Y','1','2007-03-05');

INSERT INTO ATTEND VALUES
	('20071300','2007',1,4,4002,'4003',3, 95,'Y','1','2007-03-05');

INSERT INTO ATTEND VALUES
	('20071300','2007',1,4,4003,'4004',3, 97,'Y','1','2007-03-05');

INSERT INTO ATTEND VALUES
	('20071300','2007',1,4,4004,'4001',3, 98,'Y','1','2007-03-05');

INSERT INTO ATTEND VALUES
	('20071300','2007',1,4,4005,'4007',3, 93,'Y','1','2007-03-05');

INSERT INTO ATTEND VALUES
	('20071300','2007',1,4,4006,'4008',3, 95,'Y','1','2007-03-05');

#FEE ÀÔ·Â
INSERT INTO FEE VALUES
	('20061011','2006',1, 500000,3000000,3500000,01,500000,3000000,'Y','2006-02-18');


INSERT INTO FEE VALUES
	('20061011','2006',2, NULL,3000000,3000000,10,2500000,500000,'Y','2006-08-20');

INSERT INTO FEE VALUES
	('20061011','2007',1, NULL,3000000,3000000,11,2000000,1000000,'Y','2007-02-18');

INSERT INTO FEE VALUES
	('20061011','2007',2, NULL,3000000,3000000,21,800000,2200000,'Y','2007-08-10');

INSERT INTO FEE VALUES
	('20001015','2000',1, 500000,2500000,3000000,02,1000000,2000000,'Y','2000-02-01');

INSERT INTO FEE VALUES
	('20001015','2000',2, NULL,2500000,2500000,10,2500000,0,'Y','2000-08-10');

INSERT INTO FEE VALUES
	('20001015','2001',1, NULL,2800000,2800000,10,2500000,300000,'Y','2001-02-15');

INSERT INTO FEE VALUES
	('20001015','2001',2, NULL,2800000,2800000,10,2500000,300000,'Y','2001-08-16');

INSERT INTO FEE VALUES
	('20001015','2006',1, NULL,3000000,3000000,10,2500000,500000,'Y','2006-02-14');

INSERT INTO FEE VALUES
	('20001015','2006',2, NULL,3000000,3000000,10,2500000,500000,'Y','2006-08-18');

INSERT INTO FEE VALUES
	('20001015','2007',1, NULL,3000000,3000000,11,2000000,1000000,'Y','2007-02-10');

INSERT INTO FEE VALUES
	('20001015','2007',2, NULL,3000000,3000000,10,2500000,500000,'Y','2007-08-19');

INSERT INTO FEE VALUES
	('20071300','2007',1, 500000,3000000,3500000,01,500000,3000000,'Y','2007-02-18');

INSERT INTO FEE VALUES
	('20071300','2007',2, NULL,3000000,3000000,11,2000000,1000000,'Y','2007-08-10');

INSERT INTO FEE VALUES
	('20071001','2007',1, 500000,3000000,3500000,01,500000,3000000,'Y','2007-02-18');

INSERT INTO FEE VALUES
	('20071001','2007',2, NULL,3000000,3000000,NULL,NULL,3000000,'Y','2007-08-10');

INSERT INTO FEE VALUES
	('20071010','2007',1, 500000,3000000,3500000,01,500000,3000000,'Y','2007-02-18');

INSERT INTO FEE VALUES
	('20071010','2007',2, NULL,3000000,3000000,NULL,NULL,3000000,'Y','2007-08-10');

INSERT INTO FEE VALUES
	('20071022','2007',1, 500000,3000000,3500000,01,500000,3000000,'Y','2007-02-18');

INSERT INTO FEE VALUES
	('20071022','2007',2, NULL,3000000,3000000,NULL,NULL,3000000,'Y','2007-08-10');

INSERT INTO FEE VALUES
	('20071307','2007',1, 500000,3000000,3500000,01,500000,3000000,'Y','2007-02-18');

INSERT INTO FEE VALUES
	('20071307','2007',2, NULL,3000000,3000000,NULL,NULL,3000000,'Y','2007-08-10');

INSERT INTO FEE VALUES
	('20071405','2007',1, 500000,3000000,3500000,01,500000,3000000,'Y','2007-02-18');

INSERT INTO FEE VALUES
	('20071405','2007',2, NULL,3000000,3000000,10,2500000,500000,'Y','2007-08-10');
#SCORE ÀÔ·Â
INSERT INTO SCORE VALUES
	('20061011','2006',1,18,18,4.5,580,'Y','2006-08-10');

INSERT INTO SCORE VALUES
	('20061011','2006',2,18,18,4.0,552,'Y','2007-01-11');

INSERT INTO SCORE VALUES
	('20071300','2007',1,18,18,4.4,577,'Y','2007-08-09');

INSERT INTO SCORE VALUES
	('20071307','2007',1,18,18,4.4,575,'Y','2007-08-09');


INSERT INTO SCORE VALUES
	('20071405','2007',1,18,18,4.2,572,'Y','2007-08-09');

INSERT INTO SCORE VALUES
	('20061011','2007',2,18,18,0,0,'N','2007-11-10');

INSERT INTO SCORE VALUES
	('20061300','2007',2,18,18,0,0,'N','2007-11-10');

INSERT INTO SCORE VALUES
	('20061307','2007',2,18,18,0,0,'N','2007-11-10');

INSERT INTO SCORE VALUES
	('20061405','2007',2,18,18,0,0,'N','2007-11-10');

#CIRCLE ÀÔ·Â
INSERT INTO CIRCLE VALUES
	(1,'ÄĸÍÅ»Ãâ','20061011','¹ÚÁ¤ÀÎ','0');

INSERT INTO CIRCLE VALUES
	(2,'ÄĸÍÅ»Ãâ','20071300','À¯Çϳª','1');

INSERT INTO CIRCLE VALUES
	(3,'ÄĸÍÅ»Ãâ','20071307','±è¹®¿µ','2');

INSERT INTO CIRCLE VALUES
	(4,'Java±æ¶óÀâÀÌ','20071001','Àå¼öÀÎ','2');

INSERT INTO CIRCLE VALUES
	(5,'Java±æ¶óÀâÀÌ','20041007','Á¤ÀÎÁ¤','1');

INSERT INTO CIRCLE VALUES
	(6,'Java±æ¶óÀâÀÌ','20001015','¹ÚµµÁØ','0');

INSERT INTO CIRCLE VALUES
	(7,'PHP±æ¶óÀâÀÌ','20001021','ÀÌ»ó±æ','0');