Yioop - PHP Search Engine

May 6 In-Class Exercise.

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

Best, Chris

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

-- May 6 In-Class Exercise

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

(Edited: 2020-05-06)

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

-- May 6 In-Class Exercise

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

 Dimension:
 Students:
 Id, name

 Dimension:
 Courses
 Id, name, time

 Dimension:
 Department:
 id, name

(Edited: 2020-05-06)

Fact Table: Student Info: SchoolID, DepartmentID, CourseID, StudentID Dimension: Students: Id, name Dimension: Courses Id, name, time Dimension: Department: id, name

-- May 6 In-Class Exercise

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

Student (ID, FirstName, LastName, GPA)

Professor (ID, FirstName, LastName, GPA)

Department (ID, Name, GPA)

College(ID, Name, GPA)

(Edited: 2020-05-06)

Fact: University (Student, Professor, Department, College) Student (ID, FirstName, LastName, GPA) Professor (ID, FirstName, LastName, GPA) Department (ID, Name, GPA) College(ID, Name, GPA)

-- May 6 In-Class Exercise

 A star schema could have a fact table: university (department, student, college)

Then a dimension table: student(id, gpa) and department(name, class, professor)

(Edited: 2020-05-11)

<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>

-- May 6 In-Class Exercise

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

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

(Edited: 2020-05-06)

Fact Table: Enrollment(StudentID, CourseID, ProfessorID, Grade) Dimensions: Student(ID, Name, Major) Professor(ID, Name, Department) Course(ID, Name, Department)

-- May 6 In-Class Exercise

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 Table: Enrolled(StudentID, CourseID, ProfessorID, Grade) Dimensions: Students(StudentID, Name, Credits, MajorDeptID, Level) Courses(CourseID, CourseName, CreditValue, DepartmentID, Level) Professors(ProfessorID, Name, DepartmentID, FacultyStatus)

-- May 6 In-Class Exercise

Fact(School, Department, Student, Professor)

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

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

-- May 6 In-Class Exercise

Fact:

   Department(course_name, professor_id, avg_class_grade)

Dimension:

   Faculty(professor_id, fName, LName)
   Student(course_name, grade, fName, LName)

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

-- May 6 In-Class Exercise

Fact table:

Grade(stuid, deptid, gpa)

Dimension tables:

Student(id, fname, lname, major)

Department(id, deptname, courses)

Fact table: Grade(stuid, deptid, gpa) Dimension tables: Student(id, fname, lname, major) Department(id, deptname, courses)