Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Urgently needed COUNTRIES (COUNTRY_ID, COUNTRY_NAME, REGION_ID) Primary Key: COUNTRY_ID DEPARTMENTS (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID): Primary key. DEPARTMENT_ID EMPLOYEES ( EMPLOYEE_ID , FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
Urgently needed
COUNTRIES (COUNTRY_ID, COUNTRY_NAME, REGION_ID) Primary Key: COUNTRY_ID DEPARTMENTS (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID): Primary key. DEPARTMENT_ID EMPLOYEES ( EMPLOYEE_ID , FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE.JOB_ID. SALARY, MANAGER_ID, DEPARTMENT_ID); Primary Key: EMPLOYEE_ID JOBS (JOB_ID. JOB_TITLE, MIN_SALARY, MAX_SALARY ) Primary Key: Job_ID LOCATIONS LOCATION_ID , ADDRESS, CITY, COUNTRY_ID ); Primary Key: Location_ID Write an SQL query to display details of departments in which the maximum salary is more than 10000. Write an SQL query to display department name and number of employees in the department Write a PL/SQL Function countEmpDepts that takes as input dept ID and it returns the number of all current employees working in this department. Return-1 if the department ID is not in the department tableStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started