However, the ER diagram currently does not allow these queries to be easily answered using dimensional modeling. Specify a single relationship (one line between two entities) that if added to the diagram would allow both of these types of queries to be modeled using dimensional modeling. What would be the cardinality of the relationship? e. Create a high-level star schema (i.e., no attributes are needed) to be able to efficiently answer queries similar to the following: What is the total daily time spent in procedures (e.g., the number of minutes) in the surgical departments for patients from Texas over the past five years? Be sure to specify the granularity of the fact in your answer. You can create the star schema by clicking Insert > Drawing > New from within Google Docs, and drawing the relevant fact tables and dimensional tables. Other methods (drawing them by hand and pasting them into your submission) are also acceptable.Problem 4 (2 points) Consider the following diagram that represents a database for a global hospital system: Country State City Postal Area Hospital Prescription Dosage Patient Doctor Drug Supplier Salary Symptom Admission Drug Type Procedure Type Symptom Type Procedure Room Department The hospital system wants to be able to run various OLAP queries across various metrics, broken down by various dimensions and timescales. a. Which of the entities are transaction entities? b. Which of the entities are component entities? c. Which of the entities are classification entities? d. The hospital wants to be able to run queries similar to the following