9/18 Class

Question 1

dimensional model

Answer 1

only has fact and dimension tables

Question 2

logical design tools

Answer 2

look at ppt

Question 3

exam

Answer 3

all of the material is on the slides
know the steps in the data lifecycle and a sentence or example of each
there are no multiple choice or T/F it is all memory
know the slides
know the dimension modeling and the difference between fact tables and dimension tables
Steps for design a dimension model
use index to find the:
calculation, etc
problems will be very similar to handouts. do them again there are four of them
exam is closed book, notes, computer
short essay questions and problem solving questions
test is two hours
understand degenerative dimensions - which means that the only purpose of their existence is to identify the table or record