Please post your solution to the May 6 In-Class Exercise to this thread.

Best, Chris

Fact: Enrollment (Student, Course, Professor, Grade) Dimensions: Student (ID, Fname, Lname, Major) Course (Number, Name, Department) Professor (ID, Fname, Lname, Department, College)

Fact Table: Student Info: SchoolID, DepartmentID, CourseID, StudentID

Dimension: Students: Id, name

Dimension: Courses Id, name, time

Dimension: Department: id, name

Fact: University (Student, Professor, Department, College)

Student (ID, FirstName, LastName, GPA)

Professor (ID, FirstName, LastName, GPA)

Department (ID, Name, GPA)

College(ID, Name, GPA)

<pre> A star schema could have a fact table: university (department, student, college) </pre> <pre>Then a dimension table: student(id, gpa) and department(name, class, professor) </pre>

Fact Table: Enrollment(StudentID, CourseID, ProfessorID, Grade)

Dimensions: Student(ID, Name, Major) Professor(ID, Name, Department) Course(ID, Name, Department)

Fact Table: Enrolled(StudentID, CourseID, ProfessorID, Grade)

Dimensions:

Students(StudentID, Name, Credits, MajorDeptID, Level)

Courses(CourseID, CourseName, CreditValue, DepartmentID, Level)

Professors(ProfessorID, Name, DepartmentID, FacultyStatus)

Fact(School, Department, Student, Professor)

DimensionsStudents(SID, GPA, Major) DimensionSchool(SchoolName, SchoolID, Location) DimensionDepartment(deptName, deptID, populationSize) DimensionsProfessors(FacultyID, firstName, lastName, department)

Fact: Department(course_name, professor_id, avg_class_grade) Dimension: Faculty(professor_id, fName, LName) Student(course_name, grade, fName, LName)

Fact table:

Grade(stuid, deptid, gpa)

Dimension tables:

Student(id, fname, lname, major)

Department(id, deptname, courses)