Millennium College offers several courses in different subject $($Major$)$ areas. Courses are managed by professors who are employed in different departments. The college records the course details, student details and their results. The college decides to implement a data warehouse. One of the requirements is to record grades for courses completed by students. Initial analysis identified the following dimensions:

CourseSection: CourseID, CourseName, Units, SectionNumber, RoomID, RoomCapacity. $($During a given Semester the college offers an average of $500$ course sections$).$

Professor: ProfID, ProfName, Title, DepartmentID, DepartmentName. $($There are around $200$ professors$)$

Student: StudentID, StudentName, Major. $($Each course section has an average of $40$ students, each student may take up to $5$ course sections per period$).$

Period: SemesterID, Year $($the College follows a trimester system, and it has records for the last $10$ years.$)$

Design a Star Schema for modelling the data warehouse for Millennium College. Ensure every dimension have an appropriate Primary Key. You must identify the FACT table with appropriate details $($facts$)$ and keys for the dimensions. Assign an appropriate name for the FACT table.

Using the principles of normalisation convert the Star Schema to a Snowflake Schema.