Draw a data warehouse diagram (star or snowflake schema) to represent the following information. Arrows are sufficient for denoting foreign keys. Note any assumptions you've made. YOU MUST IDENTIFY WHETHER THIS IS A STAR OR SNOWFLAKE SCHEMA, AND IDENTIFY THE FACT AND DIMENSION TABLES. needs a new data warehouse that tracks student enrollment over time. An enrollment involves a student who registers to take a section of a course. Each enrollment includes a registration date, a mid-term grade, a final grade, and grade points earned. Each section is for a given course, has an instructor, and is offered during a semester. Sections are identified by the CRN, but the university uses the combination of the course id (e.g., CSCI 3020) and section (090) number to refer to the section for each term (Summer 2017). Course sections also store the number of credit hours. For accreditation, you should track instructor names, their highest degree earned (e.g., Ph.D., M.S.), and their start date. Semesters have begin dates and end dates. A course is identified by its Course ID (e.g., CSCI 3020), and includes a title (Database Advanced Topics), and a catalog description. You should track student names, addresses, and the date they were admitted. Draw a data warehouse diagram (star or snowflake schema) to represent the following information. Arrows are sufficient for denoting foreign keys. Note any assumptions you've made. YOU MUST IDENTIFY WHETHER THIS IS A STAR OR SNOWFLAKE SCHEMA, AND IDENTIFY THE FACT AND DIMENSION TABLES. needs a new data warehouse that tracks student enrollment over time. An enrollment involves a student who registers to take a section of a course. Each enrollment includes a registration date, a mid-term grade, a final grade, and grade points earned. Each section is for a given course, has an instructor, and is offered during a semester. Sections are identified by the CRN, but the university uses the combination of the course id (e.g., CSCI 3020) and section (090) number to refer to the section for each term (Summer 2017). Course sections also store the number of credit hours. For accreditation, you should track instructor names, their highest degree earned (e.g., Ph.D., M.S.), and their start date. Semesters have begin dates and end dates. A course is identified by its Course ID (e.g., CSCI 3020), and includes a title (Database Advanced Topics), and a catalog description. You should track student names, addresses, and the date they were admitted