Design a data warehouse for a university’s gradebook data to analyze the class performances. Suppose the data warehouse consisting of the following…