1) Create table Dept and Emp with the following Constraints
Dept Emp
Field Name Date Type
Field Name Data Type
Deptno Number2(2) Empno Number(4)
Dname Varchar2(8) Ename Varchar2(30)
Location Varchar2(15) Job Varchar2(10)
DOJ Date
Sal Number(8,2)
Comm Number(3)
Deptno Number(2)