Create a View to show the city name of any location that has a department. Only show the city name once in the results. You must use a non-correlated subquery. Call this view: Department_Locations Include a second query to display from the View after it is created. Refer to the attached for the table.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Create a View to show the city name of any location that has a department. Only show the city name once in the results. You must use a non-correlated subquery.
Call this view: Department_Locations

Include a second query to display from the View after it is created.

Refer to the attached for the table.

Employees
-OH
-O+PK employee_id
Manages
first_name
last_name
email
phone_number
hire_date
job_id [FK]
salary
commission_pct
manager_id [FK]
department_id [FK]
-Heads
Regions
PK region_id
region_name
Hired
Ho -Grouped
-O+ PK job_id
job_title
min_salary
max_salary
-Attached-
O
Jobs
Departments
O+ PK department_id
XE
department_name
manager_id [FK]
location_id [FK]
Countries
PK country_id
country_name
region_id [FK]
PK
Detailed PK
Ho
-Located
Ho-Resides
Job History
employee_id [FK]
start_date
end_date
department_id [FK]
job_id [FK]
-Associated-
Locations
o+ PK location_id
street_address
postal code
city
state_province
country_id [FK]
Transcribed Image Text:Employees -OH -O+PK employee_id Manages first_name last_name email phone_number hire_date job_id [FK] salary commission_pct manager_id [FK] department_id [FK] -Heads Regions PK region_id region_name Hired Ho -Grouped -O+ PK job_id job_title min_salary max_salary -Attached- O Jobs Departments O+ PK department_id XE department_name manager_id [FK] location_id [FK] Countries PK country_id country_name region_id [FK] PK Detailed PK Ho -Located Ho-Resides Job History employee_id [FK] start_date end_date department_id [FK] job_id [FK] -Associated- Locations o+ PK location_id street_address postal code city state_province country_id [FK]
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education