Case 1 - New York University

Appendix: DDL statement of tables and views in case study. Oracle Database: CREATE TABLE SYSADM.PS_JOB ( EMPLID VARCHAR2(11) NOT NULL, EMPL_RCD NUMBER NOT NULL, EFFDT DATE NOT NULL, EFFSEQ NUMBER NOT NULL, DEPTID VARCHAR2(10) NOT NULL, JOBCODE VARCHAR2(6) NOT NULL, ................
................