I am very new to Data warehouse and OLAP, and I dont know how to create OLAP database from a relational schema.
For example, I have a schema like this:
Student (Id, Name, Addr, Status)
Professor (Id, Name, DeptId, Rank)
Course (DeptId, CrsCode, CrsName, Descr)
Transcript (StudId, CrsCode, Semester, Grade)
Teaching (ProfId, CrsCode, Semester)
Department (DeptId, Name, FacultyName)
And I want to create a fact table and its dimensional table from that. I think my fact table will include:
Fact_Table(DeptId, CrsCode, ProfessorId, Semester, enrollment)
with 4 dimensional tables:
Department, Course, Professor and Semester
the attribute enrollment is the number of students in a class. But that is the design, I dont know how to implement it in SQL. is that like:
Create table Fact_table(
or I have to do in another way. please help me! Thank you.