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_LocationsInclude a second query to display from the View after it is created.Refer to the attached for the table. Employees-OH-O+PK employee_idManagesfirst_namelast_nameemailphone_numberhire_datejob_id [FK]salarycommission_pctmanager_id [FK]department_id [FK]-HeadsRegionsPK region_idregion_nameHiredHo -Grouped-O+ PK job_idjob_titlemin_salarymax_salary-Attached-OJobsDepartmentsO+ PK department_idXEdepartment_namemanager_id [FK]location_id [FK]CountriesPK country_idcountry_nameregion_id [FK]PKDetailed PKHo-LocatedHo-ResidesJob Historyemployee_id [FK]start_dateend_datedepartment_id [FK]job_id [FK]-Associated-Locationso+ PK location_idstreet_addresspostal codecitystate_provincecountry_id [FK]

SQL Query:- A query is a request for data or information from a database table or set of databases.…

Answered: Create a View to show the city name of…

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

See similar textbooks

Related questions

Concept explainers

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]

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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