b) Consider the following database schema: c) Employees (emp_id, name, hire_date, job_id, salary, comm, manager_id, dept_id)...

 

Transcribed Image Text:

b) Consider the following database schema: c) Employees (emp_id, name, hire_date, job_id, salary, comm, manager_id, dept_id) Departments (dept_id, dept_name, manager_id, location_id) Location(location id, street, post_code, city, state, country) Analysis the database using E-R diagram. Students are advised to complete all relationship and entity properly. Write the below SQL queries considering the database schema of question 1(b): ii. Display the department number, name, job and department name for all employees in the CSE department. Write a query to display the employee name and hire date for all employees in the same department as Mr. X. b) Consider the following database schema: c) Employees (emp_id, name, hire_date, job_id, salary, comm, manager_id, dept_id) Departments (dept_id, dept_name, manager_id, location_id) Location(location id, street, post_code, city, state, country) Analysis the database using E-R diagram. Students are advised to complete all relationship and entity properly. Write the below SQL queries considering the database schema of question 1(b): ii. Display the department number, name, job and department name for all employees in the CSE department. Write a query to display the employee name and hire date for all employees in the same department as Mr. X.