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 should use Staff2 table and the output column name should be (E_fName, E_pos, M_fName, M_pos).

-Create a view vHW1_#_xxxx listing all the cities and the male staff names working there. If a 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.

Create a view vHW1_#_xxxx listing the project name, staff name and the staffs 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 lname with a space in between.

Staff 2:

Branch:

Working Table:

Project:

11. (10 pts) Create a view vHw1_#_xxxx 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 should use Staff2 table and the output column name should be (E_ Name, E_pos, M_fName, M_pos). 12. (10 pts) Create a view vHW1_#_xxxx listing all the cities and the male staff names working there. If a 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. 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, Staff, 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. - mysql> select * from Project; | pcode | name | city + | PO1 | Kean University | Union | PO2 | Citi Bank | NYC PO3 | British Museum | London PO4 | Buckingham Palace | London | PO5 | Granite | Aberdeen + - + 5 rows in set (0.00 sec) 11. (10 pts) Create a view vHw1_#_xxxx 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 should use Staff2 table and the output column name should be (E_ Name, E_pos, M_fName, M_pos). 12. (10 pts) Create a view vHW1_#_xxxx listing all the cities and the male staff names working there. If a 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. 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, Staff, 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. - mysql> select * from Project; | pcode | name | city + | PO1 | Kean University | Union | PO2 | Citi Bank | NYC PO3 | British Museum | London PO4 | Buckingham Palace | London | PO5 | Granite | Aberdeen + - + 5 rows in set (0.00 sec)