• Millennium College wants you to help design a star schema to record grades for courses completed by students. There are four dimension tables, with attributes as follows: Facts to be recorded for each combination of these dimensions are PolicyPremium, Deductible, and NumberOfTransactions. CourseSection Attributes: CourseID, SectionNumber, CourseName, Units, RoomID, and RoomCapacity. During a given semester, the college offers an average of 500 course sections. Professor Attributes: ProfID, ProfName, Title, DepartmentID, and DepartmentName. There are typically 200 professors at Millennium at any given time. Student Attributes: StudentID, StudentName, and Major. Each course section has an average of 40 students, and students typically take five courses per period. Period Attributes: SemesterID, and Year. The database will contain data for 30 periods (a total of 10 years). a. Design a star schema for this problem. . b. Estimate the number of rows in the fact table, using the assumptions stated previously. c. Estimate the total size of the fact table (in bytes), assuming an average of 5 bytes per field.