Data 1

for department create table "testpe"."department" ("dept_id" number(10), "department_name" varchar2(30), "manager_id" number(10) not null, "location_id" number(10) not null, primary key("dept_id")) tablespace "data_ts" for jobs create table "testpe"."jobs" ("job_id" varchar2(10) not null, "job_title" varchar2(35) not null, "min_salary" varchar2(10), "max_salary" varchar2(10), primary key("job_id")) tablespace "data_ts" for employees create table "testpe"."employees1" ("emp_id" number(10) not null, "name" varchar2(50) not null, "hiredate" date not null, "job_id" varchar2(10) not null, "dept_id" number(10) not null, "salary" number(10) not null, "manager_id" number(10) not null, "commission" number(10) not null, primary key("emp_id"), foreign key("dept_id") references "testpe"."department"("dept_id")) tablespace "data_ts"