Reference no: EM13750605
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.
|
What is a relational database
: What is a relational database-Write a 1500 word essay on the above question. Your response should include the evolution of 1st generation data models
|
|
Underpaid given the current market
: Your babysitter claims that she is underpaid given the current market. Her hourly wage is $12 per hour. You do some research and discover that the average wage in your area is $14 per hour with a standard deviation of 1.9.
|
|
Advantages and disadvantages of a database system
: Describe the major advantages and disadvantages of a database system approach to managing data
|
|
Planning for capacity at the restaurant
: Mario, one of the owners of Mi Casa Front Porch Restaurant was looking to improve his planning for capacity. In order to do this, he wanted to understand the probability of people in each party coming to the restaurant. If the mean number of people p..
|
|
Find all employees in the database
: Find the names and cities of residence of all employees who work for ABC Corporation
|
|
Features proper parallel structure
: The inculcation of these values would ensure the survival of the Republic and the stability of the social order. Mid-nineteenth-century public schools and private colleges were expected to furnish the mind, strengthen the moral character, and prep..
|
|
Explain the role of the federal government
: Explain The role of the federal government in the lives of the American people changed dramatically from the time of the country's founding to the present.
|
|
Direct mail advertisers send solicitation junk mail
: Direct mail advertisers send solicitation junk mail to thousands of potential customer hoping that some will buy the company's product. The response rate is usually quite low. Suppose a company wants to test the response to a new flyer and sends it t..
|
|
A company that sends technicians to individuals
: The Nerd Herd (TNH), a company that sends technicians to individuals' residences to fix problems with personal computers, has had considerable success in growing its business throughout the U.S. Upper Midwest region. Now TNH is looking for further ex..
|