Ex.1
Employee(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,Date of
Joining(DOJ), JOB_ID ,SALARY , COMMISSION, MANAGER_ID , DEPARTMENT_ID)
Department(department -id, manager -id,department -name)
Include the necessary constraints NOT NULL, DEFAULT, CHECK.
Set primary and foreign key references for employee, department and job table.
1. Write a SQL statement to create a table named jobs including columns job_id, job_title,
min_salary, max_salary and check whethe...
Get Answer