DROP TABLE dept cascade constraints;

CREATE TABLE dept (
dept_no NUMBER(2),
dept_name VARCHAR2(10),
CONSTRAINT dept_no_pk PRIMARY KEY(dept_no)
USING INDEX 
TABLESPACE indx);

INSERT INTO dept VALUES (10, 'ÀÚ¹Ù');
INSERT INTO dept VALUES (20, 'À¥');
INSERT INTO dept VALUES (30, '¾ð¾î');
INSERT INTO dept VALUES (40, '¸®´ª½º');
INSERT INTO dept VALUES (50, '¿µ¾÷');

DROP TABLE study cascade constraints;

CREATE TABLE study (
study_no NUMBER(2),
study_name VARCHAR2(20),
startday DATE,
pay NUMBER(10),
bonus NUMBER(10),
sex CHAR(4),
dept_no NUMBER(2)
CONSTRAINT study_deptno_fk REFERENCES dept(dept_no),
CONSTRAINT study_no_pk  PRIMARY KEY(study_no)
USING INDEX 
TABLESPACE indx);


INSERT INTO study VALUES (1, 'ÀÓ¼ºÃá', to_date('01-JAN-2000', 'dd-MON-yyyy'), 300, null,'M', 10);
INSERT INTO study VALUES (2, 'ÀÌ°æÈñ', to_date('01-JAN-2001', 'dd-MON-yyyy'), 250, null, 'F', 10);
INSERT INTO study VALUES (3, 'À¯°æÈñ', to_date('01-MAR-2001', 'dd-MON-yyyy'), 200, null, 'F',10);
INSERT INTO study VALUES (4, '³ª°æÈ£', to_date('01-JUL-2000', 'dd-MON-yyyy'), 200, null, 'M',20);
INSERT INTO study VALUES (5, 'Ã̶ֹó', to_date('01-JAN-2001', 'dd-MON-yyyy'), 250, null,'F', 30);
INSERT INTO study VALUES (6, 'À±¹Ì¼÷', to_date('31-MAR-2000', 'dd-MON-yyyy'), 200, null, 'F',10);
INSERT INTO study VALUES (7, '°­¼ºÅÂ', to_date('01-SEP-1999', 'dd-MON-yyyy'), 300, null, 'M',10);
INSERT INTO study VALUES (8, 'À¯¹Ì°æ', to_date('01-MAR-2001', 'dd-MON-yyyy'), 300, null, 'F',40);
INSERT INTO study VALUES (9, '±èűÙ', to_date('01-JUL-2001', 'dd-MON-yyyy'), 100, 100, 'M',null);

commit;