Tag Archives: DBMS

DBMS Worker and Division – Study from Tutorial

DBMS Worker and Division Resolution Creating division desk. CREATE TABLE DEPARTMENT ( DEPTNO NUMBER(10) CONSTRAINT DEPARTMENT_DEPTNO_PK PRIMARY KEY, DEPTNAME VARCHAR2(20) CONSTRAINT DEPARTMENT_DEPTNAME_UN UNIQUE, LOCATION CHAR(15) CONSTRAINT DEPARTMENT_LOCATION_ NOT NULL ); Enter fullscreen mode Exit fullscreen mode Creating worker desk. CREATE TABLE EMPLOYEE ( EMPNO NUMBER(10) CONSTRAINT EMPLOYEE_EMPNO_PK PRIMARY KEY, EMPNAME VARCHAR2(20) CONSTRAINT EMPLOYEE_EMPNAME_UN UNIQUE, DEPTNO…

Read More