Part 1. Given the following employee database:
Employee (employee_ID, employee_name, street, city, zip, manager_ID)
Works (employee_ID, company_ID, hire_date, salary)
Company (company_ID, company_name, city)
Where the primary keys are underlined with a solid line and any foreign keys are underlined with a dashed line, give an expression in SQL for each of the following queries:
(a) Find the names and cities of residence of all employees who work for ABC Corporation.
(b) Find the names, street addresses, and cities of residence of all employees who work for ABC Corporation and earn more than $10,000.
(c) Find all employees in the database who do not work for ABC Corporation.
(d) Find all companies located in the city in which ABC Corporation is located.
(e) Find all employees hired on or after January 1, 2010. (Note: make sure to use a function on the date column to ensure the date formats in the condition statement match)
Part 2. The Oracle Instance and Transaction/Query Processing
(a) Illustrate and detail the architecture of the Oracle instance, including all memory structures, processes, and associated physical files.
(b) Explain how transactions are processed by the Oracle DBMS.
(c) Explain how queries are processed by the Oracle DBMS.