Question: 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

Staff 2 Table Branch Table 12. (10 pts) Create a view

Staff 2 Table

vHW1_#_xxxx listing all the cities and the male staff names working there.

Branch Table

Ifa city does not have any staff, that city should be still

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 output. You should use Staff2 and Branch table and the output column name should (city_name, staff_name). The staff_name should combine fname and lname 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

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!

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...

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 same staff who working on the same project more than one...

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...

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...

Staff 2 Table 9. (10 pts) Create a view vHW1_#_xxxx listing the lowest salary for each gender. You must use UNION operation and Staff 2 table. The output column name should be (gender, name, age,...

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....

1. - Expain the motivations of Unilever in acquiring Inmarko. - Identify the risks Unilever faces in using acquisition as a mode for growth, as opposed to other modes discussed in the chapter. 2....

Management, science, also known as ___, is a field of applied mathematics. a. Operations research b. Management accounting c. Exchange commission d. System theory

A chain of length L and total mass M is released from rest with its lower end just touching the top of a table, as in Figure P9.71a. Find the force exerted by the table on the chain after the chain...

Darth Vader is looking at increasing its current ratio to meet the industry benchmarks. From the list of items below, what would increase Darth Vader s current ratio? Group of answer choices An...

intro Consider a project with a 3-year life and no salvage value. The initial cost to set up the project is $100,000. This amount is to be linearly depreciated to zero over the life of the project....

KEY QUESTION Suppose a pure monopolist is faced with the demand schedule shown below and the same cost data as the competitive producer discussed in question 4 at the end of Chapter

KEY QUESTION Use the following demand schedule to determine total revenue and marginal revenue for each possible level of sales: a. What can you conclude about the structure of the industry in which...

KEY QUESTION Using diagrams for both the industry and a representative firm, illustrate competitive long-run equilibrium. Assuming constant costs, employ these diagrams to show how ( a ) an increase...