Modeling Student Academic Programs

dianaantova at 23h51
10
Sep
2009
Modeling Student Academic Programs

I am designing a student star schema and I have a student dimension, quarter dimension and registration fact table. I need to add to this data warehouse the student's academic programs (majors).
The attributes for the academic program are: student id, start quarter, termination quarter, college, department, major, objective, emphasis, completion quarter, completion status, termination reason code, termination reason, honors, level, dissertati
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
What am doing some initial planning of the steps I need to take to create a DW for a medical school. Tables would include students, courses, exams, questions, exam_questions, grades, stats and such. If a fact table is where I would store performance
I am in the process of creating a student data warehouse for a university. I want to track the student quarterly registration. I am wondering what the best way to create the fact table is. The main dimensions should be time (quarter) and student but there
The following is a look at some of the most comprehensive and reliable educational Web sites a student can bookmark and use to research school projects and homework assignments. MSN Encarta The free MSN Encarta site features more than 4,500 articles
SUICIDE PREVENTION HOTLINE Are you in crisis? Please call 1-800-273-TALK (8255) Easy Guide to Resources for all 50 States http://www.unemploymentlifeline.com/ The United Way Hotline: 2-1-1 provides free and confidential information an
Hello, I migrated a relational database to dimensional modeling database. I need to test that all the information in the source system is there in the target system. One technique which can be used is... - to calculate the number of records in the
Forums from same category
See also
more_less
Informations

1 Replies For the topic :
"Modeling Student Academic Programs"

This topic has been viewed 1066 times.

Last message :
10/09/2009 at 23h51 by "dianaantova"