SQL Practical Question
Create table “EMP” as per the following specification: COLUMN NAME DATATYPE SIZE CONSTRAINTS Emp_No Integer 4 Primary Key Emp_Name Varchar2 20 Not Null Job Varchar2 10 Hiredate Date dd-mm-yyyy Salary Float 10,2 Salary>10000 Commission Integer 4 DeptNo Integer 2 10,20 or 30 Job Types are: · President · Manager · Clerk · Salesman Commission given only to ‘salesman’. QUESTIONS 1) Create the above table including its constraints. 2) ...