ࡱ>	DFC;	Bbjbj	. hh%nn,$}.="="="-------$m0#3".=">="="="".nn7.E*E*E*="fn-E*="-E*E*,BT(-4#,-M.0}.,,3W%3(-3(-="="E*="="="="="".".'n="="="}.="="="="3="="="="="="="="="X4:	ERD (Entity Relationship Diagram) for the ODS "demods" 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

ROSTER

roster_pk	int
stu_id		int
stu_lname	varchar(20)
stu_fname	varchar(20)
stu_ssn		char(11)
stu_sex	char(1)
course_id	char(8)
session_id	int
description	varchar(40)
price		int
inst_id		int
inst_lname	varchar(20)
inst_fname	varchar(20)
inst_ssn	char(11)
inst_sex	char(1)

n=n=

STUDENT_INFO

row_pk	int
stu_id		int
lname		varchar(20)
fname		varchar(20)
ssn		char(11)
sex		char(1)
email 		varchar(99)
addr_type	char(1)
street1		varchar(50)
street2		varchar(50)
city		varchar(25)
state		char(2)
country 	varchar(20)

INSTRUCTOR_INFO

row_pk	int
inst_id		int
lname		varchar(20)
fname		varchar(20)
ssn		char(11)
sex		char(1)
active_status 	char(1)
start_date	datetime
addr_type	char(1)
street1		varchar(50)
street2		varchar(50)
city		varchar(25)
state		char(2)
country 	varchar(20)

1=n=

1 

n




 !"&)*-./567?@ABCDEFGHIJKLMNOPQRStffjh=UmHnHujhUmHnHujhUmHnHujhCJUmHnHujhCJUmHnHujhCJUmHnHuh^
hRCJ 
hjjCJ hjjhjj5CJ 
h=CJ h3h35aJh3hj5aJ
h3CJ 
hjCJ (@ABCDEGHKOQSXZ_`abdfghijklmgd{W>]>^gdjjSTUVWXYZ[\]^_`abcdefghijklmnopqrstz{|ิ~tph`oh`ohP	56h`o6]hU"=h2AhR5hR5\hRhN
Fh2A6>*hN
FhN
F6>*h{Whh[
h{WCJjhUmHnHujhCJUmHnHuh^jhUmHnHujhUmHnHu,mnopqrst{$	%	,	-	;	G	]	s									
gdgd
&Fgd2A			$	%	+	,	-	3	4	6	:	;	A	C	F	G	]	s																					
ƿתצעzhkhk6hhhh\]h\]hhhhkhP	hk56h.uhwf5\hR5\h5\
hRCJh=hRh2Ah2A5hP	h2A6hU"=h2Ah`oh2Ah`o50

&
7
8
=
>
K
L
P
R
W
]
c
v














*+:;<@BGKNTgz123489:;ββh*[hbhhP	h=56h=56h=5\h=hP	h{W56hwf5\h{W5\
h{WCJh{WhUlhRhC
&
7
8
=
>
K
L
W
c
v







*+;<GTggd=gd{Wgd{WgdUlgdgz2389<=?@ABgdUlgd=;<=?@ABhRhUl,1h/ =!"#$%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\L@L	Heading 3$$@&a$5\mHsHtHFF	Heading 4$@&5\mHsHtHDA DDefault Paragraph FontViVTable Normal :V44
la(k (No ListB/BI Heading 4 Char5CJ\aJB/B{WHeading 3 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!:theme/theme/theme1.xmlYKo7X콱d7"GJK.$eG"9R@ZP

z1MD\i
[~siLaI/*N, I=!Q Xw?ڒB
?2Z[CXFKqKޘJшW*D
0TcKBcqY!T(NmON=~IkwL\Wfx]AiRvr@2S:\Nqu[e_F78TkPv[`EA67m[e^iW~
(IKRњ6u7n}}@A4ѥD3R$IiGhQB8HA(aKniOEE[Ҋ0KK'9g=~Z%Д{7߽6z/L_zǟS'.Lqݫ__?phh`$;C_M!bJ$@	R8wdd"m;>j\{cp/IDg6wZ0s=Dĵw%;r,qlEآyDQ"Q,=c8B,!gxMD&铁M./SAe^QשF½|SˌDإbj|E7C<bʼNpr8fnߧFrI.{1fVԅ$21(t}kJV1/ ÚQL×07#]fVIhcMZ6/Hߏ bW`GvTs'BCt!LQ#JxݴyJ]
C:= ċ(tRQ;^e1/-/A_Y)^6(p[_&N}njzb\->;nVb*.7p]M|MMM#ud9c47=iV7̪~㦓ødfÕ5j
z'^9J{rJЃ3Ax|
FU9…i3Q/B)LʾRPx)04N
O'>agYeHj*kblC=hPW!alfpX OAXl:XVZbr
Zy4Sw3?WӊhPxzSq]y<u,.in6	mgѩV/C㪾,\jSAh4⺾@3S;m*
Cc;B=s!›
̒r!HDuɲAL$%qW@C4:$&8v2Pn7VKYpůVlE7AUeexwPάx'"
,ote눦U3gps:*q5;30ɬBU`MZ4Ub!e9#i5*jü,zE`5714g{1nsBW	0xn?GսDA0Y4rlծ^@2E5¹,^bhWjKm68ц.wBЮ.GtO
-/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-!:theme/theme/theme1.xmlPK-!
ѐ'	theme/theme/_rels/themeManager.xml.relsPK]
<?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"/>BS{B$ S
;B	m
gB

8@Z(	
b

3#"`?
b

3#"`?
b

3#"`?
b
{
3{#"`?
V
S
#S"?
VB
T
CD"?VB
U@
CD"?VB
V
CD"?VB
\
CD"?VB
q
CD"?V

#"?
V

#"?
VB

CD"?VB

CD"?
VB
@
CD"?VB

CD"?	VB
@
CD"?VB

CD"?VB
@
CD"?
B
S	?EHIKLMOQSTUVXZ[\]bdBS1q
tTOtU
+tV3	@t3	B	t~	
t|HtS%t7btttD%tttt\t{3	/t3	ttqt/5%-6;AGP]fsz&.LRW]chv{<BGNTYglz}@C%+QYgo|"/4>Jjr}
&+:[cnv
&.@C33333333333333333333333333333333 ""&).7??@@AABBDDEEFFHHJJKMNNOOPPSTXXZ^__bbccdeor%+,-346::;AC78=>JKLOPRVVW]_()**+:;<1289<=?@C ""&).7??@@AABBDDEEFFHHJJKMNNOOPPSTXXZ^__bbccdeor%+-346G788==>JLOPRc**+:<12399<<>>C6IT*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(hH6IT									*)v}OP	I "&K1-Q1U"=A2AN
F{WxZ*[W_bwfIiUl~pjj`o/^R.u==~tkr3j![%'@EEEEB@@UnknownG.[x	Times New Roman5Symbol3..[x	ArialC.,.{$	Calibri Light7..{$	Calibri?=	.Cx	Courier New;WingdingsA$BCambria Math"qhbD\ܫʥ
 ++!20$$3Q@P?`o2!xxFv#+Your database includes the following tables
Sam SultanSam
Oh+'0 	,8
Xdp
|,Your database includes the following tablesSam SultanNormal.dotmSam10Microsoft Office Word@hx@PW@T#4^@X+
՜.+,0 hp
Home Box Office$,Your database includes the following tablesTitle	

 !"#$%&'()*+,-./012456789:<=>?@ABERoot Entry	F@GData
1Table3WordDocument. SummaryInformation(3DocumentSummaryInformation8;CompObjr
	F Microsoft Word 97-2003 Document
MSWordDocWord.Document.89q