Part 1 1. The staff in the HR department wants to hide some of the data in the EMPLOYEES table They want a view called EMPLOYEES_VU based on the employee numbers, employee names, and department numbers from the EMPLOYEES table. They want the heading for the employee name to be EMPLOYEE. 2. Confirm that the view works. Display the contents of the EMPLOYEES_VU view. EMPLOYEE ID EMPLOYEE DEPARTMENT ID 1 100 King 90 2 101 Kochhar 90 3 102 De Haan 103 Hunold 60 5 104 Ernst 60 19 205 Higgins 110 20 206 Gietz 110 4) 8 8 8 8 8

Part 1 1. The staff in the HR department wants to hide some of the data in the EMPLOYEES table They want a view called EMPLOYEES_VU based on the employee numbers, employee names, and department numbers from the EMPLOYEES table. They want the heading for the employee name to be EMPLOYEE. 2. Confirm that the view works. Display the contents of the EMPLOYEES_VU view. EMPLOYEE ID EMPLOYEE DEPARTMENT ID 1 100 King 90 2 101 Kochhar 90 3 102 De Haan 103 Hunold 60 5 104 Ernst 60 19 205 Higgins 110 20 206 Gietz 110 4) 8 8 8 8 8

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Q1Create a view named v_Title_Unavailable.The view should show the movie titles and media_id of the media not returned yet. The view should not allow any DML operationsQ2Create a SYNONYM for v_Title_Unavailable named vTU.Q3Write SQL to query the view using the synonym.
1. Create a view that lists the name and phone number of the contact person at eachpublisher. Don’t include the publisher’s ID in the view. Name the view CONTACT. SQL commands
Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.
Write a SQL script that performs the following. Creates an updatable view based on the employee table. The view must contain the following features Rename all of the columns Display all "manager" records Insert 5 new records into the base table (using the view) Display all the view records using the base table (to verify that the view performed the inserts)
please use the picture to answer the following question Normalize below user view to the third normal form. Show all steps (UNF, 1NF, Dependencies, 2NF, 3NF).
Use UStayWell Student Accommodation Database to answer the following questions A. Create a view named MAJOR_CUSTOMER. It consists of the customer ID, first name, last name,balance, credit limit, and rep ID for every customer whose credit limit is $500 or less.Write and execute the CREATE VIEW command to create the MAJOR_CUSTOMER view. B. Write and execute the CREATE VIEW command to create the ITEM_INVOICE view. C. List all the views contained within the system catalog.