The following set of relations describes a sales system, in which the primary keys have been underlined, and foreign keys highlighted in red:

Region $($Region$!$D$,$ RegionName$)$

Manager $($ManagerID ManagerName, ManagerAddress, Salary$)$

Branch $($BranchID$,$ BranchName Location, BegionIld MadagerID$)$

Product $($ProductID$,$ Description, UnitPrice, YatRage$)$

BranchStock $($BranchDD$,$ ProductJD. StockOnHand, MinStockLexel$)$

Customer $($CustCode CustName CustAddress$)$

Sale $($SaleNo CustCode BranchJD. ProductID. QtySold$)$

Write SQL queries to answer the following:

$($a$)$ List the locations of all branches in the region with RegionName "Munster".

$($b$)$ List the BranchID and BranchName for the Branch managed by John Smith.

$($c$)$ The branch with branchID $\text{'}$L$123"$ is closing down. Delete all the sales records for this branch.

$($d$)$ The company is organizing a business lunch for customers and managers. Prepare one list that includes both managers and clients, showing their names and addresses.

$($e$)$ Update address of a manager with ManagerID $"$m$008"$ to "Dublin $8,$ Dublin, Ireland".