SHARE
TWEET

college

a guest Oct 11th, 2019 211 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. BEGIN
  2. FOR c IN (SELECT table_name FROM user_tables) LOOP
  3. EXECUTE IMMEDIATE ('drop table '||c.table_name||' cascade constraints');
  4. END LOOP;
  5. END;
  6. /
  7.  
  8. CREATE TABLE student
  9.     (StudentId  CHAR (5),
  10.         LAST        VARCHAR2 (15) CONSTRAINT student_last_nn NOT NULL,
  11.         FIRST       VARCHAR2 (15) CONSTRAINT student_first_nn NOT NULL,
  12.         Street      VARCHAR2 (25),
  13.         City        VARCHAR2 (15),
  14.         State       CHAR (2) DEFAULT 'NJ',
  15.         Zip         CHAR (5),
  16.         StartTerm   CHAR (4),
  17.     BirthDate   DATE,
  18.     FacultyId   NUMBER (3),
  19.         MajorId     NUMBER (3),
  20.         Phone       CHAR (10),
  21.         CONSTRAINT student_studentid_pk PRIMARY KEY (StudentID));
  22.  
  23. CREATE TABLE worker
  24.     (WorkerId   CHAR (5),
  25.         LAST        VARCHAR2 (15) CONSTRAINT worker_last_nn NOT NULL,
  26.         FIRST       VARCHAR2 (15) CONSTRAINT worker_first_nn NOT NULL,
  27.         CONSTRAINT worker_workerid_pk PRIMARY KEY (WorkerId));
  28.  
  29. CREATE TABLE faculty
  30.     (FacultyId  NUMBER (3),
  31.     Name        VARCHAR2 (15) CONSTRAINT faculty_name_nn NOT NULL,
  32.     RoomId      NUMBER (2),
  33.     Phone       CHAR (3) CONSTRAINT faculty_phone_uk UNIQUE,
  34.     DeptId      NUMBER (1),
  35.     CONSTRAINT faculty_facultyid_pk PRIMARY KEY (FacultyId));
  36.  
  37. CREATE TABLE course
  38.     (CourseId   VARCHAR2 (6),
  39.     Title       VARCHAR2 (20) CONSTRAINT course_title_uk UNIQUE,
  40.     Credits     NUMBER (1) CONSTRAINT course_credits_ck CHECK ((credits>=0) AND (credits<=4)),
  41.     PreReq      VARCHAR2(6),
  42.     CONSTRAINT course_courseid_pk PRIMARY KEY (CourseId));
  43.  
  44. CREATE TABLE crssection
  45.     (CsId       NUMBER (4),
  46.     CourseId    VARCHAR2 (6) CONSTRAINT crssection_courseid_nn NOT NULL,
  47.     Section     CHAR (2) CONSTRAINT crsssection_section_nn NOT NULL,
  48.     TermId      CHAR (4) CONSTRAINT crssection_termid_nn NOT NULL,
  49.     FacultyId   NUMBER (3),
  50.     DAY     VARCHAR2 (2),
  51.     StartTime   VARCHAR2 (5),
  52.     EndTime     VARCHAR2 (5),
  53.     RoomId      NUMBER (2),
  54.     MaxCount    NUMBER (2) CONSTRAINT crssection_maxcount_ck CHECK (MaxCount > 0),
  55.     CONSTRAINT crssection_csid_pk PRIMARY KEY (CsId));
  56.  
  57. CREATE TABLE registration
  58.     (StudentId  CHAR (5),
  59.     CsId        NUMBER (4),
  60.     Midterm     CHAR CONSTRAINT registration_midterm_ck CHECK (MidTerm IN ('A', 'B', 'C', 'D', 'F', 'W')),
  61.     Final       CHAR CONSTRAINT registration_final_ck CHECK (final IN ('A', 'B', 'C', 'D', 'I', 'F', 'W')),
  62.     RegStatus   CHAR CONSTRAINT reg_status_ck CHECK (RegStatus IN ('X', 'R', 'W')),
  63.     CONSTRAINT registration_stuid_csid_pk
  64.         PRIMARY KEY (StudentId, CsId));
  65.  
  66. CREATE TABLE room
  67.     (RoomType   CHAR,
  68.     RoomDesc    VARCHAR2 (9),
  69.     CONSTRAINT room_roomtype_pk PRIMARY KEY (RoomType));
  70.  
  71.  
  72. CREATE TABLE term
  73.     (TermId     CHAR (4),
  74.     TermDesc    VARCHAR2 (11),
  75.     StartDate   DATE,
  76.     EndDate     DATE,
  77.     CONSTRAINT term_termid_pk PRIMARY KEY (TermId));
  78.  
  79. CREATE TABLE location
  80.     (RoomId     NUMBER (2),
  81.     Building    VARCHAR2 (7) CONSTRAINT location_bulding_nn NOT NULL,
  82.     RoomNo      CHAR (3) CONSTRAINT location_roomno_nn NOT NULL,   
  83.     Capacity    NUMBER (2) CONSTRAINT location_capacity_check CHECK(Capacity>0),
  84.     RoomType    CHAR,
  85.     CONSTRAINT location_roomid_pk PRIMARY KEY (RoomId),
  86.     CONSTRAINT location_roomno_uk UNIQUE (RoomNo));
  87.  
  88. CREATE TABLE major
  89.     (MajorId    NUMBER (3),
  90.     MajorDesc   VARCHAR2 (25),
  91.     CONSTRAINT major_majored_pk PRIMARY KEY (MajorId));
  92.  
  93. CREATE TABLE department
  94.     (DeptId     NUMBER (1),
  95.     DeptName    VARCHAR2 (20),
  96.     FacultyId   NUMBER (3),
  97.     CONSTRAINT department_deptid_pk PRIMARY KEY (DeptId));
  98.  
  99. ALTER TABLE student
  100. ADD CONSTRAINT student_facultyid_fk FOREIGN KEY (FacultyId)
  101.     REFERENCES faculty (FacultyId);
  102.  
  103. ALTER TABLE student
  104. ADD CONSTRAINT student_majorid_fk FOREIGN KEY (MajorId)
  105.     REFERENCES major (MajorId);
  106.  
  107. ALTER TABLE student
  108. ADD CONSTRAINT student_startterm_fk FOREIGN KEY (StartTerm)
  109.     REFERENCES term (TermId);
  110.  
  111. ALTER TABLE faculty
  112. ADD CONSTRAINT faculty_roomid_fk FOREIGN KEY (RoomId)
  113.     REFERENCES location (RoomId);
  114.  
  115. ALTER TABLE faculty
  116. ADD CONSTRAINT faculty_deptid_fk FOREIGN KEY (DeptId)
  117.     REFERENCES department (DeptId);
  118.  
  119. ALTER TABLE crssection
  120. ADD CONSTRAINT crssection_courseid_fk FOREIGN KEY (CourseId)
  121.     REFERENCES course (CourseId);
  122.  
  123. ALTER TABLE crssection
  124. ADD CONSTRAINT crssection_termid_fk FOREIGN KEY (TermId)
  125.     REFERENCES term (TermId);
  126.  
  127. ALTER TABLE crssection
  128. ADD CONSTRAINT crssection_facultyid_fk FOREIGN KEY (FacultyId)
  129.     REFERENCES faculty (FacultyId);
  130.  
  131. ALTER TABLE crssection
  132. ADD CONSTRAINT crssection_roomid_fk FOREIGN KEY (RoomId)
  133.     REFERENCES location (RoomId);
  134.  
  135. ALTER TABLE registration
  136. ADD CONSTRAINT registration_studentid_fk FOREIGN KEY (StudentId)
  137.     REFERENCES student (StudentId);
  138.  
  139. ALTER TABLE registration
  140. ADD CONSTRAINT registration_csid_fk FOREIGN KEY (CsId)
  141.     REFERENCES crssection (CsId);
  142.  
  143. ALTER TABLE location
  144. ADD CONSTRAINT location_roomtype_fk FOREIGN KEY (RoomType)
  145.     REFERENCES ROOM (RoomType);
  146.  
  147. INSERT INTO course VALUES ('EN100', 'Basic English', 0, '');
  148. INSERT INTO course VALUES ('LA123', 'English Literature', 3, 'EN100');
  149. INSERT INTO course VALUES ('CIS253', 'Database Systems', 3, '');
  150. INSERT INTO course VALUES ('CIS265', 'Systems Analysis', 3, 'CIS253');
  151. INSERT INTO course VALUES ('MA150', 'College Algebra', 3, '');
  152. INSERT INTO course VALUES ('AC101', 'Accounting', 3, '');
  153.  
  154. INSERT INTO room VALUES ('L', 'Lab');
  155. INSERT INTO room VALUES ('C', 'Classroom');
  156. INSERT INTO room VALUES ('O', 'Office');
  157.  
  158. INSERT INTO term VALUES ('SP02', 'Spring 2002', '28-APR-02', '16-AUG-02');
  159. INSERT INTO term VALUES ('FL02', 'Fall 2002', '08-SEP-02', '20-DEC-02');
  160. INSERT INTO term VALUES ('WN03', 'Winter 2003', '05-JAN-03', '18-APR-03');
  161. INSERT INTO term VALUES ('SP03', 'Spring 2003', '27-APR-03', '15-AUG-03');
  162. INSERT INTO term VALUES ('FL03', 'Fall 2003', '07-SEP-03', '19-DEC-03');
  163.  
  164. INSERT INTO major VALUES (100, 'AAS-Accounting');
  165. INSERT INTO major VALUES (200, 'AAS-Computer Science');
  166. INSERT INTO major VALUES (300, 'AAS-Telecommunications');
  167. INSERT INTO major VALUES (400, 'BS-Accounting');
  168. INSERT INTO major VALUES (500, 'BS-Computer Science');
  169. INSERT INTO major VALUES (600, 'BS-Telecommunications');
  170.  
  171. INSERT INTO department VALUES (1, 'Computer Science', 111);
  172. INSERT INTO department VALUES (2, 'Telecommunications', 222);
  173. INSERT INTO department VALUES (3, 'Accounting', 333);
  174. INSERT INTO department VALUES (4, 'Math and Science', 444);
  175. INSERT INTO department VALUES (5, 'Liberal Arts', 555);
  176.  
  177. INSERT INTO location VALUES (11, 'Gandhi', 101, 2, 'O');
  178. INSERT INTO location VALUES (12, 'Gandhi', 103, 2, 'O');
  179. INSERT INTO location VALUES (13, 'Kennedy', 202, 35, 'L');
  180. INSERT INTO location VALUES (14, 'Kennedy', 204, 50, 'L');
  181. INSERT INTO location VALUES (15, 'Nehru', 301, 50, 'C');
  182. INSERT INTO location VALUES (16, 'Nehru', 309, 45, 'C');
  183. INSERT INTO location VALUES (17, 'Gandhi', 105, 2, 'O');
  184. INSERT INTO location VALUES (18, 'Kennedy', 206, 40, 'L');
  185. INSERT INTO location VALUES (19, 'Kennedy', 210, 30, 'L');
  186. INSERT INTO location VALUES (20, 'Gandhi', 107, 2, 'O');
  187. INSERT INTO location VALUES (21, 'Gandhi', 109, 2, 'O');
  188.  
  189. INSERT INTO faculty VALUES (111, 'Jones', 11, 525, 1);
  190. INSERT INTO faculty VALUES (222, 'Williams', 20, 533, 2);
  191. INSERT INTO faculty VALUES (123, 'Mobley', 11, 529, 1);
  192. INSERT INTO faculty VALUES (235, 'Vajpayee', 12, 577, 2);
  193. INSERT INTO faculty VALUES (345, 'Sen', 12, 579, 3);
  194. INSERT INTO faculty VALUES (444, 'Rivera', 21, 544, 4);
  195. INSERT INTO faculty VALUES (555, 'Chang', 17, 587, 5);
  196. INSERT INTO faculty VALUES (333, 'Collins', 17, 599, 3);
  197.  
  198. INSERT INTO student VALUES ('00100', 'Diaz', 'Jose', '1 Ford Avenue #7',
  199.     'Hill', 'NJ', '08863', 'WN03', TO_DATE ('02/12/1983', 'mm/dd/yyyy'),
  200.     123, 100, '9735551111');
  201. INSERT INTO student VALUES ('00101', 'Tyler', 'Mickey', '12 Morris Avenue',
  202.     'Bronx', 'NY', '10468', 'SP03', TO_DATE ('03/18/1984', 'mm/dd/yyyy'),
  203.     555, 500, '7185552222');
  204. INSERT INTO student VALUES ('00102', 'Patel', 'Rajesh', '25 River Road #3',
  205.     'Edison', 'NJ', '08837', 'WN03', TO_DATE ('12/12/1985', 'mm/dd/yyyy'),
  206.     111, 400, '7325553333');
  207. INSERT INTO student VALUES ('00103', 'Rickles', 'Deborah', '100 Main Street',
  208.     'Iselin', 'NJ', '08838', 'FL02', TO_DATE ('10/20/1970', 'mm/dd/yyyy'),
  209.     555, 500, '7325554444');
  210. INSERT INTO student VALUES ('00104', 'Lee', 'Brian', '2845 First Lane',
  211.     'Hope', 'NY', '11373', 'WN03', TO_DATE ('11/28/1985', 'mm/dd/yyyy'),
  212.     345, 600, '2125555555');
  213. INSERT INTO student VALUES ('00105', 'Khan', 'Amir', '213 Broadway',
  214.     'Clifton', 'NJ', '07222', 'WN03', TO_DATE ('07/07/1984', 'mm/dd/yyyy'),
  215.     222, 200, '2015556666');
  216.  
  217. INSERT INTO worker VALUES ('00110', 'Borges', 'Luz');
  218. INSERT INTO worker VALUES ('00111', 'Bayer', 'Julia');
  219. INSERT INTO worker VALUES ('00103', 'Rickles', 'Deborah');
  220. INSERT INTO worker VALUES ('00113', 'Marte', 'Noemi');
  221. INSERT INTO worker VALUES ('00105', 'Khan', 'Amir');
  222. INSERT INTO worker VALUES ('00107', 'Feliciano', 'Sandi');
  223.  
  224. INSERT INTO crssection VALUES (1101, 'CIS265', '01', 'WN03', 111, 'MW',
  225.                 '09:00', '10:30', 13, 30);
  226. INSERT INTO crssection VALUES (1102, 'CIS253', '01', 'WN03', 123, 'TR',
  227.                 '09:00', '10:30', 18, 40);
  228. INSERT INTO crssection VALUES (1103, 'MA150', '02', 'WN03', 444, 'F',
  229.                 '09:00', '12:00', 15, 25);
  230. INSERT INTO crssection VALUES (1104, 'AC101', '10', 'WN03', 345, 'MW',
  231.                 '10:30', '12:00', 16, 35);
  232. INSERT INTO crssection VALUES (1205, 'CIS265', '01', 'SP03', NULL, 'MW',
  233.                 '09:00', '10:30', 14, 35);
  234. INSERT INTO crssection VALUES (1206, 'CIS265', '02', 'SP03', 111, 'TR',
  235.                 '09:00', '10:30', 18, 30);
  236. INSERT INTO crssection VALUES (1207, 'LA123', '05', 'SP03', NULL, 'MW',
  237.                 '09:00', '10:30', 15, 30);
  238. INSERT INTO crssection VALUES (1208, 'CIS253', '21', 'SP03', 123, 'TR',
  239.                 '09:00', '10:30', 14, 40);
  240. INSERT INTO crssection VALUES (1209, 'CIS253', '11', 'SP03', 111, 'MW',
  241.                 '09:00', '10:30', 18, 40);
  242. INSERT INTO crssection VALUES (1210, 'CIS253', '31', 'SP03', 123, 'F',
  243.                 'TBA', 'TBA', 19, 2);
  244.  
  245. INSERT INTO registration VALUES ('00100', 1103, 'C', 'F', 'R');
  246. INSERT INTO registration VALUES ('00100', 1102, 'B', 'B', 'R');
  247. INSERT INTO registration VALUES ('00100', 1104, 'B', 'A', 'R');
  248. INSERT INTO registration VALUES ('00102', 1102, 'F', 'D', 'R');
  249. INSERT INTO registration VALUES ('00102', 1103, 'A', 'A', 'R');
  250. INSERT INTO registration VALUES ('00103', 1101, 'F', 'W', 'W');
  251. INSERT INTO registration VALUES ('00103', 1104, 'D', 'D', 'R');
  252. INSERT INTO registration VALUES ('00100', 1207, '', '', 'X');
  253. INSERT INTO registration VALUES ('00103', 1206, '', '', 'W');
  254. INSERT INTO registration VALUES ('00104', 1206, '', '', 'X');
  255. INSERT INTO registration VALUES ('00104', 1207, '', '', 'R');
  256. INSERT INTO registration VALUES ('00104', 1210, '', '', 'R');
  257. INSERT INTO registration VALUES ('00105', 1208, '', '', 'R');
  258. INSERT INTO registration VALUES ('00105', 1209, '', '', 'X');
  259. INSERT INTO registration VALUES ('00101', 1205, '', '', 'X');
  260. INSERT INTO registration VALUES ('00102', 1210, '', '', 'R');
  261. INSERT INTO registration VALUES ('00102', 1207, '', '', 'R');
  262. INSERT INTO registration VALUES ('00102', 1206, '', '', 'X');
  263.  
  264.  
  265. ALTER TABLE course
  266. ADD CONSTRAINT course_prereq_fk FOREIGN KEY(PreReq)
  267.     REFERENCES course(CourseId);
  268.  
  269. ALTER TABLE department
  270. ADD CONSTRAINT department_facultyid_fk FOREIGN KEY(FacultyId)
  271.     REFERENCES faculty(FacultyId);
  272.  
  273. CREATE TABLE emplevel
  274.     (LevelNo    NUMBER (1),
  275.     LowSalary   NUMBER (6),
  276.     HighSalary  NUMBER (6),
  277.     CONSTRAINT emplevel_levelno_pk PRIMARY KEY (LevelNo));  
  278.  
  279. CREATE TABLE position
  280.     (PositionId NUMBER (1),
  281.     PosDesc VARCHAR2 (10),
  282.     CONSTRAINT position_positionid_pk PRIMARY KEY (PositionId));
  283.  
  284. CREATE TABLE qualification
  285.     (QualId NUMBER (1),
  286.     QualDesc    VARCHAR2 (11),
  287.     CONSTRAINT qualification_qualid_pk PRIMARY KEY (QualId));
  288.  
  289. CREATE TABLE dept
  290.     (DeptId NUMBER (2),
  291.     DeptName    VARCHAR2 (12) NOT NULL,
  292.     Location    VARCHAR2 (15),
  293.     EmployeeId  NUMBER (3),
  294.     CONSTRAINT dept_deptid_pk PRIMARY KEY (DeptId));
  295.  
  296. CREATE TABLE employee
  297.     (EmployeeId    NUMBER (3),
  298.         Lname       VARCHAR2 (15) CONSTRAINT employee_lname_nn NOT NULL,
  299.     Fname       VARCHAR2 (15) CONSTRAINT employee_fname_nn NOT NULL,
  300.     PositionId  NUMBER (1),
  301.     Supervisor  NUMBER (3),
  302.         HireDate    DATE,
  303.     Salary      NUMBER (6),
  304.         Commission  NUMBER (5),
  305.         DeptId      NUMBER (2) NOT NULL,
  306.     QualId      NUMBER (1),
  307.     CONSTRAINT employee_employeeid_pk
  308.         PRIMARY KEY (EmployeeId),
  309.     CONSTRAINT employee_positionid_fk FOREIGN KEY (PositionId)
  310.         REFERENCES position (PositionId),
  311.     CONSTRAINT employee_deptid_fk FOREIGN KEY (DeptId)
  312.         REFERENCES dept (DeptId),
  313.     CONSTRAINT employee_qualid_fk FOREIGN KEY (QualId)
  314.         REFERENCES qualification (QualId));
  315.  
  316. CREATE TABLE dependent  
  317.     (EmployeeId     NUMBER (3),
  318.         DependentId NUMBER (1),
  319.     DepDOB  DATE,
  320.     Relation    VARCHAR2 (8),
  321.     CONSTRAINT dependent_empiddepid_pk PRIMARY KEY (EmployeeId, DependentId),
  322.     CONSTRAINT dependent_employeeid_fk FOREIGN KEY (EmployeeId)
  323.         REFERENCES employee (EmployeeId));
  324.  
  325. INSERT INTO position VALUES (1, 'President');
  326. INSERT INTO position VALUES (2, 'Manager');
  327. INSERT INTO position VALUES (3, 'Programmer');
  328. INSERT INTO position VALUES (4, 'Accountant');
  329. INSERT INTO position VALUES (5, 'Salesman');
  330.  
  331. INSERT INTO emplevel VALUES (1, 1, 25000);
  332. INSERT INTO emplevel VALUES (2, 25001, 50000);
  333. INSERT INTO emplevel VALUES (3, 50001, 100000);
  334. INSERT INTO emplevel VALUES (4, 100001, 500000);
  335.  
  336. INSERT INTO qualification VALUES (1, 'Doctorate');
  337. INSERT INTO qualification VALUES (2, 'Masters');
  338. INSERT INTO qualification VALUES (3, 'Bachelors');
  339. INSERT INTO qualification VALUES (4, 'Associates');
  340. INSERT INTO qualification VALUES (5, 'High School');
  341.  
  342. INSERT INTO dept VALUES (10, 'Finance', 'Charlotte', 123);
  343. INSERT INTO dept VALUES (20, 'InfoSys', 'New York', 543);
  344. INSERT INTO dept VALUES (30, 'Sales', 'Woodbridge', 135);
  345. INSERT INTO dept VALUES (40, 'Marketing', 'Los Angeles', 246);
  346.  
  347. INSERT INTO employee VALUES (111, 'Smith', 'John', 1, NULL,
  348.     TO_DATE ('04/15/1960', 'mm/dd/yyyy'), 265000, 35000, 10, 1);
  349. INSERT INTO employee VALUES (246, 'Houston', 'Larry', 2, 111,
  350.     TO_DATE ('05/19/1967', 'mm/dd/yyyy'), 150000, 10000, 40, 2);
  351. INSERT INTO employee VALUES (123, 'Roberts', 'Sandi', 2, 111,
  352.     TO_DATE ('12/02/1991', 'mm/dd/yyyy'), 75000, NULL, 10, 2);
  353. INSERT INTO employee VALUES (433, 'McCall', 'Alex', 3, 543,
  354.     TO_DATE ('05/10/1997', 'mm/dd/yyyy'), 66500, NULL, 20, 4);
  355. INSERT INTO employee VALUES (543, 'Dev', 'Derek', 2, 111,
  356.     TO_DATE ('03/15/1995', 'mm/dd/yyyy'), 80000, 20000, 20, 1);
  357. INSERT INTO employee VALUES (200, 'Shaw', 'Jinku', 5, 135,
  358.     TO_DATE ('01/03/00', 'mm/dd/yy'), 24500, 3000, 30, NULL);
  359. INSERT INTO employee VALUES (135, 'Garner', 'Stanley', 2, 111,
  360.     TO_DATE ('02/29/1996', 'mm/dd/yyyy'), 45000, 5000, 30, 5);
  361. INSERT INTO employee VALUES (222, 'Chen', 'Sunny', 4, 123,
  362.     TO_DATE ('08/15/1999', 'mm/dd/yyyy'), 35000, NULL, 10, 3);
  363.  
  364. INSERT INTO dependent VALUES (543, 1, TO_DATE ('09/28/1958', 'mm/dd/yyyy'),
  365.                     'Spouse');
  366. INSERT INTO dependent VALUES (543, 2, TO_DATE ('10/14/1988', 'mm/dd/yyyy'),
  367.                     'Son');
  368. INSERT INTO dependent VALUES (200, 1, TO_DATE ('06/10/1976', 'mm/dd/yyyy'),
  369.                     'Spouse');
  370. INSERT INTO dependent VALUES (222, 1, TO_DATE ('02/04/1975', 'mm/dd/yyyy'),
  371.                     'Spouse');
  372. INSERT INTO dependent VALUES (222, 2, TO_DATE ('08/23/1997', 'mm/dd/yyyy'),
  373.                     'Son');
  374. INSERT INTO dependent VALUES (222, 3, TO_DATE ('07/10/1999', 'mm/dd/yyyy'),
  375.                     'Daughter');
  376. INSERT INTO dependent VALUES (111, 1, TO_DATE ('12/12/1945', 'mm/dd/yyyy'),
  377.                     'Spouse');
  378.  
  379. ALTER TABLE dept
  380. ADD CONSTRAINT dept_employeeid_fk FOREIGN KEY(EmployeeId)
  381.     REFERENCES employee(EmployeeId);
  382.  
  383. ALTER TABLE employee
  384. ADD CONSTRAINT employee_supervisor_fk FOREIGN KEY(Supervisor)
  385.     REFERENCES employee(EmployeeId);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top