ࡱ>	jliu	|bjbjii	4@xjxj))))lT)XDDDkXmXmXmXmXmXmXZj]mXD=DDDmX	"XhThThTDkXhTDkXhThTV0KW$vnFFWWXX0XW,^
JV^KW^KWDDhTDDDDDmXmX`ODDDXDDDD^DDDDDDDDD:	ERD (Entity Relationship Diagram) for the DW "demodw" Database
- Star Schema -









































Where:
A bold column indicates a primary key for that table
A bold & italic column indicates a foreign key to another table 
An italic column indicates an index for that table
- Another Star Schema -













































COURSE (dim)

course_id	int
course_num	char(8)
description	varchar(40)
price		int
department	varchar(40)
curr_prev	char(4)
inactive_date	date

STUDENT (dim)

student_id	int
lname		varchar(20)
fname		varchar(20)
ssn		char(11)
sex		char(1)
program	varchar(20)
school_year	char(1)
email		varchar(99)

INSTRUCTOR (dim)

instructor_id	int
lname		varchar(20)
fname		varchar(20)
ssn		char(11)
sex		char(1)
active_status	char(1)
start_date	date
specialty	varchar(99)

1 

n=n=

GRADE (fact)

grade_id	  int
instructor_id	  int
student_id	  int
course_id	  int
assignment_id   int
date_id		  int
grade		  int
percent		  decimal(2,2)
value		  decimal(6,2)

1 

1 

n=n=

n=n=

n=n=

n 

1=n=

1 

ASSIGNMENT (dim)

assign_id	int
description	varchar(50)
percent		decimal(2,2)


DATES (dim)

date_id	int
full_date	date
day		int
day_dd		char(2)
day_name	varchar(15)
month		int
month_mm	char(2)
month_name	varchar(15)
quarter		int
year		int
semester	varchar(15)


INSTRUCTOR (dim)

instructor_id	 int
lname		varchar(20)
fname		varchar(20)
ssn		char(11)
sex		char(1)
active_status	char(1)
start_date	date
specialty	varchar(99)


COURSE (dim)

course_id	int
course_num	char(8)
description	varchar(40)
price		int
department	varchar(40)
curr_prev	char(4)
inactive_date	date

PAYMENT (fact)

payment_id	  int
date_id		  int
instructor_id	  int
course_id	  int
state_code	  char(2)
gross_pay	  decimal(6,2)
tax		  decimal(2,2)
net_pay	  decimal(6,2)

1 

1 

n=n=

n=n=

n=n=

n=n=

STATE (dim)
state_code	char(2)
state_name	varchar(50)
region		varchar(50)
region_prev	varchar(50)

1 

1 


DATES (dim)

date_id	int
full_date	date
day		int
day_dd		char(2)
day_name	varchar(15)
month		int
month_mm	char(2)
month_name	varchar(15)
quarter		int
year		int
semester	varchar(15)



 !&)-.45?ALNOPQRSTUVWXYZ[\]^_`abc÷ósejh|aUmHnHujh|aCJ UmHnHujhc\UmHnHujhIhMUmHnHuhRjhc\CJUmHnHuh^h8hQ5CJ aJ hQ5CJ aJ hjjhQ5CJ hQxh5\aJmH	sH	hQxhQ5aJhCJ mH	sH	
hQCJ $?OPRSTVYZ\]^_bceghmpstx|}~$a$gdQ>]>^gdQcdefghijklmnopqrstuvwxyz{|}~²tfjhIhMUmHnHujhc\CJ UmHnHujh5/CJUmHnHujhwCJUmHnHujhwUmHnHujhwCJ UmHnHujhwUmHnHujhc\UmHnHujhc\CJUmHnHuh^jh5/UmHnHu(	D	\	]	^	_	`	b	c	gd8$a$gdF!
&Fgd5/					/	4	D	F	Y	[	\	]	^	_	`	ʻʷ}q}qmmh8h8h85CJ aJ h@5CJ aJ hhj5hhj6hjh#h`o5h`oh`oh56h`o6]h9h#hR5hR5\hRh0ZZh5/6>*h0ZZh0ZZ6>*hc\hc\6>*CJaJh5h5/h[h^%`	a	b	c	d	e	f	g	h	i	j	k	l	m	n	o	p	q	r	s	t	u	v	w	x	y	z	{	|	}	~												朜p朜p朜jhrCJUmHnHujhrUmHnHujh|aUmHnHujhMUmHnHujhMCJUmHnHujh5UmHnHujh8H7UmHnHujh_y`CJUmHnHuh8hrh5jht'UmHnHu)c	d	f	h	i	j	k	m	n	p	q	v	x	z																	gd8																																						޾xpxhc	h_y`\h_y`hR\h_y`h_y`\h_y`5\
hRCJhOXZhRmH	sH	hOXZh856hOXZhv
56hOXZhOXZ56mH	sH	hOXZmH	sH	hRhF!jhMUmHnHujht'UmHnHuh8jhF!CJ UmHnHujhUmHnHu%																	


/
0
>
?
N
a
t



$a$gd8							


/
0
7
8
9
:
<
=
>
?
I
M
N
S
a
f
t
w


















±{tphhSK56hOXZhOXZ56hhwhQ1hhR6hR5\
hRCJhOXZhRmH	sH	 hSKhOXZ56\]mH	sH	hOXZh856hOXZhv
56hOXZhOXZ56mH	sH	hOXZmH	sH	hweh|ah.uhRhj,






#0FVlmpqvwgd5/^gd$a$

#/0FVlmnopqvw|}󻴭{󚏚hh!56hh856hhR56]hh856]hLjh.uhR5\h85\
hRCJhOXZhOXZ56mH	sH	hOXZmH	sH	hhk~h5/h*[hUlhwhQ1hOhRhhR6.&'(+,/056;<ABCDEFGKLMNOPZ[\_`abhkozvh.uhR5\h85\
hRCJhSK56hOXZhOXZ56hOXZhOXZ56mH	sH	hOXZmH	sH	hhk~h*[hbhUlh5/hLjhLj	hLj6hhLj56hhw56hLjhh856]hRh_y`.'(+,/056;<ABEFKLOPabp$a$gdUlgd5/^gdop{|

)
6
vrrrrrrnrrnrh5hjhjhj5\]hjhR5\]hj5\]
h5CJhSK56hOXZhOXZ56hOXZhOXZ56mH	sH	hOXZmH	sH	h8mH	sH	hhk~mH	sH	h5h5CJaJhRmHsHh8mHsHh8h.uh8h8]hR+

)
6
@
U
V
W
h
i
|








gdt'gd5$a$gd5$a$6
@
U
V
W
a
b
c
f
g
h
i
v
|












	*BMW{unjjfh|ah_y`h85\
h8CJhMh8mH	sH	hhk~h8h5hht'6ht'ht'5\
h5CJhMh5mH	sH	hM56mH	sH	hOXZhOXZ56hOXZhOXZ56mH	sH	hOXZmH	sH	ht'mH	sH	h5h5CJaJhRh|ahj(

	*BMdv 78;<?@Egdrgd8$a$gd8Wdv '678;<?@EFKLQRW{hhhLjh8hrhhr56h_y`hh856hhF!56hh856]hhw56]h85\hF!5\
h8CJhOXZhOXZ56mH	sH	hOXZmH	sH	hhk~hF!h8h|ah4g0EFKLQRWXdwgdt'$a$gdt'gdgdr$a$gdhk~gd8WX\^_bcdnw%6MZdy»}ysk`yyyyyyyyyyyhjht'5\]ht'5\]
ht'CJht'ht'56hOXZht'56hOXZht'56mH	sH	ht'mH	sH	h5ht'CJaJhh|ahrhr5\hMhhk~mH	sH	hM56mH	sH	hOXZhOXZ56hOXZhOXZ56mH	sH	hOXZmH	sH	hhk~h8%%6MZdyz{|gdt'	yz{|hF!h`oh821h:pc\/ =!"#$%x2 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@66666_HmH	nH	sH	tH	@`@NormalCJ_HaJmH	sH	tH	X@X	Heading 1$$0@&^0a$5CJ\mHsHtHBB	Heading 2$0@&^05\@@	Heading 3$$@&a$5\F@F	Heading 4$@&5\mHsHtHDA DDefault Paragraph FontViVTable Normal :V44
la(k (No ListB/BrHeading 4 Char5CJ\aJB/BQHeading 1 Char5CJ\aJPK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V<a(7IR{pgL=r85v&uQ뉑8CX=$␴?6NJCFB.ʹ'.+YT^e55 ð_g -;Ylݎ|6^N`?[PK!֧6_rels/.relsj0}Q%v/C/}(h"O
= C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xmlM
 @}w7c(EbˮCAǠҟ7՛K
Y,
e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+&
8PK!wG theme/theme/theme1.xmlYKo7X콱$۲eD&~RRHi]傤lV$^
HA/1\H0}R?gF48\5J"Ig0e,pE`O )9уe$g]Ix\)M\RϥdaR(<fRm;WB	i0HHV_8zBTΐ_!WD5'妕VmyZ*qe_I
[gu^YXd>zt7.??Źڨd/L+[梃 _¯UjyA_/֖j-A	%4\/%ި+K|h(Kmgk):b|
H$Y 9DZ.6)A2&`RV!*_[`dI+^DL-)>qfoΟ~_'ҨrQrW_ƿw!pƦ7/_zqԵbp@m
?ItDl,(CjLQc׎O9!N@Iw{Xe3b|`:2˭A9Tn$ءy@Q&Q3,;sg8v%=	CN4I
~>
zHzw0u
$J}*;(wL|$C޳q-!1,hEX>ZN yݾKt l&;HPm%6sq!&}]~@Lw?%q	d98@7C̜mia_Y㩓b8F vB{cNQqsu;6~@VƾzXU+f:OllD,E|=mVePاcGxe_+gj=HSԳ;{yи½|mHmA`0D_cU\+w/
9MOJK:WnǯIUsffn`<"K*2:&w4]3۸cB/br;}̸uF̘G}ҙ3>-=k&ڂE%睸	|Te6pp1GZ&L~AdNPjĢP gFFz٫[ euRTVxC'c*ibQTz:"dC%1!4ZŲR?rՔ)Zf\5GμMO20V4'|:xt&Ԯiv	+nD?TWq]_7.u)S 4?⦾@3;S,8;^K=7>̌cC^$77&%Bn"cy@IK?L'CWc%WSc#^w}ܓ߭ei)$Z`%v]:Blqwae&De*2JǐYG4OPQRlnຠtSi832IQ	QrZ.afٽ\HYʚU6iaT&ly*o]M̹Qh2/woQoPSJŪ[<FU#v+w;XQɨԖ/ڬ{c5oiO**E~o,0\5
ICHtkѼm݀F+1UJAo
x%j.l)l*s)]RBw)'>lDY&`Riڊ0z۶ܫ/PK!
ѐ'theme/theme/_rels/themeManager.xml.relsM
0wooӺ&݈Э5
6?$Q
,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧60_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!wG theme/theme/theme1.xmlPK-!
ѐ'Q
theme/theme/_rels/themeManager.xml.relsPK]L<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<a:clrMap xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main" bg1="lt1" tx1="dk1" bg2="lt2" tx2="dk2" accent1="accent1" accent2="accent2" accent3="accent3" accent4="accent4" accent5="accent5" accent6="accent6" hlink="hlink" folHlink="folHlink"/>*Z"|?C9zG|{KO*Z"	

|8@c`			
o6
WWy|	
c		

E|
8V@!V6 (	
b

3#"`?0
b

3#"`?)
b

3#"`?
b

3#"`?

b

3#"`?
b

3	#"`?

	b

3#"`?
b
z
3z#"`?
b

3
#"`?

b
|
3|#"`?
b
{
3{#"`?
~b	d\

=#"?T
9
#9d\

TB
;
CDdTB
<
CD~b	d\

>#"?T
?
#?d\

TB
@
CDdTB
A
CD~b	d\

B#"?T
C
#Cd\

TB
D
CDdTB
E
CD~b	d\

J#"?T
K
#Kd\

TB
L
CDdTB
M
CD~b	d\

N#"?T
O
#Od\

TB
P
CDdTB
Q
CDVB
W
CD"?VB
\
CD"?VB

CD"?D
"?VB

CD"?D
"?D
"?b

3
#"`?

VB

CD"?D
"?	VB

CD"?VB

CD"?b

3#"`?"
b

3#"`?$
b

3#"`?,
b

3#"`?*
b

3#"`?1
~b	d\

#"?T

#d\

TB

CDdTB

CD~b	d\

#"? T

#d\

TB

CDdTB

CDVB

CD"?+VB

CD"?&D
@"?-VB

CD"?D
"?!VB

CD"?VB

CD"?.VB

CD"?'D
"?(b

3#"`?%
~b	d\

#"?/T

#d\

TB

CDdTB

CDVB

CD"?3~b	d\

#"?T

#d\

TB

CDdTB

CDD
"?D
"?#~b	d\

#"?2T

#d\

TB

CDdTB

CD~b	d\

F#"?T
G
#Gd\

TB
H
CDdTB
I
CDB
S	? 	PTVWZ_`cehijkmnpqtuvxyz~`dfknqrstvxz{|}|>_

tAAtBm/t=%t5%`'tzvlttv`tF
Lt5&t;bt;b;tbI t`to	m
tt\9
t~	
t9
t99t|`tWtt, Zt{9ZtJ]U	tN2%t&%Q'tE$
t?s
t$0&0t2?t
Ut(t(t99tHYt5~ttt_t`	j
toGtH
to	j
t*(t*
t]X
t:t\ t}$2t$73'7t.4
)?INSaftw0=FPbk	iv|	!dmv 'dnw
%-6@z}>0=U]hpy~	(->C`hw!P`|
%IQ"'6>X`ns'1Xcot.3AImuz}333333333333333333333333333333333333333333333333333333333333QRRSSTUVXYYZ[\\]]_abbcdefgghlmoprsstwx{||}}~.//007=MMtyy/kllmpqvw&''(+,/056;<ABEFKLOP`bhoop{|TUUVghxyz}NOOPQRRSSTUVXYYZ[]]_abbcdefgghlmoprsstwx{||}}~.//007=/kllmmppqqvvw&((++,,//66;;FFKKLLOOP`bhp{|TUUVghxyz}X@iߪnhh^h`OJQJo(hHh8^8`OJQJ^Jo(hHoh^`OJQJo(hHh	^	`OJQJo(hHh^`OJQJ^Jo(hHohx^x`OJQJo(hHhH^H`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHX@i									=<hOv
w@Z#Q18H79SKMIhMOXZ0ZZxZ*[c\_y`|a|abwe4gtRiUlhk~jrt'`o^QxRQ8w5.uj8F!wB#Uzk5/Lj!}d 8[@|@UnknownG.[x	Times New Roman5Symbol3..[x	ArialC. Aptos Display3. Aptos?=	.Cx	Courier New;WingdingsA$BCambria Math"qhF,ǐʥ9>c>cq203Q@P?`o2!xxWgK+Your database includes the following tables
Sam Sultan
Sam Sultan
Oh+'0 	4@
`lx
,Your database includes the following tablesSam SultanNormal.dotmSam Sultan57Microsoft Office Word@&@PW@J, @>n>c
՜.+,0 hp
Home Box Office,Your database includes the following tablesTitle	

 "#$%&'(*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXZ[\]^_`bcdefghkRoot Entry	F$vnmData
!1Table)"^WordDocument4@SummaryInformation(YDocumentSummaryInformation8aCompObjr
	F Microsoft Word 97-2003 Document
MSWordDocWord.Document.89q