Question: Create and test a view called EmployeeDepartmentDataView that contains the employee name concatenated and formatted as LastName, FirstName in a field named EmployeeName, EMPLOYEE.Department, DEPARTMENT.OfficeNumber,DEPARTMENT.Phone

Create and test a view called EmployeeDepartmentDataView that contains the employee name concatenated and formatted as LastName, FirstName in a field named EmployeeName, EMPLOYEE.Department, DEPARTMENT.OfficeNumber,DEPARTMENT.Phone as DepartmentPhone, and EMPLOYEE.Phone as EmployeePhone. Run this statement to create the view, and then test the view by writing and running an appropriate SQL SELECT statement.

Step by Step Solution

★★★★★

3.35 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

CREATE VIEW Employee DepartmentDataView AS SELECT dbo LastNameFirst EFirstName E LastName AS EmployeeName FROM E Department DOfficeNumber D Phone AS D... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database Processing Fundamentals Questions!

Create a view called HOMEWORK13 that includes the columns named Col1 and Col2 from the FIRSTATTEMPT table. Make sure the view is created even if the FIRSTATTEMPT table doesnt exist.

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...

Write an SQL statement to create a view named CombinedNameEmployeePhoneView that shows the values of EMPLOYEE.LastName, EMPLOYEE.FirstName, and EMPLOYEE.Phone as EmployeePhone, but that combines...

please help me with the queries M10_Chap7_RQ_WPC-Database Lab , the possible thank you. 7.57 Write an UPDATE statement to change the phone number of employee with EmployeeNumber 11 to 360-287-8810....

S10_Chap7_RQ_WPC-Database Lab This assignment is from the Kroenke book Chap 7 Review Questions (RQ). Create a new folder, WPC-Database, in the Projects folder, found in the SQL Server Management...

A. Write an SQL statement to create a view called SaleSummaryView that contains SALE.SaleID, SALE.SaleDate, SALE_ITEM.SaleItemID, SALE_ITEM.ItemID, ITEM.ItemDescription, and ITEM.ItemPrice. Run the...

Consider the following model: Check the Assignment 3 solution and compare it with your work. Make necessary changes to your work, if needed. Use the attached SQL script named HSD - Insert - Data.sql...

A) Write an SQL statement to create a view called SaleSummaryView that contains SALE.SaleID, SALE.SaleDate, SALE_ITEM.SaleItemID, SALE_ITEM.ItemID, ITEM.ItemDescription, and ITEM.ItemPrice. Run the...

For this set of Review Questions, we will create and use a database for the Wedgewood Pacific Corporation (WPC) that is similar to the Microsoft Access database we created and used in Chapters 1 and...

Bacteria and other microbes can be used to "clean up" an oil spill by breaking down oil into carbon dioxide and water. Two samples isolated from the Deepwater Horizon leak in the Gulf of Mexico were...

How do i make a ER digram like similar to the following using my relational model Applicant ID Has Applicants Give Employer ID Applications ID Applications Apply Have Interview Applicant ID Interview...

1. How does a thin layer of water on the road affect the light you see reflected off the road from your own headlights? How does it affect the light you see reflected from the headlights of an...

What interest rate is used when the fan lands money to banks a no interest rate be discount rate CD default rate for D Federer funds rate

1.3 Develop a constant sum scale to determine preferences for restaurants. Administer this scale to a pilot sample of 20 students to determine their preferences for some of the popular restaurants in...

Suppose the method quickSortInPlace is executed on a sequence with duplicate elements. Prove that the algorithm still correctly sorts the input sequence. What happens in the partition step when there...

Consider a modification of the deterministic version of the quick-sort algorithm where we choose the element at index n/2 as our pivot. Describe the kind of sequence that would cause this version of...

Suppose we modify the deterministic version of the quick-sort algorithm so that, instead of selecting the last element in an n-element sequence as the pivot, we choose the element at index n/2. What...

Laiho Industries's 2020 and 2021 balance sheets (in thousands of dollars) are shown. Do not round intermediate calculations. Enter your answers in thousands. For example, an answer of $1 thousand...

Big Sky Hospital plans to obtain a new MRI that costs $ 1 . 5 million and has an estimated four - year useful life. It can obtain a bank loan for the entire amount and buy the MRI or it can lease the...

Present Worth and Capitalized Cost What is the capitalized cost of $60,000 in year 0, $150,000 in year 2 and a uniform annual amount of $50,000 per year forever, beginning in year 5? Use an interest...