SQLANSWERED -- 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.ANSWERED --Select the view name and text from the data dictionary USER_VIEWS.ANSWERED -- Using your EMP_UV, enter a query to display all employee names and department numbers.ANSWERED -- 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.ANSWERED -- 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.

VIEW In SQL a view is a virtual table based on the result set of an SQL statement. a view contains…

Answered: SQL ANSWERED -- Create a view called…

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

SQL

ANSWERED -- 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.
ANSWERED --Select the view name and text from the data dictionary USER_VIEWS.
ANSWERED -- Using your EMP_UV, enter a query to display all employee names and department numbers.
ANSWERED -- 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.
ANSWERED -- 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

Trending now

This is a popular 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