Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
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
- 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started