specification: Design a data mart solution for the European Centre for Disease Prevention and Control (ECDC) to monitor the daily number of new reported COVID-19 cases and deaths, intensive care unit cases and vaccination progress across the EU/EEA area. Information regarding Quarantine, Vaccination, Infection, Drug Treatment and Patient Recording processes is logically described with the aid of four UML class diagrams as a fact constellation schema of the pandemic data warehouse shown in Fig.1. Fig. 1 The fact constellation schema of the pandemic data warehouse The European health authorities would like to build a strategic data mart to answer some frequent queries the managers must answer are the following.: Q1. For each venue and year report the vaccination rates per vaccine, quarantine and drug treatment numbers. Q2. For each year report the quarantine and drug treatment numbers. Considering the designed fact constellation schema/data mart and its cardinality, decide whether views are convenient to improve response time of the frequent queries (consider the frequent queries stated above 'Q1-Q2'). Please also consider the following information provided by European Centre for Disease Prevention and Control (ECDC) regarding Variable_Dictionary_VaccineTracker, Variable_Dictionary_and_Disclaimer_hosp_icu_all_data Variable_Dictionary_and_Disclaimer_variant-data