Identify following concepts$/$table names$/$attributes$.$

$(1)$ In this star schema, what are$($is$)$ the fact$($s$)?$

$(2)$ In this star schema, what are$($is$)$ the dimension$($s$)?(3)$ In this star schema, what are$($is$)$ the surrogate key$($s$)?(4)$ TREC starts to collect data about their branch location by linking city and region tables with the branch table as ER Diagram suggested.

If TREC wants to analyze the sales $($subject of analysis$)$ data based on branch city, region, and county, how should you update the previous star schema?The CEO of TREC wants to compare the average selling price, average sale commissions, and total sale revenue where the branch type is "Franchise," the property location is in $"37405,"$ and the sales were signed between July, August, and September of the year $2022.$ Please construct the SQL to make such business reports.The marketing department of TREC confirmed that it would create a data warehouse that is not only able to analyze sales $($subject of analysis$)$ but also to track advertisement costs $($subject of analysis$).$ TREC calculates each campaign budget based on time, property, branch, and promotion to track advertising costs. Please extend the previous data mart to a new data warehouse $($show the entire schema $-$ the new schema should have all the information in Q$1.(4)$ as well.$).$