Answer Happy

Question No 3: CLO-2 5- Marks Suppose that a data warehouse for a University consists of the following four dimensions: student, course, semester, and instructor, and two measures count and avg_grade. a) Identify the appropriate fact table components. b) Identify the appropriate dimension tables and attributes for the dimension tables. c) Draw a star schema diagram for this data warehouse. Solution: course dimension table course_id course name department semester dimension table semester_id semester year univ fact table student_id course id semester id instructor id count avg_grade student dimension table student_id student name area id major status university instructor dimension table instructor_id dept rank