ࡱ>	fheu	bjbjii	46xjxjYYYmmmmTLm#[




FDFDFDZZZZZZZ]_ZYFD=FDFDFDZ

"ZSSSFD
Y
ZSFDZSS:Y,GY
P:[n$FJY
ZZ0#[TYRm`Hm`Ym`YYFDFDSFDFDFDFDFDZZNVFDFDFD#[FDFDFDFDm`FDFDFDFDFDFDFDFDFDK:	ERD (Entity Relationship Diagram) for the "demo" Database










































		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  (* unique index)
Other independent tables in the database






						Will be used when we learn GROUP BY







						Will be used when we learn 1:N self relationship







						Will be used when we learn N:M self relationship
						(advanced topic)

















In addition, we have the following views  

V_STUDENT_INFO  
  
V_KEY_COLUMN  
COURSE

course_id	char(8)
description	varchar(40)
price		int

1 

STUDENT

student_id	int
lname		varchar(20)
fname		varchar(20)
ssn *		char(11)
sex		char(1)

INSTRUCTOR

instructor_id	 int
lname		varchar(20)
fname		varchar(20)
ssn *		char(11)
sex		char(1)

CLASS

class_id	int
course_id	char(8)
session_id	int
inst_ssn	char(11)
stu_ssn	char(11)

1 

1 

n=n=

1 

1=n=

n 

n=n=

STUDENT_EMAIL

email_id	int
student_id	int
email		varchar(99)

ADDRESS

address_id	int
stu_id		int
inst_id		int
addr_type	char(1)
street1		varchar(50)
street2		varchar(50)
city		varchar(25)
state		char(2)
country 	varchar(20)

1 

INSTRUCTOR_INFO

instructor_id	int
active_status	char(1)
start_date	date
specialty	varchar(99)

1 

n=n=

n=n=

n=n=

EMAIL_MSG

msg_id	int
email_id	int
received_date	date
from		varchar(99)
message	varchar(500)

n 

PAYMENT

payment_num   int
vendor		   varchar(40)
amount		   decimal(6,2)
description	   varchar(40)
pay_date	   date

HIERARCHY

employee_id	   int
lname		   varchar(20)
fname	   	   varchar(20)
manager_id	   int	

RELATIONSHIP

row_pk	   int
from_id	   int
to_id	   	   int

ADDRBOOK

lname		   varchar(20)
fname		   varchar(20)
street		   varchar(50)
city		   varchar(20)
state		   char(2)
zip		   char(5)
phone		   varchar(20)



 !&)*+,/09:;<=>?@ABCDEFGHIJKLMNOxhjh*[CJUmHnHujh.^CJ UmHnHujh.^CJUmHnHuhRjh^CJUmHnHuh^
hRCJ 
hGCJ 
h/5CJ 
hCJ h(h5\aJh(hj5\aJh(hjaJh(hj5aJ
hCJ 
hjCJ %:;<BDFGJKLMNOQVW\aegjkmos]^gdj]^gd0U0`^`gdTbOPQRSTUVWXYZ[\]^_`abcdefghijklmnoξ좢씰vhZjh0aUmHnHujh&UmHnHujh|DUmHnHujhUlCJ UmHnHujhTbUmHnHujhuUmHnHujhUlUmHnHujhnSCJUmHnHujhjCJUmHnHujh9UmHnHuh^jhTbCJUmHnHu opqrstuvwxyz{|}~ҴҔvvhhZjh]sUmHnHujhUmHnHujh*[UmHnHujhjCJUmHnHujhGFNCJUmHnHujh.^CJUmHnHujh0U0UmHnHujhTbCJUmHnHuh^jh&UmHnHujhjUmHnHujh.^UmHnHu#su{}	\			
&F]^gd.^`]^`gdTb]^gdj					 	5	:	I	L	M	N	U	Z	[	\	}yryjcyhnJh`h`h`5h`h`h`h2Ah2A5hP	h2A6h2Ah2Ah`o5h`oh`ohP	56h`o6]hSh2AhR5hR5\hRhN
Fh2A6>*hN
FhN
F6>*	h2(
6h2(
h2(
6h9h&h9hx?h[hmh^#\	b	o	t																																

3
4
:
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
[
\
澾ƾ¾¶jh.^UmHnHuhth=hK1-6h=h=6hK1-h=jhK1-UmHnHuhW_jhI UmHnHuhI h~5CJ aJ hI hI 5CJ aJ :																						4
K
L
M
N
O
]gd=]gd=O
P
R
S
T
U
V
W
X
Y
Z
[
\
]














$a$gdw<
&Fgdw<\
]


























-02=IJKVWdijoǿ{whQ1	h`6h`hR6hP	hR6h*[hUlh.uh"&hR5\
hRCJhRhw<hthw<h~hw<h~5hw<hw<CJaJhw<hw<h&Nh&Nhw<hw<5hw<h~hw<CJaJh
CJaJ.

-=JKVWj}
gdUl$a$o}	

 !"#()78hbh*[hUlhhP	h56]hP	hxZ56]h!hP	hR56]h.uhR5\
hRCJhQ1hO	h`6h`hR6hP	hRhP	hR6hR9"#()78ETghpq

gd[$a$gdUl8@DEOSTghpq{	






 
!
.
2
3
I
Y
o
p
q
r
s
t
y
z







ʾج񨤨񠘍hx?hmmH	sH	hx?mH	sH	hmh*[hUlhR56\]h]sh^h[hkhk6hkhP	hk56
hRCJhRmHsHhP	hR56]hRh.uhR5\5


 
!
3
I
Y
o
p
s
t
y
z













gdm$a$gdmgdUl$a$gd]s
























2M^_hijvx}Ͷͮ薖}yslgyyy	hK1-\hK1-5\
hK1-CJhK1-hRhI 5\
hI CJhI h~h]sh2(
CJaJmHsHh2(
mHsHhy~mHsHh2(
hx?CJaJmHsHhmmHsHhx?mHsHhP	hm56]hx?56]hmhm5\hx?5\
hmCJ&



2M^_ij}gdt$a$gdtgdK1-$a$gdK1-gdI $a$gdI 3J_qUhw<hth`oht5\htht\
htCJht	hK1-\hK1-5\
hK1-CJh~hRhK1-hK1-hK1-63J_q
&Fgdw<gdt
21h:p9/ =!"#$%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	L@L	Heading 1$$0@&^0a$
5CJ\BB	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I Heading 4 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"/>>BZ^bhlrv|_c7;P?zC9G}{|KSO~>BZ^bhlrv|_c7;P	

86Oo\	\
o8


s	O



	8W@\"W (	
b

3#"`?3
b

3#"`?$
b

3#"`?
b

3#"`?-
b

3#"`?/
b

3#"`?.
b

3#"`?

b
~
3~#"`?*
b
}
3}#"`?
b
z
3z#"`?
b

3
#"`?

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

=C"?
T
9
#9d\

TB
;
CDdTB
<
CD~b	d\

>#"?T
?
#?d\

TB
@
CDdTB
A
CDn	d\

BC"?	T
C
#Cd\

TB
D
CDdTB
E
CD~b	d\

N#"?&T
O
#Od\

TB
P
CDdTB
Q
CDV
S
#S"?!
VB
V
CD"?VB
W
CD"?VB
\
CD"?VB
]
CD"?VB
^
CD"?VB
a
CD"?VB
c
CD"?VB
d@
CD"?+VB
e@
CD"?VB
k@
CD"?VB
r
CD"?VB
u
CD"?VB
v
CD"?,VB
w
CD"? b

3#"`?
VB
X
CD"?~b	d\

#"?4T

#d\

TB

CDdTB

CD~b	d\

#"?5T

#d\

TB

CDdTB

CD~b	d\

#"?6T

#d\

TB

CDdTB

CD~b	d\

#"?7T

#d\

TB

CDdTB

CDD
"?D
"?V
K
#
K"?

VB
M@
CD"?'b	(0
#"?1h

##"T?(0
hB

CD#"X?W*W*hB
B
CD#"\?Q	f*`	0VB
@
CD"?2VB
@
CD"?VB

CD"?D
"?D
"?D
@"?0D
"?%D
"?D
"?(D
"?)D
"?#D
"?"n	d\

FC"?T
G
#Gd\

TB
H
CDdTB
I
CDB
S	?`	
<=>?@BDGHOQRSTWXYZ\]^_abceghkmopqsuvwxy{}~Pa|t^|t]t\	L@LteD%&t>"qQtz~	
t	("(tX	(	tB|C	t=S%tF@t}S%H&t2ft
t
tc&&
t	L@t|ttD%&t&&t{C	Mt\t|\t	1@tW%%tVaPm9tuA
Ytk3}&Etr3BKtK|OCHtw#
1#
tS@tt@t%	tm4tNP$tM+:"tC$	t3	3	t	t~$R&Ntd$&tvA
@t	@!t|mt}Q0t3t^[b	t3	tb3	t
t.
ct
t2

t-0Wdjo}8@EOq{!.3@ISMUju}"DL!)49BGKUqy)6TY[cAFck%-AI_h'/>FS[iny~333333333333333333333333333333333333333333::<<??@@AABCDEFFGHIILLWWttuxzz{|}\\NNPQ\]-0244IIJJKKii}
"#())DDSSTfgghhp	
!223noopstyz
 "]^^_hj|}#$'/03:;::<<??@@AABCDEFFGHIILLWWttuxzz{|}\\NNPQ\]02JJKK

""##(())gghhoottyyzz
 "]^^_hj|}#$'/03:;}:dJD6IT*hh^h`OJQJo(hHh8^8`OJQJ^Jo(hHoh^`OJQJo(hHh	^	`OJQJo(hHh^`OJQJ^Jo(hHohx^x`OJQJo(hHhH^H`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh@^@`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh ^ `OJQJo(hHh^`OJQJ^Jo(hHoh!^!`OJQJo(hH6IT}:																		=<GOP	2(
/I "&K1-0U0Q19w<x?2AN
FGFNPPNxZ*[/+^.^W_0abTbUl]snY}`o^RG&N9y~.u&=w~tu`(m|DkSj
jnJ!nS!:^[@@UnknownG.[x	Times New Roman5Symbol3..[x	ArialC. Aptos Display3. Aptos?=	.Cx	Courier New;WingdingsA$BCambria Math"qhD,ǐʥ5LfGfGq203Q@P?`o2!xxA@++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 Sultan53Microsoft Office Word@>a.@PW@J, @`@nfG
՜.+,0 hp
Home Box Office,Your database includes the following tablesTitle	

 !"#%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTVWXYZ[\^_`abcdgRoot Entry	FP:[niData
1Table$`WordDocument46SummaryInformation(UDocumentSummaryInformation8]CompObjr
	F Microsoft Word 97-2003 Document
MSWordDocWord.Document.89q