Do not upload the same answer from another chegg answer.

Teaching Department Course NoHours NoCredits DepartmentID DepartmentName Address DeanName NoStudents CourselD CourseName Credits Theory Credits Exercises Description Homepage Year Year Affiliation Month Professor Academic Semester SemesterNumber Month ofessorID Professor Name Status Hiring Date Calendar Time Academic Calendar Academic Year AcadYearNumber Funding Agency Day DayOfWeek StartDate EndDate Research AgencyName Contact Person Address City State Country Project ProjectlD ProjectAcronym ProjectName ProjectType TotalPerson Months TotalAmount Person Months Amount Fig. 1: MultiDim Schema for University DW 3. For the (conceptual model of the) cube shown in Fig. 1, write the MDX statements for the following queries: Q1: For each department, the Amount of research funds and Person Months, only for a faculty hired before 2015. Q2: For each department and each funding agency, the total number of Person Months in the projects that started after 2015. Teaching Department Course NoHours NoCredits DepartmentID DepartmentName Address DeanName NoStudents CourselD CourseName Credits Theory Credits Exercises Description Homepage Year Year Affiliation Month Professor Academic Semester SemesterNumber Month ofessorID Professor Name Status Hiring Date Calendar Time Academic Calendar Academic Year AcadYearNumber Funding Agency Day DayOfWeek StartDate EndDate Research AgencyName Contact Person Address City State Country Project ProjectlD ProjectAcronym ProjectName ProjectType TotalPerson Months TotalAmount Person Months Amount Fig. 1: MultiDim Schema for University DW 3. For the (conceptual model of the) cube shown in Fig. 1, write the MDX statements for the following queries: Q1: For each department, the Amount of research funds and Person Months, only for a faculty hired before 2015. Q2: For each department and each funding agency, the total number of Person Months in the projects that started after 2015