All students are entered in the OneUni system. Each student is enrolled in only ONE degree course.

$$ Each student can be enrolled in multiple courses.

$$ Every time a student completes a course, a grade is entered for that student.

$$ The information from MyUni's system needs to be connected with the Finance database for further analysis.

Tasks:

$$ Design a factless fact table and associated dimension tables to store the academic information for OneUni students.

$$ Create the relevant columns and data types for each table.

$$ Describe what data each column will store $($at least $1-2$ lines per column$).$

$$ Design the relationships between the factless fact table and dimension tables