--
-- Selected TOC Entries:
--
\connect - dba
--
-- TOC Entry ID 1 (OID 0)
--
-- Name: zervan Type: DATABASE Owner: dba
--

Create Database "zervan";

\connect zervan dba
\connect - zervan
--
-- TOC Entry ID 2 (OID 22430)
--
-- Name: emp Type: TABLE Owner: zervan
--

CREATE TABLE "emp" (
	"empno" numeric(4,0) NOT NULL,
	"ename" character varying(10),
	"job" character varying(9),
	"mgr" numeric(4,0),
	"hiredate" date,
	"sal" numeric(7,2),
	"comm" numeric(7,2),
	"deptno" numeric(2,0) NOT NULL
);

--
-- TOC Entry ID 3 (OID 22447)
--
-- Name: salgrade Type: TABLE Owner: zervan
--

CREATE TABLE "salgrade" (
	"grade" numeric(1,0) NOT NULL,
	"losal" numeric(7,2) NOT NULL,
	"hisal" numeric(7,2) NOT NULL
);

--
-- TOC Entry ID 4 (OID 22459)
--
-- Name: dept Type: TABLE Owner: zervan
--

CREATE TABLE "dept" (
	"deptno" numeric(2,0) NOT NULL,
	"dname" character varying(14),
	"loc" character varying(13)
);

--
-- Data for TOC Entry ID 5 (OID 22430)
--
-- Name: emp Type: TABLE DATA Owner: zervan
--


INSERT INTO "emp" VALUES ('7839','KING','PRESIDENT',NULL,'1981-11-17','5000.00',NULL,'10');
INSERT INTO "emp" VALUES ('7698','BLAKE','MANAGER','7839','1981-05-01','2850.00',NULL,'30');
INSERT INTO "emp" VALUES ('7782','CLARK','MANAGER','7839','1981-06-09','1500.00',NULL,'10');
INSERT INTO "emp" VALUES ('7566','JONES','MANAGER','7839','1981-04-02','2975.00',NULL,'20');
INSERT INTO "emp" VALUES ('7654','MARTIN','SALESMAN','7698','1981-09-28','1250.00','1400.00','30');
INSERT INTO "emp" VALUES ('7499','ALLEN','SALESMAN','7698','1981-02-20','1600.00','300.00','30');
INSERT INTO "emp" VALUES ('7844','TURNER','SALESMAN','7698','1981-09-08','1500.00','0.00','30');
INSERT INTO "emp" VALUES ('7900','JAMES','CLERK','7698','1981-12-03','950.00',NULL,'30');
INSERT INTO "emp" VALUES ('7521','WARD','SALESMAN','7698','1981-02-22','1250.00','500.00','30');
INSERT INTO "emp" VALUES ('7902','FORD','ANALYST','7566','1981-12-03','3000.00',NULL,'20');
INSERT INTO "emp" VALUES ('7369','SMITH','CLERK','7902','1980-12-17','800.00',NULL,'20');
INSERT INTO "emp" VALUES ('7788','SCOTT','ANALYST','7566','1982-12-09','3000.00',NULL,'20');
INSERT INTO "emp" VALUES ('7876','ADAMS','CLERK','7788','1983-01-12','1100.00',NULL,'20');
INSERT INTO "emp" VALUES ('7934','MILLER','CLERK','7782','1982-01-23','1300.00',NULL,'10');
--
-- Data for TOC Entry ID 6 (OID 22447)
--
-- Name: salgrade Type: TABLE DATA Owner: zervan
--


INSERT INTO "salgrade" VALUES ('1','700.00','1200.00');
INSERT INTO "salgrade" VALUES ('2','1201.00','1400.00');
INSERT INTO "salgrade" VALUES ('3','1401.00','2000.00');
INSERT INTO "salgrade" VALUES ('4','2001.00','3000.00');
INSERT INTO "salgrade" VALUES ('5','3001.00','9999.00');
--
-- Data for TOC Entry ID 7 (OID 22459)
--
-- Name: dept Type: TABLE DATA Owner: zervan
--


INSERT INTO "dept" VALUES ('10','ACCOUNTING','NEW YORK');
INSERT INTO "dept" VALUES ('20','RESEARCH','DALLAS');
INSERT INTO "dept" VALUES ('30','SALES','CHICAGO');
INSERT INTO "dept" VALUES ('40','OPERATIONS','BOSTON');