Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 3SUStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started