1. Given the following table, create a view named "names" to contain the first and lastnames for all employees.Employee (ID, first_name, last_name, position)ID123first name last_namePaskierTakiBioretNicolasRachadLaylapositionProject ManagerComputer EngineerHR2. Modify the previous view to select only the first and last names of employees with theposition "Project Manager."3. Delete the view "names"

Given that, Name of the table is Employee The attributes of Employee table ID, first_name,…

1. Given the following table, create a view named "names" to contain the first and last names for all employees. Employee (ID, first_name, last_name, position) ID 1 23 www first name Nicolas Rachad Layla last name Paskier Taki Bioret position Project Manager Computer Engineer HR Modify the previous view to select only the first and last names of employees with the position "Project Manager." Delete the view "names"

1. Given the following table, create a view named "names" to contain the first and last names for all employees. Employee (ID, first_name, last_name, position) ID 1 23 www first name Nicolas Rachad Layla last name Paskier Taki Bioret position Project Manager Computer Engineer HR Modify the previous view to select only the first and last names of employees with the position "Project Manager." Delete the view "names"

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

Similar questions

Create a read-only view, name it as ViewD, that will contain RType and the number of rooms per RType in the ROOMS table.
Create a view named Refill_Due. It should consist of the patient id, dateofvisit, rxid, and the dosage for every medicine prescribed that requires refilling. Prefix the columns in the view with “RD”. For example, the PATIENTID in the table becomes RD_PATIENTID in the view. Use select statement to display the records from the view just created. See the output below and match your results to the sample output.
Which view is used to filter and look at the data in a table, without changing the structure of the file? O Report Data Dashboard O Model
When you create a Details view, what determines the type of control to which a column is bound?
2. Create a view named Top10PaidInvoices that returns three columns for each vendor: VendorName, LastInvoice (the most recent invoice date), and SumOfInvoices (the sum of the InvoiceTotal column). Return only the 10 vendors with the largest SumOfInvoices and include only paid invoices.
Show how to create a view tot credits (year, num credits) that returns the total amount of credits taken in each year.
-- 2 - Write a View to show all customer Ids that have placed orders --(Sales.SalesOrderHeader sh and Person. Person are joined on CustomerID = Business EntityID)
6. Create a list of all book titles and costs. Precede each book’s cost with asterisks so that thewidth of the displayed Cost field is 12. SQL commands
create a view named major_ customer. it comsists of the customer num, name, balance, credit_limit and rep_num and rep_num for every customer whose credit_limit is 10000 or less.
I am working on Task 7. Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of bedrooms, the second is the average square feet, and the third is the average monthly rent for all properties in the PROPERTY table that have that number of bedrooms. Use BEDROOMS, AVG_SQUARE_FEET, and AVG_MONTHLY_RENT as the column names. Group and order the rows by number of bedrooms. Here is Tasks 1-7 and what I wrote for Task 8. When I input Task 8, I am not getting results at all. Expected Results Tables_in_StayWell Table_type MONTHLY_RENTS VIEW
Create the following queries and stored procedures: 3.3 A view that displays customer, address and credit limit.
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.