Question: Staff 2 Branch Working Project 13. (10 pts) Create a view vHW1_#_xxxx listing the project name, staff name and the staff's branch city for the

Staff 2 Branch Working Project 13. (10 pts) Create a view

Staff 2

vHW1_#_xxxx listing the project name, staff name and the staff's branch city

Branch

for the same staff who working on the same project more than

Working

one time. You should use Project, Staff2, Branch, and Working tables. The

Project

output column header should be (Project_name, Staff_name, Branch_city). The staff_name should combine

13. (10 pts) Create a view vHW1_#_xxxx listing the project name, staff name and the staff's branch city for the same staff who working on the same project more than one time. You should use Project, Staff2, Branch, and Working tables. The output column header should be (Project_name, Staff_name, Branch_city). The staff_name should combine fname and Iname with a space in between. staffNo | fName | IName | position | sex | DOB | salary | branchNo | superno | ABC1 CCl SA9 SG14 SG37 SG5 SL21 SL41 XYL | New | Enginer | Intern IM | Super | User | DBA | M | Mary | Howe | Assistant IF | David | Ford | Supervisor | M Ann | Beech | Assistant | F | Susan | Brand | Manager | F | John | White | Manager IM | Julie | Lee | Assistant IF | New Tester | Assistant |M | 2000-01-01 | 9000.00 | B002 | 1995-01-01 | 90000.00 | B005 | 1970-02-19 | 9000.00 | B007 | 1958-03-24 | 18000.00 | B003 | 1960-11-10 | 12000.00 | B003 | 1940-06-03 | 24000.00 | B003 | 1945-10-01 | 30000.00 | B005 | 1965-06-13 | 9000.00 | B005 | 1990-01-01 | 8000.00 | B002 | SL21 | SG14 | SG5 | SG5 | SG5 | SL21 | NULL | SL21 | SL21 | | branchNo | street | city | postcode +-- | B002 | 56 Cover Drive | London | NW10 6EU | B003 | 163 Main Street | Glasgow | Gil 90X | B004 | 32 Manse Road | Bristol | BS99 INZ | B005 | 22 Deer Road | London | SW 4EH | B007 | 16 Argyll Street | Aberdeen | AB2 3SU + | pcode | staffNo 1 year + | PO1 | ABCl | 19801 | PO1 | ABCl | 2010 | | Poi | SGS | 2000 | | PO2 | XY1 | 2014 | | PO2 | SG5 | 2002 | PO2 | SGS | 2018 | | PO2 | SL21 | 2006 | | P03 | ABC | 1995 | | P03 | SG37 | 1995 | | P03 | SG14 | 2003 | | P03 | cci | 1990 | | PO3 | CCI | 2019 | - + | pcode | name | city 1 +--- --+- | POI | | Kean University | Union | PO2 | Citi Bank | NYC | P03 | British Museum | London | PO4 | Buckingham Palace | London | | P05 | | Granite | Aberdeen | --+

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Databases Questions!

Staff 2 Table Branch Table 12. (10 pts) Create a view vHW1_#_xxxx listing all the cities and the male staff names working there. Ifa city does not have any staff, that city should be still in the...

Staff2 Branch Pls can you give steps and screenshot on how to do it. I want to learn from it 12. (10 pts) Create a view vHW1_#_xxxx listing all the cities and the male staff names working there. Ifa...

Question: Create a view vHW1_#_xxxx listing the first name, position and their manager's first names and positions for all male staff who work at London. The output header needs to distinguish...

Question: listing the first name, position and their manage first names and positions for all male staff who work at London. The output header needs to distinguish between staff and manger. You...

2. (10 pts) Create a view vHW1_2_xxxx listing the first name, last name and salary for staff who has last name ending with 'e'. The output should be alphabetically ordered from high to low by the...

Staff2 Branch Working Project Pls can you give steps and screenshot on how to do it. I want to learn from it 13. (10 pts) Create a view vHW1_#_xxxx listing the project name, staff name and the...

D. Please implement your answers in the database CPS3740_2019S on imc.qqqq.edu server. E. You have to refer to tables Staff, Hotel, Room, Booking, Guest in database CPS3740 on imc.qqqq.edu server. F....

Please help me make an Executive Summary. Explain what you will examine in the case study. Write an overview of the field you are researching. Make a thesis statement and sum up the results of your...

You and your team have been working on a project for several months and are about 50% complete. Today is July 1, 2022. When you came into work this morning, your boss told you, that your project was...

Read the following discussion and give your response: Privacy for cell phone users has been under scrutiny by the Fair Trade Commission for several years. The five principles the F.T.C. has set forth...

You produce widgets. Currently you produce 4 widgets at a total cost of $40. a. What is your average total cost? b. Suppose you could produce one more (the fifth) widget at a marginal cost of $5. If...

La empresa el Financiero de C.V. analiza diferentes escenarios para determinar cul es el ms conveniente, a fin de tomar la decisin de aceptar un descuento ofrecido por un proveedor con un plazo de...

Formalize the following argument by using the given predicates and then rewriting the argument as a numbered sequence of statements. Identify each statement as either a premise, or a conclusion that...

3. Is IBMs program really a mentoring program? Why or why not?

4 The categories of scarce resources and the nature of the economic problem.

5 About production possibilities analysis, increasing opportunity costs, and economic growth.