Part 1. Given the following employee database: Employee ( employee_name , street
ID: 3540839 • Letter: P
Question
Part 1. Given the following employee database:
Employee (employee_name, street, city)
Works (employee_name, company_name, salary)
Company (company_name, city)
Manages (employee_name, manager_name)
Where the primary keys are underlined, 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) Assume that the companies may be located in several cities. Find all companies located in every city in which ABC Corporation is located.
(e) Find the company that has the most employees.
Part 2. The Oracle Instance and Transaction/Query Processing
(a) Illustrate 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.
Explanation / Answer
okk