please help with this question If you are a university administrator and want to
ID: 3603836 • Letter: P
Question
please help with this question
If you are a university administrator and want to create a data warehouse to keep track of headcounts for graduated students with various degrees in last 30 years (from 1986-1916, students usually graduate in Fall, Spring or Winter for each year). You wanted to know which college/school they graduate, There are several types of degree offered to students: BS, BA,MS,MA, PhD, EdD, MD.
(a) Create star schema for above narrative. (This schema is also basically an ER model with Foreign Key specified, it is the design of data warehouse.
(b) In above schema, point out the dimensional tables and fact table. Which table(s) you think is/are better normalized/Not normalized, and why
Explanation / Answer
DCQ 0x0200200AD00236DD
DCQ 0x00003401AAC4D097
DCQ 0x000001102ACFF200
DCQ 0x00010AA0AD3C66DF
DCQ 0x0000FC3D76400CCB
DCQ 0x000090045ACDD097
DCQ 0x00000FF000004551
DCQ 0x0200200AD00236DD
DCQ 0x003AC401AAC4D097
DCQ 0x000090045ACDD097
DCQ 0x09990AA0AD3C66DF
DCQ 0x1000200AD00236DD
DCQ 0x00003401AAC4D097
DCQ 0x000001102ACFF200
DCQ 0x00010AA0AD3C66DF
DCQ 0x003AC401AAC4D097
DCQ 0x1000FC3D76400CCB
DCQ 0x000090045ACDD097
DCQ 0x00000FF000004551
DCQ 0x00000000003C66DF
endArr
tsize EQU ((endArr-sourceArray) / 8
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.