SQLCreate a view called EMP_VU based on the employee number, employee name, and department number from the EMP table. Change the heading for the employee name to EMPLOYEE. Display the contents of the EMP_UV view.Select the view name and text from the data dictionary USER_VIEWS.Using your EMP_UV, enter a query to display all employee names and department numbers.Create a view named DEPT20 that contains the employee number, employee name, and department number for all employees in department 30. Label the view columns EMPLOYEE_ID, EMPLOYEE, and DEPARTMENT_ID. Do not allow an employee to be reassigned to another department through the view.Display the structure and contents of the DEPT20 view. Attempt to reassign Turner to department 20.Create a view called SALARY_VU based on the employee name, department name, salary, and salary grade for all employees. Label the column Employee, Department, Salary, and Grade, respectively.

SQL Create a view called EMP_VU based on the employee number, employee name, and department number…

Answered: te a view called EMP_VU based on the…

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

100%

SQL

Create a view called EMP_VU based on the employee number, employee name, and department number from the EMP table. Change the heading for the employee name to EMPLOYEE. Display the contents of the EMP_UV view.
Select the view name and text from the data dictionary USER_VIEWS.
Using your EMP_UV, enter a query to display all employee names and department numbers.
Create a view named DEPT20 that contains the employee number, employee name, and department number for all employees in department 30. Label the view columns EMPLOYEE_ID, EMPLOYEE, and DEPARTMENT_ID. Do not allow an employee to be reassigned to another department through the view.
Display the structure and contents of the DEPT20 view. Attempt to reassign Turner to department 20.
Create a view called SALARY_VU based on the employee name, department name, salary, and salary grade for all employees. Label the column Employee, Department, Salary, and Grade, respectively.

Expert Solution

Step by step

Solved in 2 steps with 6 images

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