1. Strategic Insights: Based on the information provided, identify current and future strategic decision-making scenarios for a Smart City initiative of the Melbourne City Council. (5 Marks) 2. SQL: Using the given ER diagrams, compile SQL statements to address five decision making needs identified above. Demonstrate your competency in using advanced SQL concepts and syntax, and you are free to make any assumptions with reasonable justification. (5 Marks) 3. Data Warehouse Design: Follow Kimball's four step approach to create a data warehouse design. You must determine the required number of dimensional models, with justification. Each dimensional model should be further improved by applying fact table and dimension table techniques. Demonstrate how the warehouse design facilitates insights generation for current and future decision-making scenarios. (15 Marks) 4. 5G Networking: Determine five use cases for the application of 5G and Edge computing technologies within a Smart City context. Provide adequate technical detail and examples that demonstrate your competence in the technologies