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

Region (RegionId, RegionName)

Manager (ManagerId, ManagerName, ManagerAddress, Salary)

Branch (BranchId, BranchName, Location, RegionId, ManagerId)

Product (ProductId, Description, UnitPrice, VatRage)

BranchStock (BranchId, ProductId, StockOnHand, MinStockLevel)

Customer (CustCode, CustName, CustAddress)

Sale (SaleNo, CustCode, BranchId, ProductID, QtySold)

Write SQL queries to answer the following:

(a) List the locations of all branches in the region with Region Id DUBLIN.

(b) List the BranchId and BranchName for the Branch managed by Adam Murphy.

(c) The branch with branchId D321 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 m001 to Clanbrassill st, Dublin, Ireland.