[Oracle-SQL] 회사 데이터베이스2

INSERT INTO department VALUES (100,'Research','Stafford');
INSERT INTO department VALUES (200,'Headquarter','Chicago');
INSERT INTO department VALUES (300,'Software','Atlanta');
INSERT INTO department VALUES (400,'Sales','Miami');
INSERT INTO department VALUES (500,'Administraion','Seattle');
/* 부서번호 부서이름 부서위치*/

INSERT INTO employee VALUES (1111,'David','Intern',100000,'Seoul','Junggu','Yaksudong','400');
INSERT INTO employee VALUES (2222,'Jan','Staff',150000,'Busan','Yeonjegu','Yeonsandong','100');
INSERT INTO employee VALUES (3333,'Kelly','CEO',200000,'Incheon','Namdonggu','Mansudong','200');
INSERT INTO employee VALUES (4444,'Grace','Manager',250000,'Daejeon','Seogu','dunsandong','300');
INSERT INTO employee VALUES (5555,'Mark','Staff',150000,'Gwangju','Seogu','Nongseongdong','500');
/*사원번호 사원이름 직책 급여 시 구 동 소속부서번호*/

INSERT INTO supplyer VALUES (001,'Jon','A');
INSERT INTO supplyer VALUES (002,'Billie','AA');
INSERT INTO supplyer VALUES (003,'Tom','A');
INSERT INTO supplyer VALUES (004,'Ray','BB');
INSERT INTO supplyer VALUES (005,'Justin','B');
/*공급자번호 공급자이름 신용도*/

INSERT INTO pro VALUES (1001,'first',15000000,3333,220223);
INSERT INTO pro VALUES (1002,'second',5000000,2222,220318);
INSERT INTO pro VALUES (1003,'third',5000000,4444,220414);
INSERT INTO pro VALUES (1004,'fourth',3000000,1111,220506);
INSERT INTO pro VALUES (1005,'fifth',3500000,5555,220603);
/*프로젝트번호 프로젝트이름 예산 관리자 관리시작날짜*/

INSERT INTO part VALUES (1,'RAM',10000,3);
INSERT INTO part VALUES (2,'Mainboard',5000,3);
INSERT INTO part VALUES (3,'CPU',15000,2);
INSERT INTO part VALUES (4,'ROM',10000,3);
INSERT INTO part VALUES (5,'Battery',5000,2);
/*부품번호 부품이름 가격 포함부품번호*/

INSERT INTO family VALUES (1111,'Andy','M');
INSERT INTO family VALUES (1111,'Lyle','F');
INSERT INTO family VALUES (3333,'Sam','M');
INSERT INTO family VALUES (4444,'Jame','M');
INSERT INTO family VALUES (5555,'Alice','F');
/*부양사원번호 가족이름 성별*/

INSERT INTO performace VALUES (1001,3333,'PM',3);
INSERT INTO performace VALUES (1004,2222,'PO',2);
INSERT INTO performace VALUES (1002,4444,'PE',3);
INSERT INTO performace VALUES (1003,5555,'PL',2);
INSERT INTO performace VALUES (1005,1111,'PA',1);
/*수행프로젝트 담당사원 사원역할 근무기간*/

INSERT INTO supply VALUES (5555,1001,002,20);
INSERT INTO supply VALUES (3333,1005,003,3);
INSERT INTO supply VALUES (2222,1002,001,15);
INSERT INTO supply VALUES (4444,1004,005,5);
INSERT INTO supply VALUES (1111,1003,004,10);
/*공급담당자 공급프로젝트 공급부품 공급량*/

INSERT INTO progress VALUES (1001,'Atlanta');
INSERT INTO progress VALUES (1002,'Stafford');
INSERT INTO progress VALUES (1003,'Chicago');
INSERT INTO progress VALUES (1004,'Seattle');
INSERT INTO progress VALUES (1005,'Miami');
/*진행프로젝트 진행위치/