Standard Jet DBnb` Ugr@?~1y0̝cßFNi7+֜(e$`"{6߱fC=3By['|*J|[ pf_Љ$g'DeFx -bT4.0dvcO<)   x e R > +  {  g T A -}jVC0 lYüED1@+efq@+efqDW$AFo}U6ĭZseRC.c1]Bl7nPLs( **>wU]p @+efq@+efqDW$AFo}U6ĭZseRC.c1]Bl7nPLs( **>wU]p @+efqDW$AFo}U6ĭZseRC.c1]Bl7nPLs( **>wU]p ( T+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ) T+efqDW$AFo}U6ĭZseRC.c1]Bl7nPLs( **>wU]p T+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ) 7( 7+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 7) 6( 6+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 6) 5( 5+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 5) 4( 4+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 4) ( +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ) 3( 3+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 3) ( +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ) 2 ( 2 +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 2 ) 1 ( 1 +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 1 ) 0 ( 0 +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p 0 ) / ( / +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p / ) . ( . +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p . ) - ( - +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p - ) , ( , +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p , ) + ( + +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p + ) * ( * +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p * ) ) ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ) ) ( ( ( +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) ' ( ' +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ' ) LA YqS tt Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName         nrollments].[studentID]8 g6 [students].[Balance Due]7 g6 [students].[Hometown]4 g6[students].[GPA]/ g6![students].[Num Credits Earned]> g6[students].[Major]1 g6[students].[Year]0 g6[students].[Last]0 g6[students].[Middle]2 g6[students].[First]1 g6[students].[Student ID]6 g672U0t"@2U0t"@junk Query44444444444 6ɚ/t"@0t"@join students enrolled sections/classesnnnnnnnnnnn 5ɚ/t"@ɚ/t"@enrollments Query1DDDDDDDDDDD 4ɚ/t"@ɚ/t"@enrollments QueryBBBBBBBBBBB \/t"@ʚ/t"@enrollments66666666666 3/t"@\/t"@CountOfEnrollByCourse QueryVVVVVVVVVVV d.t"@/t"@Catalog Courses>>>>>>>>>>> 2%.t"@d.t"@~sq_fstudentsWenrollHHHHHHHHHHH 1%.t"@%.t"@~sq_fstudents1<<<<<<<<<<< 0%.t"@%.t"@~sq_fstudents::::::::::: /%.t"@%.t"@~sq_fRooms44444444444 .-t"@%.t"@~sq_fEnter New Course:LLLLLLLLLLL --t"@-t"@~sq_fenrollments Subform2RRRRRRRRRRR ,-t"@-t"@~sq_fenrollments Subform1RRRRRRRRRRR +-t"@-t"@~sq_fenrollments SubformPPPPPPPPPPP *-t"@-t"@~sq_fCatalog CoursesHHHHHHHHHHH )-t"@-t"@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV (-t"@-t"@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT 'k-t"@k-t"@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx &k-t"@k-t"@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV %k-t"@k-t"@~sq_cstudents~sq_cFindStudTTOY\SsY Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectId @ @ @ @ @         ! ! ! ! " """""""######$$$$%%!%"%#%$%%% &&&(&)&''*','-'.'/'+(0(2(3(4(5(6(7(8(9(1):)<)=)>)?)@)A);*B*D*E*C+F+H+I+G,J,L,M,K-N-P-Q-O.R.T.U.S/V/X/Y/W0000111122 2 2 3 3333333333333 3 3 4444 4!4"45#5%5&5'5(5)5$6*6,6-6.6/6061626364656667686 96 :6 ;6 <6 =6>6?6@6A6B6C6D6E6F6G6H6I6 6 6 6 6 6 6 6 6+7 7 7 7 7 7 7 7 7  7  7  7  7  7  7  7  7 6@6A6B6C6D6E6F6G6H6 YVSY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttributeFl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$Fl$F P$FMSysAccountsk;F0FnF0F Y;F~FJ@K@MSysAccessObjects DDDDDDDDDDB 2qCatalog CoursesstudentsKbPrerequisitesPrerequisitesO\ProfessorsProfessors(URoomsRoomso&Catalog Courses_1Catalog Courses j ;F0F  -Y S Y Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationship&'()*+,-./YIdParentIdName        Yv1b N  : k & W  C t/onIDDetachedLabelsectionID_Labeld5U7`a<b c0special permission Label$special permissionDetachedLabel0special_permission_Label`w Detailm7U`<a<bcestudentIDstudentIDm7U`ua<bcegksectionIDsectionIDm7]`a<b ce k$special permission$special permission$special_|SELECT DISTINCTROW Sections.sectionID, Sections.Dept, Sections.[Course#], Sections.Section, SecID="{FEAC9797-44BC-471E-B0CD-5A22585D108B}" DocClass=Form_main/&H00000000 DocClass=Form_studentTasks/&H00000000 DocClass=Form_FacultyTasks/&H00000000 DocClass=Form_DeansTasks/&H00000000 DocClass=Form_studentsWenroll/&H00000000 Name="university" HelpContextID="0" VersionCompatible32="393222000" CMG="7A78870F051asksForm_DeansTasksForm_DeansTasksForm_studentsWenrollForm_studentsWenrolltions.Sem, Sections.Year FROM Se0=Babe ghXiJjq%kNr@Ariald2hgh MS Sans Serif`@ Detaild5U`ab cdLabel0Administrativeh1U`abVc NewCourse New CourseCourses.newCourseh1U`l abciBackMain Back To Main BackToMain00-0000-C000-0000000Prof_LabelPickProfdרNJy2`FormFooteroM2Y3nt_Labelroctions WHERE (((Sections.Sem)="F") AND ((Sections.Year)=2002));.960;570;825;765;480;525d5`0 a<bc   $ HB  HB  44$ P`@@@@@       @ @   @ @@  @@ JO`YbmJk\kMJmJ^dUMdoikQkOQJbkmJk\kQbid^^`QbmkkoLSdi`Qbid^^`QbmkkoLSdi`8Qbid^^`QbmkkoLSdi`:QbmQibQsMdoikQ SJMo^mvmJk\k`JYbidd`kkQMmYdbkkmoOQbmkkmoOQbmk8kmoOQbmksQbid^^kmoOQbmmJk\kJ^^Qbid^^`Qbmk MdobmdSQbid^^LvOQfmJbOMdoikQ![ob\idkmQi [ob\kMWQO iQ^JmYdbkWYfkSdiobYq:666bQs`iQfdim^QJOYbUmdobbdi`J^YxQOidd`kOQkYUbiQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb:"iQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb<#idkmQiu$kMWQOo^Q%JomdQuQM&LJM\md`JYb'MdoikQk(SYbOkmO)JO`Yb*OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MQbid^^`QbmkkoLSdi`+kh+MMd`LdB++kh+MQbid^^`QbmkkoLSdi`8+kh+MkQMmYdbYO,+kh+MQbid^^`QbmkkoLSdi`:+kh+MkQMmYdbYO+kh+MkQMmYdbk+kh+MMd`Ld8B+kh+MkQMmYdbk+kh+MMd`Ld8F+kh+MkmoOQbmk+kh+MQbid^^`QbmkkoLSdi`8+kh+MkmoOQbmk+kh+MSYbOJkmoO+kh+MkmoOQbmk+kh+MSYbOkmoO+kh+MkmoOQbmk8+kh+MQbid^^`QbmkkoLSdi`:+kh+MkmoOQbmk8+kh+MSYbOkmoO+kh+MkmoOQbmksQbid^^+kh+MQbid^^`QbmkkoLSdi`+kh+O[ob\kMWQO+kh+OkQMmYdbYO +kh+OidkmQiu+kh+OkQMmYdbYO +kh+OkMWQOo^Q+kh+OkQMmYdbYO +kh+SMJmJ^dUMdoikQk +kh+SQbid^^`QbmkkoLSdi` +kh+SQbid^^`QbmkkoLSdi`8 +kh+SQbid^^`QbmkkoLSdi`:+kh+SQbmQibQsMdoikQ +kh+Sidd`k+kh+SkQMmYdbk+kh+SkmoOQbmk+kh+SkmoOQbmk8+kh+SkmoOQbmksQbid^^MJmJ^dUMdoikQkMdobmdSQbid^^LvMdoikQhoQivQbid^^`QbmkQbid^^`QbmkhoQivQbid^^`QbmkhoQiv8[dYbkmoOQbmkQbid^^QOkQMmYdbkM^JkkQk[dYbmQbid^^`QbmkhoQiv:[ob\MiQJmQkd`QkQMmYdbkJ[ob\MiQJmQkd`QkQMmYdbkmQkm[ob\Qbid^^`Qbmkbdm:66:hoQiv[ob\hoQiv`kvkJMMQkkdL[QMmk `kvkJMQk`kvkY`QuMd^o`bk`kvkY`QukfQMk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkfdmQbmYJ^JOqYkQQk fiQiQhoYkYmQk!fidSQkkdik"idd`k#idd`kJbOkQMmYdbkQhoYqmd8bSSidkmQihoQiv$kMWQOo^QhoQiv`kQMmYdbQbid^^`QbmMdobmkhoQivkQMmYdbk`kQMmYdbkJbOMdoikQk[dYbhoQivQhoYqmd:bS`kY`o^JmQLJOQbid^^`QbmOQkYUbkY`o^JmQLJOkQMmYdbQbid^^`QbmkkmoOQbmk`kmoOQbmkJbOkQMmYdbkJbOMdoikQk[dYbQhoYqmd8bS`kmoOQbmkhoQiv`kmoOQbmkhoQivhoQiv`kmoOQbmkhoQiv8`kmoOQbmkhoQiv:`kmoOQbmkhoQiv<` mQ`fidd`khoQivmQ`fofOJmQkQMmYdbkhoQivJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOMJmJ^dUMdoikQkfiQiQhoYkYmQk` MJmJ^dUMdoikQkfiQiQhoYkYmQk8` MJmJ^dUMdoikQkkQMmYdbk`"fidSQkkdikkQMmYdbk`!idd`kkQMmYdbk` kQMmYdbkQbid^^`Qbmk`kmoOQbmkQbid^^`Qbmk`'  @ @ @ @ @ @ @ @ @ @ @ @ @ @           !"#$%&' (!)"*#+$,%&'()*+,-. / 0 1 2 3456789:;<=>?@ABC$D`E`F`G`H`I`J`K` L` M` Q`R`STUVWX Y Z [`\ ]` ^_``!a`"& Q!U"[#a`m`NTypeInfoO>3[ge3051305130513" DPB="F4F60989F902FA02FA02" GC="6E6C931377F7F0F8F0F80F" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_main=0, 0, 0, 0, C Form_studentTasks=0, 0, 0, 0, C Form_FacultyTasks=0, 0, 0, 0, C Form_DeansTasks=0, 0, 0, 0, C Form_studentsWenroll=0, 0, 0, 0, C e VB_Name = "Form_main" " Bas0{A9CE5C84Form_mainForm_mainForm_studentTasksForm_studentTasksForm_FacultyTasksForm_FacultyTScriptsVwl0jBlob kPropData 1irmBlob nPropData 2ptHeaderd2`<a<bQcdLabel19"Count Of En22 =MOQSnewCourseopen in add mode so cannot update existing recordsCatalog Courses000 02go to position for new record2Catalog Courses5 %*place cursor on dept field (control)DeptLine24` GroupHeader0m 0<`<b cJi DeptDw Roman`JDetailm`@ bHcCourse#CourBlob qCPropData 3 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @zzzzzzzzz z z z zzzzzzzzzzzzz$z% z& z' z( z) z* z+ z, z- z. z/ z0 z1 z2 z3 z4z5z6z7z8z9z:z;z<z=z>z?z@zAzBzCzDzEzFzGzHzIzJzKzLzMzNzOzP}}}}}}}}}}}} }!}"}#}$}%}&}'}(})}*}+},}-}. }/ }0 }1!}2!}3!}4"}5"}6"}7#}8#}9#}:#};$}<$}=$}>%}?%}@%}A&}B&}C&}D&}E'}F'''((()))* * * + + ++,,,---...///00011 1!2"2#2$3%3&3'4(4)4*5+5,5-6.6/606172737485868798999::>:?:@;D;E;<<<===>>> ? ? ? @ @@AAABBBC0C1C2D3D4D5E9E:E;F?F@FAGBGCGDHEHHIIIJJJKK K L}L}L}M}M}M}Q}Q}Q}R}R}R}S S S TTTUUUVVVWW W!X"X#X$Y%Y&Y'Y(Z)Z*Z+[,[-[.\/\0\1]}G]}H]}I^}J^2^3_4_5_6`}K`}L`}Ma}Na}Oa}P !"#$%&;<=ABC&&&&Q'Q(Q)U*U+U,[-[.[/a6a7a8m<m=m>zzzz zz zzzz!z"z#)PropDataIROEAVCXSYCCAEHJOQCUGWLGIYKB:ty"[Event Procedure]h1U`dabaciPickDean2Dean of Arts and ScienceabelTitl ?"(#E l $Jr7s#### # #$ $ $$ %%%%%%%%&&&&&&&&&' '"'#'$'%'!(&((()(*(+('),).)/)-*0*2*3*4*5*6*1+7+9+:+;+<+8,=,?,@,>-A-C-D-E-F-B.G.I.J.K.L.M.N.O.P.H/Q/S/T/////R000011 1 1 2 222 33334444555566667 7"7#7!8$8&8'8%9(9*9+9):,:.:/:0:1:2:3:4:5:6:7:8:9: :: ;:-;<;>;?;@;A;B;=<C<E<F<G<H<I<D=J=L=M=N=O=P=Q=R=S=T=U="="="= "= "= "= "= "="=" =" =" =" =" ="="="="="="="="="="="="="="=K>">">">" >"!>"">"#>"$>"%> "&> "'>"?"(K @@MJmJ^dUMdoikQkfiQiQhoYkYmQkuMJmJ^dUMdoikQkfiQiQhoYkYmQkuMJmJ^dUMdoikQkfiQiQhoYkYmQk8uMJmJ^dUMdoikQkfiQiQhoYkYmQk8uMJmJ^dUMdoikQkkQMmYdbku MJmJ^dUMdoikQkkQMmYdbku fidSQkkdikkQMmYdbku idd`kkQMmYdbku kQMmYdbkQbid^^`QbmkukmoOQbmkQbid^^`Qbmku ʾCatalog Coursesjunk enrollments not 2002 Query studentsWenrollreport leading to unnormalized students design2Create data access page in Design viewAutoExec^3ά z0Catalog CoursesProfessors" @@ p Qbid^^`QbmkuQbid^^`Qbmku fiQiQhoYkYmQkufiQiQhoYkYmQkufiQiQhoYkYmQkufiQiQhoYkYmQkukQMmYdbku kQMmYdbku kQMmYdbku kQMmYdbku ts Subform~sq_cCombo6) @4MR2KeepLocal Tthhhhhhf `Q9vN@9vN@Sections)22222222220 2A#@A#@~sq_fstudentsWenroll)@4MR2KeepLocal TVJJJJJJH `P~.vN@~.vN@~sq_cstudents1~sq_cenrollments Subform2)' @4MR2KeepLocal T|ppppppn `O-HuN@]yYN@junk create some sections test)FM w@8o@vvj^^^^^^\ `NX7*@Oa7*@joint enrollments Query2)@+o@j^^RRRRRRRP @Md<$@d<$@report leading to unnormalized students design3)~ L9u$@I$@Sections and courses join Query - equiv to 2NF)@@F@~ `KI$@I$@report leading to unnormalized students design2)~ IB'\$@N$@students and sections and courses join equiv to 1NF))@E@ `0z@z@~sq_fstudents)@4MR2KeepLocal TH<<<<<<: `D@O3uN@Professors)@BBB66666664 @1k;@k;@~sq_fstudents1)@4MR2KeepLocal TJ>>>>>>< `.@@~sq_fEnter New Course:)4MR2KeepLocal TNNNNNNNL @,2c_7@id_7@~sq_fenrollments Subform1)4MR2KeepLocal TTTTTTTTR @)W[@W[@~sq_dSchedule~sq_dsectionID)4MR2KeepLocal TXXXXXXXV @&;@;@~sq_cstudents1~sq_cFindStud)4MR2KeepLocal TXXXXXXXV @$z@z@~sq_cstudents~sq_cFindAStud)4MR2KeepLocal TXXXXXXXV @#z@z@~sq_cstudents~sq_cenrollments Subform1)4MR2KeepLocal Tnnnnnnnl @ 2c_7@@enrollments Subform1)JJJJJJJJJJH H19R@19R@studentsenrollments)HHHHHHHHHHF FMx@Mx@RoomsSections)<<<<<<<<<<: a @@ MJmJ^dUMdoikQkuMJmJ^dUMdoikQkuMJmJ^dUMdoikQkuMJmJ^dUMdoikQkuMJmJ^dUMdoikQku MJmJ^dUMdoikQku fidSQkkdiku idd`ku kQMmYdbkukmoOQbmku ) V +efqDW$AFo}U6ĭZseRC.c1]Bl7nPLs( **>wU]p V ( V+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p V ) & ) % ( % +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p % ) $ ( $ +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p $ ) # ( # +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p # ) " ( " +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p " ) ! ( ! +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ! ) ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( ) +aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p ( H( H+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p H) F( F+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p F) B( B+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p B) A( A+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p A) @( @+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p @) ?( ?+aDŽ(;RDW$AF[ݫ%cseRC.c1]B/oKWK}@PLs( **>wU]p <-d Oc M`  y . * % m  >Wh W7M\m@$$)N@)N@~sq_cenroll`#N@ƒN@~sq_cenrollments Subform~sq_cCombo624MR2KeepLocal Thhhhhhhf @" 8@FEѳ@Admin2 @8,,,,,,,,,* !Q7@?@findstd20000000000.    @?@Courses20000000000. P~@?@BackToMain266666666664 nB@?@AutoExec222222222220 G[@?@Schedule222222222220 '@?@rosterX20000000000. d<$@d<$@report leading to unnormalized students design32~ I$@I$@report leading to unnormalized students design22~ Z2۽@@Count Of Enroll By Dept and Course2ffffffffffd @S@@All Enrollments2@@@@@@@@@@> ._@@studentTasks2::::::::::8 hUW@@studentsWenroll2@@@@@@@@@@> ;@@students1244444444442 q`_7@@students222222222220 9vN@9vN@Sections222222222220 g^<@@Rooms2,,,,,,,,,,* G@@main2**********( ƶ&@@FacultyTasks2::::::::::8 @@Enter New Course:2DDDDDDDDDDB z;@@enrollments Subform22JJJJJJJJJJH  2c_7@@enrollments Subform12JJJJJJJJJJH  fW@@enrollments Subform2HHHHHHHHHHF  E@@DeansTasks266666666664  @@@Catalog Courses2@@@@@@@@@@>  q@@AdminTasks266666666664  p_޿@p_޿@UserDefined288888888886  p_޿@p_޿@SummaryInfo2@|DDD88888886 @ ӕ@)~er@AccessLayout24MR2KeepLocal T"@zz:::::::8 @ ޿@ ޿@SysRel2..........,  ޿@ ޿@Scripts20000000000.  ޿@ ޿@Reports20000000000.  ޿@ ޿@Modules20000000000.  ޿@ ޿@Forms2,,,,,,,,,,* `ݿ@ݿ@MSysRelationships0DDDDDDDDDDB ݿ@ݿ@MSysQueries088888888886 ݿ@ݿ@MSysACEs022222222220 ݿ@ݿ@MSysObjects088888888886 `ݿ@ݿ@Relationships0<<<<<<<<<<: ݿ@ݿ@Databases044444444442 ݿ@ݿ@Tables0.........., Ux:O d F ( ]  y ?  | 8  e * p,\> S@pR4F( |?F( M P/Sections!!! / G/ / G.[Sections].[Year]0 g.[Sections].[Sem]/ g.[Sections].[Section]3 g.[Sections].[Course#]3 g.[Sections].[Dept]0 g.[Sections].[sectionID]5 g.Sections!!! . G. . G-([__Student ID] = studentID); '-enrollmentsstudentsWenrollEE' -  G-__Student ID))) O- - G,students!!! ,  G, , G+([__Student ID] = studentID); '+enrollmentsstudents199' +  G+__Student ID))) O+ + G*[students].[Last]0 g*[students].[First]1 g*[students].[Student ID]6 g*students!!! * G* * G)students!!! )  G) ) G(([__Student ID] = studentID); '(enrollmentsstudents77' (  G(__Student ID))) O( ( G'^@ ''Professors.Dept. g'Professors.Name. g'Professors%%% ' ' G&F@ g&[Rooms].[Data Projector]7 g&ooms].[Data Connection]8 g&[Rooms].[Front Computer]7 g&[Rooms].[size]- g&[Rooms].[room]- g&Rooms & & G%[Sections].[Section]3 g%[Sections].[Course#]3 g%[Sections].[Dept]0 g%[Sections].[sectionID]5 g% Sections!!! % G%  % G$Sections!!! $  G$ $ G#b@ '#Sections.Year, g#Sections.Sem+ g#Sections.Section/ g#Sections.[Course#]1 g#Sections.Dept, g#Sections.sectionID1 g#Sections!!! # G# # GLVAL-XN T 8 T & l ^THP XZ22B[stu[RRooms.[Numb Student Workstations]students.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID[Sections].[sectionID] =[enrollments].[sectionID][students].[Student ID] =[enrollments].[studentID][Catalog Courses].[Course#] =[Sections].[Course#][Catalog Courses].[Dept] =[Sections].[Dept][enrollments].[special permission][students].[Student ID] =[enrollments].[studentID][enrollments].[special permission][students Query].[Student ID] =[enrollments].[studentID][enrollments].[special permission][students Query].[Num Credits Earned]students.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept(((students.First)=[What is your first name?]) AND ((students.Last)=[What is your last name?]))students.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept(((enrollments.sectionID)=[Enter Course Index Number]))students.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID((([Catalog Courses].Dept)="BIO") AND ((Professors.Dept)="BIO"))((([Catalog Courses].Dept)="BUS") AND ((Professors.Dept)="MKTG"))[Sections].[sectionID] =[enrollments].[sectionID][students].[Student ID] =[enrollments].[studentID][Catalog Courses].[Course#] =[Sections].[Course#][Catalog Courses].[Dept] =[Sections].[Dept][enrollments].[special permission](((Sections.Sem)="S") AND ((Sections.Year)=1997))Sections.sectionID = enrollments.sectionID[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept(((Professors.Dept)=[Forms]![Sections]![Dept]))[Rooms].[Numb Student Workstations](((Sections.Sem)="F") AND ((Sections.Year)=2002))~%3/O~zN  MY ~K  Ja HHH HfdEZ:6CjQC0Y۟@6_@roster Query2@ |@@^RRF::::::8 `C0Y۟@6_@roster Query2@ |@@^RRF::::::8 `[@4@l@Rooms2@888,,,,,,,* @U@m@Professors2@BBB66666664 @QN&F@Qlĵ@Prerequisites2C@HHH<<<<<<<: @&;-N@oN@MSysAccessObjects2DDDDDDDDDDB BL?@P7"@junk Query2@@NBB66666664 @`@-HuN@]yYN@junk create some sections test2@@vjj^^^^^^^\ @?˂XN@œ;N@@junk create some sections a2-@ |@{pddXXXXXXXV @>X7*@Oa7*@joint enrollments Query22 @@|@{vjj^RRRRRRP `=X+@p+@join students enrolled sections/classes23lpZ@||ppppppn ``;SBZ@Z@enrollments Query2Z@|PPPDDDDDDDB @@@enrollments2@ DDD88888886 @:aS@M@CountOfEnrollByCourse Query2\w@|@~|ppdXXXXXXV `j@s#q@Catalog Courses2@|LLL@@@@@@@> @9A#@A#@~sq_fstudentsWenroll24MR2KeepLocal TJJJJJJJH @` `5g^<@g^<@~sq_fRooms24MR2KeepLocal Tvvv66666664 @`3&";@&";@~sq_fenrollments Subform224MR2KeepLocal TTTTTTTTR @22c_7@id_7@~sq_fenrollments Subform124MR2KeepLocal TTTTTTTTR @`0?@?@~sq_fCatalog Courses2S @4MR2KeepLocal TVJJJJJJH `/W[@W[@~sq_dSchedule~sq_dsectionID24MR2KeepLocal TXXXXXXXV @`-A#@A#@~sq_cstudentsWenroll~sq_cenrollments Subform24MR2KeepLocal Tzzzzzzzx @,;@;@~sq_cstudents1~sq_cFindStud24MR2KeepLocal TXXXXXXXV @`*z@z@~sq_cstudents~sq_cFindStud24MR2KeepLocal TVVVVVVVT @)z@z@~sq_cstudents~sq_cFindAStud24MR2KeepLocal TXXXXXXXV @`'tvN@tvN@~sq_cSections~sq_cCombo1824MR2KeepLocal TTTTTTTTR @`%T ;@T ;@~sq_cenrollments Subform2~sq_csectionID24MR2KeepLocal Tpppppppn @VAkM/ O 1  g + m O !  { ] ?  k M /  s *X_(~`B`-i;G Y =U[students].[Year]0 g=U[students].[Last]0 g=U[students].[Middle]2 g=U[students].[First]1 g=U[students].[Student ID]6 g=Uenrollments''' =Ustudents!!! =USections!!! =UCatalog Courses/// =U G=U =U G<U [grade]& g<U[special permission]3 g<U [sectionID]* g<U [studentID]* g<Uenrollments''' <U <U G;U [grade]& g;U[special permission]3 g;U [sectionID]* g;U [studentID]* g;Uenrollments''' ;U ;U G: co[Catalog Courses].[Course#]: g: co[Catalog Courses].Dept5 g: cob@ ':coSectionsenrollmentsT@C7! :coCatalog CoursesSections`@K?/ :coCatalog CoursesSectionsL@K?/ :co[Catalog Courses].[Course#]: g:co[Catalog Courses].Dept5 g:coCountOfstudentIDCount(enrollments.studentID)[11 o: coenrollments''' : coSections!!! : coCatalog Courses/// :co G:co G: co :co G9students!!! 9  G9 9 G8students!!! 8  G8 8 G7students!!! 7  G7 7 G6Sections!!! 6  G6 6 G5Rooms 5  G5 5 G4Catalog Courses/// 4  G4 4 G3enrollments''' 3  G3 3 G2enrollments''' 2  G2 2 G1enrollments''' 1  G1 1 G0Catalog Courses/// 0  G0 0 G/[Sections].[Section]3 g/[Sections].[Course#]3 g/[Sections].[Dept]0 g/[Sections].[sectionID]5 g2 YUKNGAUGG Y S Y o Y t< Y CY DeptCourse# TitleDescriptionCreditsKKKKKKKKKYQYQYaYYY.rD.rE.rFCourse#DeptPrimaryKey $ $$ %%%%%%%%&&&&&&&&&' '"'#'$'%'!(&((()(*(+('),).)/)-*0*2*3*4*5*6*1+7+9+:+;+<+9N@N@~sq_fstudentsWenrollHHHHHHHHHHH 8N@N@~sq_fstudents1<<<<<<<<<<< 7N@N@~sq_fstudents::::::::::: 6xN@N@~sq_fSections::::::::::: 5xN@xN@~sq_fRooms44444444444 4xN@xN@~sq_fEnter New Course:LLLLLLLLLLL 3U`N@U`N@~sq_fenrollments Subform2RRRRRRRRRRR 2U`N@U`N@~sq_fenrollments Subform1RRRRRRRRRRR 1U`N@U`N@~sq_fenrollments SubformPPPPPPPPPPP 02"N@2"N@~sq_fCatalog CoursesHHHHHHHHHHH /2"N@2"N@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV .2"N@2"N@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT -N@N@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx ,N@N@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn v1b @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @######### # #$ $ $$ %%%%%%%%&&&&&&&&&' '"'#'$'%'!(&((()(*(+('),).)/)-*0*2*3*4*5*6*1+7+9+:+;+<+8,=,?,@,>-A-C-D-E-F-B.G.I.J.K.L.M.N.O.P.H/Q/S/T/////R000011 1 1 2 222 33334444555566667 7"7#7!8$8&8'8%9(9*9) 4  G4 4 G3enrollments''' 3  G3 3 G2enrollments''' 2  G2 2 G1enrollments''' 1  2LVAL;`5zE Y * ̜ T  X  : [  r'X9e/j>öxr" x @h @X x@H e@8 @( p$ @ @ @ @ `DKoLearning Programming and Problem-solving usLearning Programming and Problem-solving using the computer language Java as a vehiclLearning Programming and Problem-solving using the computer language Java as a vehicle.People in groups / society, Frameworks courseMatrices, eigenvectors, with applications3D, partial differentiation and multiple integrationExtra Math for Computer Science MajorsSerious calculus for Math and Science majorslike it says, complexities of marketing internationallyOrganizational and interfunctional interaction, buyer behavior, global interdependenceAdvertising copy, ad agencies, measuring effectivenessSales presentations, lying, networkingDeveloping and Managing a competive workforceWars, Rumors or Wars, Miltary Industrial Complex, Weapons of Mass DestructionWomen's rights, industrial revolution, Women in WarPost Reconstruction, Modern Era, Superpower!Reading, analysis and discussion of prose fictionRead, Write, Think about primary texts (at least two genres)Planning and Executing Writing Assignments - especially about readings, or using library researchGrammar, Organization, Expository WritingBusiness firm and market analysisNational and International economicsTelephone network architecture, local loop, PBX and Centrex, ISDN, ATMPrinciples of process and resource management in OS and their applicationSystems developed to support group cooperation and workA practical approach to network administration using current technologiesPrinciples and Practice of Computer Security, including internet securityHelp desk, installation and supportHardware and Software componenets of a computing systemCreation of dynamic and interactive documents for the internetPlanning, designing and creating multimedia content. Integration into WWWProject oriented - development, testing, change managementProject oriented - requirements analysis, design, prototypingAnalysis of algorithms. Divide and Conquer, greedy, backtracking, dynamic programming, NP completeGeneral Principles and Concepts of process and resource management in OSKnowledge representation, search, heuristic systems and & Picture generation, 2D, 3D, transformationsDatabase systems in an N-tier worldTheory, finite automata, BNF, syntax, semantics, language paradigmsCommunication networks and cooperative processing. LANs WANSAppropriate industrial experienceAdvanced data structures and intro to analysis of algorithmsPrivacy, cryptography, hackers, ethicsApplications for PCs, especially using Visual BasicIntro to Database systems including relational theory and applicationsC++ introduction plus introductory algorithms - searching and sorting etcIntroduces basic packages such as Word, Excel - emphasis on ExcelIntroduces basic packages such as Word, ExcelThermodynamics and kinetics, chemical equilibrium, thermochemistryQuantum Mechanics applied to the solution of elementary systems. Lasers too!Chemistry in society - no math, hardly any labAll the way up through quantum mechanicsAn introduction to chem for real science majors & Time value of money, security valuation, cost of capital, financial statement analysisAccounting without software packagesAn introduction to biology for biology and chemistry majorsHow human bodies work, great for pre-medsA foundation biology course for non-majors, that places emphasis on human biologyA foundation biology course for non-majors, that places emphasis on ecology;r3K  : P  } . x 1 z BI`g-z>MeRL`%HIS329The American Woman5@-." HIS324History of Philadelphia"From William Penn to John StreetU' HIS305US 1877 to Present.@,." HIS251Global History 1500 to PresentWars, Rumors of WarsP. HIS151Global History to 1500 Dinosaurs, Serfs, No computersR& ENG203Fiction3@+# ENG150Themes in Literature>@*0$ ENG108College Writing IIc@)." ENG107College Writing+@(+ ECN213Stats for EconomicsNo proofs, econ examplesI# ECN201Microeconomics#@'* ECN155Modern Economic IssuesMarkets. Plus special topicsP& ECN150Macroeconomics&@&* CSIT461Telecommunications and TelephoH@%;/ CSIT447Applied Operating SystemsK@$6* CSIT392Groupware9@#& CSIT382LANs and Network AdminK@"3' CSIT422SecurityK@!% CSIT321Client Support%@ + CSIT220NetworkingNetworking for IT majorsA CSIT154Intro to IT9@( CSD340Web Scripting@@) CSD210Creating MultimediaK@/# CSC481Project Implementation<@2& CSC480Project Design?@* CSC464Theory of Algorithmsd@0$ CSC457Operating SystemsJ@-! CSC456Intro to Artificial Intelligen=@:. CSC453Graphics-@$ CSC372Database Applications%@1% CSC366Language Theory and DesignE@6* CSC320Networks>@$ CSC360Internship#@& CSC354Data Structures>@+ CSC310Computers, Ethics, and Social(@9- CSC265PC Applications5@+ CSC240Database SystemsH@,  CSC290DataStructuresK@* CSC280Problem Solving and ProgramminY@::. CSC152Intro to Computing, Math / SciC@ :. CSC151Intro to Computing/@ ." CHEM302Physical Chemistry IID@ 2& CHEM301Physical ChemistryN@ /# CHEM202Organic Chemistry IIYou still here?B% CHEM201Organic ChemistryWeed out course for pre-medsL" CHEM150Consumer Chemistry0@/# CHEM112General Chemistry II*@1% CHEM111Intro to Chemistry5@/# BUS200Fundamentals of Financial ManaX@:. BUS150Presentation Skills for Busine Giving Talks, using PowerPointZ. BUS101Intro to Financial Reporting&@8, BIO230Diversity, Evolution and EcoloThe environment and evolutionY. BIO210Cellular Biology and Genetics Basic Biochemistry, DNA, genesY- BIO180Intro to Biology=@,  BIO163Clinical MicrobiologyGerms and killing themI% BIO162Anatomy and Physiology IIMore fun for pre-medsL) BIO161Anatomy and Physiology+@2& BIO158Life Science: A Human approachS@:. BIO157Life Science: An environmentalM@:. tv A q LL Kj 5 ]  v ( `w Detailm7U`<a<bcestudentIDstudentIDm7U`ua<bcegksectionIDsectionIDm7]`a<b ce k$special permission$special permission$special_permissiono5U`bcd<nZ"";"";"";"";"";"";"";"";"";"";"";"";"10";"10" Combo6sectionIDTable/Query|SELECT DISTINCTROW Sections.sectionID, Sections.Dept, Sections.[Course#], Sections.Section, Sections.Sem, Sections.Year FROM Sections WHERE (((Sections.Sem)="F") AND ((Sections.Year)=2002));.960;570;825;765;480;525d5`0 a<bcSectID_Label SectID`FormFooterultyTasks" " Bas0{A9CE5CD4-9C1B-11D3-9E07-0050pacIFalse dCreatablTru Pre declaIͬ =^ZFormHeaderd studentID_LabelstudentID Labeld sectionID_LabelsectionID Labeld special_permission_Labelspecial permission LabelDetailmstudentIDmsectionIDmspecial_permissionspecial permissionoCombo6d SectID_Label FormFooter grade0=Babe g hijkx2c_7@ enrollmentsenrollments Subform1Ariald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5`h FormHeaderd5U7`<a<bcstudentID Label studentID DetachedLabelstudentID_LabeBlob PropData(*TypeInfoSOC150Principles of Sociology/@83' REL153Dynamics of ReligionPatterns courseA$ REL150The Christian TraditionPatterns courseD' PSY155Intro to PsychologyHow people work@# POL151American Government Money Talks<# PHL152Moral Choice"More interesting patterns courseJ PHL151The Human PersonPatterns course=  MTH240Linear Algebra,@7* MTH222Calculus III6@6( MTH221Calculus IIMore serious calc: MTH140Discrete Math(@5) MTH120Calculus.@4$ MTH118Multi-variable Calculus'' MTH114Calculus MTH113Algebra and Triglike it says:  MKTG305International Marketing9@34( MKTG304Business to Business MarketingX@2;/ MKTG302Advertising and Promotional Ma8@1;/ MKTG301Personal Selling(@0-! MGMT354EntrepreneurshipSmall business managementH! MGMT353Dispute Resolution"Conflict management, negotiationQ# MGMT303Managing Human Resources II/@/8, MGMT302Managing Human Resources"creating a competitive workforceW) HIS337The Black ExperienceSlavery, Civil Rights,H$ HIS333The American Imigrantlike it says?% HIS331America's Military PastO@.3'  @@@@@@@@@@@@@@@@@@@@@86886D286F3888 88: 88< 88> 88F 8:68@6 8@6 8@6.8@648@68@68@88@868@88@88@:8@:8@<8@>&8@@/8@@8@D8@F8B68B88B:8B<8F6:66 :68:680:6::6<5:86:86$:8<1::6'::8::::<6:<6:>6:>6:@87:F6:H6<68<68<6:<6:<6:<6<<6> <6@8<6@ <86<:6<:8(<:>9<:H:<<8<<<<6%<@<<@><@>::)>>D,>@<>@B>@D >B8->B>!>F6">F8#r_Labelj2U`aiData ConnectionData ConnectionData_Connectiond5U`<abcData Connection LabelData ConnectionData_Connection_Labelj2U`aiData ProjectorData ProjectorData_Projectord5U`<abcData Projector LabelData ProjectorData_Projector_Labelj2U`aiOverheadOverheadd5U`<abcOverhead LabelOverheadOverhead_Labelm07U`abcekNumb Student WorkstationsNumb Student Workstations2number of computers in room for studets to work atNumb_Student_Workstationsd5U`<abcNumb Student Workstations LabelNumb Student WorkstationsNumb_Student_Workstations_Label` FormFooterFacultyTasks/&H00000000 DocCla0000000 DocClass=Form_studentsWenroll/&H0ͬZDetailFormHeaderFormFootermroomd room_Labelroom Labelmsized size_Labelsize LabeljFront_ComputerFront Computerd Front_Computer_LabelFront Computer Labelj Data_ConnectionData Connectiond Data_Connection_LabelData Connection Labelj Data_ProjectorData Projectord Data_Projector_LabelData Projector Labelj Overheadd Overhead_LabelOverhead LabelmNumb_Student_WorkstationsNumb Student Workstationsd Numb_Student_Workstations_LabelNumb Student Workstations LabelsFor0=Babche gh| ij,kFq`_7@studentsstudentsAriald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5` FormHeadero15Ucd"";"";"10";"4" FindAStud Table/Querystudentsfindstdd5]`8abcLabel25Student to Update:h1`axbci BackToMain Blob  PropData8:ATypeInfoBo8=)L)LBack To Main BackToMaino5U`b cpdn"";"";"";"";"";"";"10";"4"FindStud Table/QuerybSELECT DISTINCTROW [students].[Student ID], [students].[First], [students].[Last] FROM [students]; 1080;675;825findstdd5U`abdcPickStud_LabelStudent to Update`Detail m7U`axbce Student ID Student IDdStudent number - 4 digits - made text so leadin @@@      @     @     LYdLYdLYdLYdLYdLYdLYdLYdLokLok Lok MWQ` MWQ` MWQ` MWQ`MWQ`MWQ`MWQ`MkMMkMMkMMkMMkMMkMMkMMkMMkMMkMMkMMkMMkMMkMMkM MkM!MkM"MkM#MkO$MkO%MkYm&MkYm'MkYm(MkYm)MkYm*MkYm+MkYm,MkYm-QMb.QMb/QMb0QMb1QbU2QbU3QbU4QbU5WYk6WYk7WYk8WYk9WYk:WYkWYkWYk`U`m`U`m`U`m`U`m`\mU`\mU`\mU `\mU `mW `mW `mW `mW`mW`mW`mW`mWfW^fW^fd^fkviQ^iQ^kdMredits EarneddNum_Credits_Earned_LabelNum Credits Earned_LabelmGPAdGPA_LabelmHometowndHometown_LabelmBalance_DueBalance DuedBalance_Due_LabelBalance Due_LabelmsectionIDdsectionID_LabelmSections_DeptdSections_Dept_LabelmSections_Course_Sections_Course#dSections_Course__LabelSections_Course#_Labelm Sectiond!Section_Labelm"Semd#Sem_Labelm$Sections_Yeard%Sections_Year_Labelm&timed'time_Labelm(roomd)room_Labelm*professord+professor_Labelm,stop_pointstop pointd-stop_point_Labelstop point_Labelm.Titled/Title_Labelm0Descriptiond1Description_Labelm2Creditsd3Credits_Labeld4Label46m5Text47m6Text48f7Line49f8Line50f9Line508 :<=Babcwe g4d<$@fstudents and sections and courses join equiv to 1NF^report leading to unnormalized students design3 Arial8 hLexmark 3200 Series ColorFine` odXX  Lexmark 3200 Series ColorFineLPT1:LPT1:  @ @ @LYd8@DLYd8@FLYd8B8LYd8B:LYd8B<LYd8F6LYd:86LYd:<6Lok868Lok8@6 Lok:66 MWQ`888 MWQ`88: MWQ`8@6 MWQ`:68MWQ`:6:MWQ`<68MWQ`<6:MkM8@8MkM8@:MkM:<6MkM:>6MkM:F6MkM:H6MkM<86MkM<:6MkM<@>MkM@<MkM>@BMkM>@D MkM>B>!MkM>F6"MkM>F8#MkO:86$MkO<>6%MkYm8@>&MkYm::6'MkYm<:8(MkYm::)MkYm>>D,MkYm>B8-QMb8@6.QMb8@@/QMb:680QMb:8<1QbU86D2QbU86F3QbU8@64QbU:6<5WYk8@86WYk:@87WYk<6@8WYk<:>9WYk<:H:WYk<<8WYk<<<WYk<`\mU<68`\mU<6:`\mU<6> `\mU<6@ `mW88< `mW88> `mW88F `mW8:6`mW8B6`mW::8`mW:::`mW:>6fW^8@8fW^8@:fd^8@8fkv8@@iQ^8@6iQ^8@<kdM8@6HometownDetachedLabelϵUEzˉ}d7`P(a<bc,"Balance Due_LabelBalance DueDetachedLabel"Balance_Due_Label89AGRQd` 0a<bc,sectionID_LabelSection IndexDetachedLabel]0AiT!d`4a<bc,&Sections_Dept_LabelSections_DeptDetachedLabelLJI3Ld`8a<bc,,Sections_Course#_Label Sections_Course#DetachedLabel,Sections_Course__Labels]Ay Q>>>>>>>>>> 9N@N@~sq_fstudentsWenrollHHHHHHHHHHH 8N@N@~sq_fstudents1<<<<<<<<<<< 7N@N@~sq_fstudents::::::::::: 6xN@N@~sq_fSections::::::::::: 5xN@xN@~sq_fRooms44444444444 4xN@xN@~sq_fEnter New Course:LLLLLLLLLLL 3U`N@U`N@~sq_fenrollments Subform2RRRRRRRRRRR 2U`N@U`N@~sq_fenrollments Subform1RRRRRRRRRRR 1U`N@U`N@~sq_fenrollments SubformPPPPPPPPPPP 02"N@2"N@~sq_fCatalog CoursesHHHHHHHHHHH /2"N@2"N@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV .2"N@2"N@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT -N@N@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx ,N@N@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn v1 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @######### # #$ $ $$ %%%%%%%%&&&&&&&&&' '"'#'$'%'!(&((()(*(+('),).)/)-*0*2*3*4*5*6*1+7+9+:+;+<+8,=,?,@,>-A-C-D-E-F-B.G.I.J.K.L.M.N.O.P.H/Q/S/T/////R000011 1 1 2 222 33334444555566667 7"7#7!8$8&8'8%9(9*9+9):,:.:/:0:1:2:3:4:5:6:7:8:9: ::- 2 G1enrollments''' 1  G1 1 G0Catalog Courses/// @` rT6dF* | ` D ( r V :   p T 8  n R 6  l P 4  jL.jN2nR6rV:vZ>"z\> rV:vZ>"707080514707080506707080505707080461707080103616180496616180433616180431616180414616180301555580494555580474555580448555580436555580311555570238D 555570234B 555566415C 555562341A 555562272B 555511111A 515180496515180466515180449515180408515180405414180514414180506414180505414180492414180438313180463313180436313180410313180403313180202222280511222280453222280406222280405222280201212181201212180494212180424212180419212180301181880496181880469181880451181880406181880403181880202121280492121280471121280452121280408121280405121280201112380511112380491112380470112380447112380321112380301112370232B 112366422B 112366415B 112362341A 112362272D 111980494111980470111980452111980408111980403111980102111966419C 111966417B 111911112B 111782111111780519111780515111780472111780371111780361111769705A 111767488A 111762272C 111680516111680501111680465111680453111680408111680405111666419B 111666415A 111662341B 111580519111580465111580449111580435111580433111580414111580103111566419F 111566417A 111566416103455A111380465111380449111380443111380414111380103111366417A 111362341C 111362272A 111180503111180447111180435111180104111166419C 111166415134556B111162341F 109380474109380443109380322109380311109370234A 109366419D 109366416B 109362341A 101180520101180493101180414101180104NtX< x8181804649999804968181804989191805139999805128181805129999811029191811028181811027171804757171804577171804127171804057171802027@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @8688F686>8688F6>8>8688F6>H<8688F6@:686H<B:<>886H<BB>8B86H<BB>8H86H<D6:<>86H<F6<8886H<F6<:: 86H<F6>>< 86H<F6>D> 8888B:<>8 8888BB>8@ 8888BB>8H8888F686>8888F6><@8888F6>>D8888F6@6<888<B::D:888<B:<>8888<BB>8D888<F686<888<F6>8>888<F6>><888<F6>>H888<F6>B@888@BB>8B888@BB>8D888@BB>8H888@F686<888@F6>8>888@F6><< 888@F6><@!888@F6>>H"888@F6>B@#888@F6@8H$888BB:<>8%888BBB>8@&888BBB>8H'888BF6>6@(888BF6>6F)888BF6>@<*888BF6>B@+888BF6@68,888BF6@8B-888DB::D:.888DBD>FF/888DBHD6@0888DF6D:3888DF6@8@4888DF6@8H5888DF:8886888H8888:7888HBB>8D8888HBB>8H9888HF686::888HF6>6<;888HF6>6F<888HF6>@:=888HF6>D6>888HF6>H>?88:<B::D:@88:<B:<>8A88:<BB>8@B88:<BB>::C88:<D6:<:D88:<F6<68E88:<F6<:8F88:<F6>>DG88:<F6>D6H88:<F6>H8I88:<F6@88J8:8:F6:68K8:8:F6>6@L8:8:F6>6FM8:8:F6>@:N8:8:F6>D8O8:8:F6>H:P8F8FF6:6:Q8F8FF6>6<R8F8FF6>6BS8F8FF6>@8T8F8FF6>BHU8F8FF6>HBV:8:8F6<68W:8:8F6>8HX:8:8F6>:>Y:8:8F6>H>Z:8:8F8:68[::::F6:68\::::F6>6@]::::F6>6B^::::F6>@<_::::F6@88`<8<8F6:6:a<8<8F6>6<b<8<8F6>86c<8<8F6>B<e>8>8F6>8>8F6>H:g>8>8F6@6@h>8>8F6@6Bi>8>8F6@8>j@8@8F6>6@k@8@8F6>6Fl@8@8F6>>Hm@8@8F6>BBn@8@8F6>HBo@@@@88888p@@@@B::D:q@@@@B:<>8r@@@@BB>8@s@@@@D6:<>t@@@@D6:>Fx@@@@F6>D>y@@@@F6>H>zB8B8F6<68{B8B8F6>8>|B8B8F6><8}B8B8F6><<~B8B8F6>HBD6D6F686<D6D6F6>B8D6D6F6@6@D6D6F6@6BD6D6F6@8>D8D8F6:6:D8D8F6>6@D8D8F6>8:D8D8F6>@DD8D8F6>D@F8F8F6>B> F8F8F6>HF F8F8F6@8:F8F8F886:H8H8F6@8< H8H8F886:HHHHF6>HB HHHHF6@8: HHHHF886:<88888p8888:7B::D:B::D:.B::D:@B::D:qB:<>8B:<>8 B:<>8B:<>8%B:<>8AB:<>8rBB>8@ BB>8@&BB>8@BBB>8@sBB>8BBB>8BBB>8DBB>8DBB>8D8BB>8HBB>8HBB>8HBB>8H'BB>8H9BB>::CBD>FF/BHD6@0D6:<:DD6:<>D6:<>tD6:F686>F6:68KF6:68\F6:6:QF6:6:aF6:6:F6<68EF6<68WF6<68{F6<88F6<88vF6<:8FF6<:: F66<;F6>6<RF6>6<bF6>6@(F6>6@LF6>6@]F6>6@kF6>6@F6>6BSF6>6B^F6>6F)F6>6F<F6>6FMF6>6FlF6>86cF6>8:F6>8>F6>8>F6>8>F6>8>|F6>8HXF6>:>YF6><8}F6><< F6><<~F6><@F6><@!F6>>< F6>><F6>>DF6>>DGF6>>FxF6>>HF6>>H"F6>>HmF6>@8TF6>@:=F6>@:NF6>@<*F6>@<_F6>@DF6>B8F6>B<eF6>B> F6>B@F6>B@#F6>B@+F6>BBnF6>BHUF6>D6>F6>D6HF6>D8OF6>D:3F6>D> F6>D>yF6>D@F6>H8IF6>H:PF6>H:gF6>H<F6>H>?F6>H>ZF6>H>zF6>HBVF6>HBoF6>HBF6>HB F6>HF F6@68,F6@6<F6@6@hF6@6@F6@6BiF6@6BF6@88JF6@88`F6@8:F6@8: F6@8< F6@8>jF6@8>F6@8@4F6@8B-F6@8H$F6@8H5F6@:6F886:F886:F886:F8:68[F:8886@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @868886888688868886H<86H<86H<86H<86H<86H< 86H< 86H< 8888 8888 88888888888888888888888<888<888<888<888<888<888<888<888@888@888@888@888@888@ 888@!888@"888@#888@$888B%888B&888B'888B(888B)888B*888B+888B,888B-888D.888D/888D0888D1888D2888D3888D4888D5888D6888H7888H8888H9888H:888H;888H<888H=888H>888H?88:<@88:<A88:<B88:<C88:<D88:<E88:<F88:<G88:<H88:<I88:<J8:8:K8:8:L8:8:M8:8:N8:8:O8:8:P8F8FQ8F8FR8F8FS8F8FT8F8FU8F8FV:8:8W:8:8X:8:8Y:8:8Z:8:8[::::\::::]::::^::::_::::`<8<8a<8<8b<8<8c<8<8d<8<8e>8>8f>8>8g>8>8h>8>8i>8>8j@8@8k@8@8l@8@8m@8@8n@8@8o@@@@p@@@@q@@@@r@@@@s@@@@t@@@@u@@@@v@@@@w@@@@x@@@@y@@@@zB8B8{B8B8|B8B8}B8B8~B8B8D6D6D6D6D6D6D6D6D6D6D8D8D8D8D8D8D8D8D8D8F8F8F8F8F8F8 F8F8 H8H8H8H8 HHHHHHHH HHHH ?w;q,  B  I J  z / 8 z\> 4FX:Zp1[1}K @U[Catalog Courses].[Course#]: g@UCatalog Courses_Dept[Catalog Courses].Dept]99 o@UProfessors%%% @UCatalog Courses/// @U G@U G@U @U G?U@  '?UExpr5room "O 113"8# ?UExpr4sectionID80403@- ?UExpr3Year"2002"7# ?UExpr2Sem"F"2! ?UExpr1Section"01";) ?UprofessorProfessors.Name@# w?UCourse#[Catalog Courses].[Course#]H w?UCatalog Courses_DeptDept[Catalog Courses].DepteA9 ?UProfessors%%% ?UCatalog Courses/// ?U G?USections!!! O?U ?U G> Uenrollments_1.sectionID6 g> Uenrollments.sectionID4 g>Uenrollments_1.sectionID6 g>UCountOfstudentID Count(enrollments_1.studentID)]11 o>Uenrollments.sectionID4 g>UCountOfstudentID1Count(enrollments.studentID)]33 o>Uenrollmentsenrollments_1AA' >Uenrollments''' >U G>U G>U >U G=USectionsenrollmentsb@ C7! =Ustudentsenrollmentsd@ C7! =UCatalog CoursesSectionsb@ K?/ =UCatalog CoursesSectionsV@K?/ =U[Catalog Courses].[Credits]: g=U![Catalog Courses].[Description]> g=Uatalog Courses].[Title]8 g=U[Catalog Courses].[Course#]: g=U[Catalog Courses].[Dept]7 g=U[Sections].[stop point]6 g=U[Sections].[professor]5 g=U[Sections].[room]0 g=U[Sections].[time]0 g=U[Sections].[Year]0 g=U[Sections].[Sem]/ g=U[Sections].[Section]3 g=U[Sections].[Course#]3 g=U[Sections].[Dept]0 g=U[Sections].[sectionID]5 g=U[enrollments].[grade]4 g=U D@ g=U nrollments].[sectionID]8 g=U nrollments].[studentID]8 g=U [students].[Balance Due]7 g=U [students].[Hometown]4 g=U[students].[GPA]/ g=U![students].[Num Credits Earned]> g=U[students].[Major]1 g$ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @######### # #$ $ $$ %%%%%%%%&&&&&&&&&' '"'#'$'%'!(&((()(*(+('),).)/)-*0*2*3*4*5*6*1+7+9+:+;+<+8,=,?,@,>-A-C-D-E-F-B.G.I.J.K.L.M.N.O.P.H/Q/S/T/////R000011 1 1 2 222 33334444555566667 7"7#7!8$8&8'8%9(9*9+9):,:.:/:0:1:2:3:4:5:6:7:8:9: :: ;:-;<;>;?;@;A;B;=<C<E<F<G<H<I<D=J=L=M=N=O=P=Q=R=S=T=U="="="= "= "= "= "= "="=" =" =" =" =" ="="="="="="="="="="="="="="=K>">">">" >"!>"">"#>"$>"%> "&> "'>"?"(K#s @ @ @ @ @ @ @ @ @ @ @ @ @ @?"*?"+?",?"-?".?"/?"0?"1?"2?"3?"4?"5?"6?")@"7@"9@":@";@"<@"=@">@%@%@%@"8A%A%A%A%A%A% A% A% A% A% A%A%A%B%B%B%B%B%B%B%B%B %B %B %B %B %B %B %B % B  %!B%C%"C%$C%%C%&C%'C%(C%)C%*C%+C%,C%-C%.C%/C%0C%#D%1D%3D%4D%5D%6D%7D%8D%9D%:D%;D%D%?D%@D%AD%BD%CD%DD%2E%EElElElElElElElElElEl El El E l E l E lE lE lElElE lE lE lE%FFlFlFlFlFlFlFlFlFlFl Fl!Fl"Fl#Fl$Fl%F l&F l'F l(F l)F l*Fl+Fl,Fl-Fl.Fl/Fl0Fl1Fl2Fl3Fl4Fl5Fl6Fl7Fl8F l9F l:FlGl;Gl=Gl>Gl?GrGrGrGrGrGrG rG rGlLN@LN@joint enrollments Query2PPPPPPPPPPP =)N@LN@join students enrolled sections/classesnnnnnnnnnnn <)N@)N@enrollments Query1DDDDDDDDDDD ;N@)N@enrollments QueryBBBBBBBBBBB XN@N@enrollments66666666666 :XN@XN@CountOfEnrollByCourse QueryVVVVVVVVVVV N@N@Catalog Courses>>>>>>>>>>> 9N@N@~sq_fstudentsWenrollHHHHHHHHHHH 8N@N@~sq_fstudents1<<<<<<<<<<< 7N@N@~sq_fstudents::::::::::: 6xN@N@~sq_fSections::::::::::: 5xN@xN@~sq_fRooms44444444444 4xN@xN@~sq_fEnter New Course:LLLLLLLLLLL 3U`N@U`N@~sq_fenrollments Subform2RRRRRRRRRRR 2U`N@U`N@~sq_fenrollments Subform1RRRRRRRRRRR 1U`N@U`N@~sq_fenrollments SubformPPPPPPPPPPP 02"N@2"N@~sq_fCatalog CoursesHHHHHHHHHHH /2"N@2"N@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV .2"N@2"N@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT -N@N@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx ,N@N@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn v1 @ @ @ @ @ @ @?"*?"+?",?"-?".?"/?"0?"1?"2?"3?"4?"5?"6?")@"7@"9@":@";@"<@"=@">@%@%@%@"8A%A%A%A%A%A% A% A% A% A% A%A%A%B%B%B%B%B%B%B%B%B %B %B %B %B %B %B %B % B% AUSections.Year, gAUenrollments.grade0 gAU"enrollments.[special permission]? gAUenrollments.sectionID4 gAUenrollments.studentID4 gAUenrollments''' AUSections!!! AU GAU GAU AUK&[@@@@ 8B@SysAccessObjects)LLLLLLLLLLJ x99K&[ࡱ>  Root EntryZp@VBA`L_VBAProject`L_VBA`L_ 2345678OPQRSTUVW^`btachdefgikjlpmnoqsruzvwxy{|}~FHDDirDatau6PropDatarScripts[z6L6L0x6L6L\ I_]KBGM !%"C#2L '()*+,-./014O6789:;<=>?A $3NSPQRTWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~"All EnrollmentsHCount Of Enroll By Dept and CourserosterX 8CB0 7CB0 4CB0 5CB0 0CB0 1CB0 2CB0 3CB0 6CB0 9CB0 22fill the whole screenopen main menumain0-10  HHCM@KVU5OU 3QXU`Z`L 9S6_@QETFH`7Oo5+PEPsWenrollGUPs+!R:rl@8Q`6COXKXWAFEPDXXMFOJD@WFSVNA6R"5X"OWMF2PX8F@9JW` S6N ElR/q/K*mrU~~~~~~~j  %4BJ<3(8  K&[ 9a Y 1 a !9 Form_mainForm_studentTasksForm_FacultyTasksForm_DeansTasksForm_studentsWenrollReport_Report1 universityFG\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\Common\MSShared\VBA\VBA6\VBE6.DLLVBA  `J_N?@\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\MSOffice\Office\MSACC9.OLBAccess\WĹMhV+I  1p^F=C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO350.DLLDAO a0FC:\WINNT\System32\stdole2.tlbstdole yWFJ\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\Common\MSShared\VBA\VBA6\VBE6EXT.OLBVBIDE Y!=s \@u3 {uxkL\!]!ү7{NZ@C7?FirstMiddleLastYear31?FormSC7?DetailMajorNum_Credits_EarnedGPAHometown Balance_DuePC7?enrollments_SubformAC7?enrollments_Subform_LabelEC7? Command22 Command26 FormHeader FormFooter Student_IDCommand26_Click ickFac_ClickPickDean_ClickPickAdmin_Click ` studentsɤs h)aN? `GXGPfĤIx8< VBE6.DLLrwKz$T    S  studentTasks FacultyTasks DeansTasks AdminTasks]>џI;TIpOhGyF\ΩP)aB HʌBackSeeSched PickRegisterSeeSched_Click Back_ClickPickRegister_Click T Schedule mainʛJN \ΩP)Buo_Dg N SeeRosterGoodBackSeeRoster_Click rosterX wI=FіuўfAHLÊ]ΩP)e!5NSeeCourseCountsSeeCourseCounts_Click DCount Of Enroll By Dept and Courseb\O#>e7GW߮A CGQtǔ,ү7{NZ::kh@#!'@C7?FirstMiddleLastYearMajorGPANum_Credits_EarnedHometown Balance_DuePC7?enrollments_Subformenrollments_Subform_Label Command22 Command26 FormHeader FormFooter Student_IDCommand26_Click ArU~~~~~~s     (  8  H i X\X\rU 0@4 a1zzz@8 aI~~~@< aaK&[@@ ay@D@Hppp@L a @P a) @T aY @X ai @\ a @`  @d ) @ hi  @ li   @p rrr@t ttt@x a vvv0   lX''' , pp ,>,F p6  O,tx$,p KR Cx@'0%ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  O,tx$,p T48<8rU $` n $` $` $` n__SRP_3t__SRP_4 x__SRP_5__SRP_6rU    A i y  !Iq @4) Q rrr@8 ppp@ < avvvI@ @ attt @D@ H axxxK&[dWKACx/'D%'T%lxFd%t$ `t t<''' @ tt ,>@F0 t60  >|(x$@t0 KRCx@'0%ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  O,tx$,p KR Cx@'0%ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  O,tx$,p @<HHrU T$` $A` $` nrU 0   A i y  1Y @ 4 attt @ 8 axxx@<) Q rrr@@@ D avvvI@H pppdWKACx/'D%'T%lxFd%t$ `t t<''' @ tt ,>@F0 t60  >|(x$@t0 KRCx@'0%ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  O,tx$,p 4DPrU T$__SRP_7__SRP_8 __SRP_9g__SRP_a r` $A` nrU `  A i y Ai@4) Q rrr@8) i ttt@ < avvv @@@ D axxx@H pppdKACx/'D%'T%lxFd%t$ `t t<''' @ tt ,>@F0 t60  >|(x$@t0 <XK&[ࡱ> rU T$` nrU   A i y  1@4Yzzz@8Y~~~@<Y@@Y@D@H ppp@LY@PY @TY@XY9@\YY@`y@d) @ h a@ l a1  @pQrrr@tqttt@xYvvv Kx7((F%'8%(H%(X%(h%x$ `x 4x7((F%'8%(H%(X%(h%x$ `x 4x<'''$ xx ,>$F x6 u$ $$xlXrU $ ` n__SRP_bg_VBA_PROJECT$ARBEUKCOMYDTYDVSTWNJHTDVISPE: DMSWIRNZJFKLWDFQSMBBEXLQEZLK:9am  **\G{000204EF-0000-0000-C000-000000000046}#4.0#9#\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\Common\MSShared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications(*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\MSOffice\Office\MSACC9.OLB#Microsoft Access 9.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO350.DLL#Microsoft DAO 3.51 Object Library*\G{00020430-0000-0000-C000-0K&[00000000046}#2.0#0#C:\WINNT\System32\stdole2.tlb#OLE Automationh*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\Common\MSShared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3 >8DMSWIRNZJFKLWDFQSMBBEXLQEZLK123eb3e6f8Form_mainu8LVLIFQMPRWOSMDPJKXUHGTXTVADI133eb3e6f8?"Form_studentTasksA8ARBEUKCOMYDTYDVSTWNJHTDVISPE143eb3e6f8W"Form_FacultyTasks0 8MRXLUFFKUUQDXDZRLLSP_BENFYHH153eb3e6f8_Form_DeansTasks+H8RBECOXKXWAFEPDXXMFOJDWFSVNAE1=3eb3f070g(Form_studentsWenrollq`R0H`CXo@MP7"T\ O 1ZEQ2(nBȏEBGeO ^˳EQ~+JBAccessVBAWin16~Win32MacVBA6# university.DAO Form_mainN _EvaluateChooseStud_ClickErr_ChooseStud_Click. stDocNamezstLinkCriteriaYDoCmdƧOpenFormExit_ChooseStud_Click4MsgBoxRErro Description PickStud_Click Err_PickStud_ClickIExit_PickStud_Click PickFac_Click|Err_PickFac_Click,Exit_PickFac_ClickaKPickDean_ClickErr_PickDean_ClickOExit_PickDean_ClickPickAdmin_ClickCErr_PickAdmin_Click:aExit_PickAdmin_ClickForm_studentTasksaSeeSched_Click0Err_SeeSched_Click OpenReport acPreviewoExit_SeeSched_Click+ Back_Click/Err_Back_Click`Exit_Back_ClickPickRegister_ClickErr_PickRegister_ClickExit_PickRegister_ClickForm_FacultyTasksASeeRoster_ClickRErr_SeeRoster_ClickITExit_SeeRoster_ClickForm_DeansTasks=SeeCourseCounts_ClicksErr_SeeCourseCounts_ClickExit_SeeCourseCounts_ClickForm_studentsWenroll8Command26_Click;Err_Command26_Click2i DoMenuItem&e acFormBar acEditMenu acMenuVer70XExit_Command26_Clickstdole`VBIDEAFormDetail2Label0,Label1,PickStudPickFac@PickDean PickAdminCommand7ClickSeeSched0Back_ PickRegister SeeRosterOiGoodBackSeeCourseCounts? FormHeader  FormFooterT Student_IDStudent_ID_Label~Firstz First_Label9MiddleX Middle_LabelLastbh Last_LabelYear6n Year_LabelBMajor' Major_LabelfNum_Credits_EarnedNum_Credits_Earned_Label!yGPAƔ GPA_LabelI2Hometown{8Hometown_Label8 Balance_DueBalance_Due_Label3ienrollments_Subformenrollments_Subform_Label Command22 Command26Report_Report1"Report$PageHeaderSectionwPageFooterSectionLine0K&[Line1Image2`Image3aLine4Line5Line6Image7eImage8fLine9Line106Line117Image12GImage13GLine14:Line15;Line16<Image17GImage18GLine19?Line20[Line21\Image22=GImage23>GLine24_Line25`Line26aImage27BGImage28CGLine29dLine30Line31Image32bGImage33cGLine34Line35Line36Line37Line38Line39Line40Line41Line42Line43Line44Line45Image46GImage47GLine48Line49Line50Image51GImage52GLine53Line54Line55Image56GImage57GLine58ecl0  ecltitle0\ecl1  ecltitle1\ecl2  ecltitle2\ecl3  ecltitle3\ecl4!  ecltitle4\ecl5"  ecltitle5\ecl6#  ecltitle6\ecl7$  ecltitle7\ecl8%  ecltitle8\ecl9&  ecltitle9\ecl10p! ecltitle10" ReportHeaderŃ ReportFooterR.Label81DLabel82E Detail_FormatCCancel FormatCountItemData ControlsKItemzg?vxW_  Z0   lX''' , pp ,>,F p6  O,tx$,      !"#$%&'()*+,-./0123456789;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklnopstuvy{|}~m ʛJN \ΩP)Buo_Dg NxME SLS S<(<,<<<<< <$<0<4<8<<<N0{A9CE5CD4-9C1B-11D3-9E07-00509508298F} h XX`@`x J`@`xmain`t %X0 %V` %0@" t @d @T @D p@ @0 @ @ @  p @` @P @@ @0 p, @ @ @ @K&[ XX8T>$ "  (/8 PX `<hx "   @  < xpZ`]@rosterX'  F B@D \(| Z "!$A@ $\oxXLh]]main'   B@N(| L "!$A@ NoAttribute VB_Name = "Form_FacultyTasks" " Bas0{A9CE5CD4-9C1B-11D3-9E07-00509508 298F} |GlobalSpacIFalse dCreatablTru Pre declaId"Expose_TemplateDerivCustomizD$Option Comp@ D3T  X "  ( 0@@ X` h<p "  @  < "  (0 8@P hp x< "  @  <  "(0 8@ H@` x < xp`]@]Xstudents'   B@ | "!$A@ xopp(`]] studentTasks'   B@*|( "!$A@ *o.] ]8 FacultyTasks'   B@0|. "!$A@ 0ho`P4P]] DeansTasks'   B@6|4 "!$A@ 6o:]] AdminTasks'   B@<|x:p "!$A@ <XoPHZAttribute VB_Name = "Form_main" " Bas0{A9CE5C84-9C1B-11D3-9E07-00509508 298F} |GlobalSpacFalse dCreatablTru Pre declaId"Expose_TemplateDeriv%CustomizD$Option Comp@ D3T   %@" t @d @T @D p@ @0 @ @ @  p @` @P @@ @0 p, @ @ @ @  p @` @P @@ @0 p, @ @ @ @ 888Th>5 "  (/8 PX `<hx "   @  < "   (@8 PX `<hx xpB`]@Schedule'  F B@D H(| B "!$A@ $HoxXLh]]main'   B@N(| L "!$A@ NoR]] students'   K&[B@T|R "!$A@ Toxp&Attribute VB_Name = "Form_studentTasks" " Bas0{A9CE5C96-9C1B-11D3-9E07-00509508 298F} |GlobalSpacIFalse dCreatablTru Pre declaId"Expose_TemplateDerivCustomizD$Option Comp@ D3T   "  *(/X px < xpb`]@"Count Of Enroll By Dept and Course'  F B@Dd|bx "!$A@ d`oXPDZAttribute VB_Name = "Form_DeansTasks" Bas0{A9CE5D02-9C1B-11D3-9E07-00509508298F} |GlobalSpacI False dCr@eatablTru PredeclaId"Expose_Template DerivCustomizD$Option Comp@ DT  $*\Rffff*1=3eb3f070z4~8<@DpHLPTX\`dhlrpttvx"  770 PX `<hx jp n p r B@lCoun n p r B@lse't(| j "!$A@ toxpAttribute VB_Name = "Form_studentsWenroll" Bas0{7B37AFD2-914E-11D3-B7F7-00105A10971B} |GlobalSpacIFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$P Sub Command26_Click() On Error GoTo_  DoCmd.DoMenuItem ac!Bar,Edit , 8, Ver70 6 Exit%:6)2T MsgBox7.Descri ptionCRe?@CDEFGHIJKLMNOQRSTUVWXYZ[\]^_`abcdefghijklmnopqruvwxyz{|}~0=BabcP e gg^<@RoomsRoomsAriald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5` FormHeader`_ Detailm7U`axbceroomroom&unique identifier for room e.g. at134d5U`<axbc room Labelroom room_Labelm07U`abceksizesizecapacityd5U`<abc size LabelCapacity size_Labelj2U`aHiFront ComputerFront Computer6whether there is a computer up front for the professorFront_Computerd5U`<aHbcFront Computer LabelFront ComputerFront_Computer_Labelj2U`aiData ConnectionData ConnectionData_Connectiond5U`<abcData Connection LabelData ConnectionData_Connection_Labelj2U`aiData ProjectorData ProjectorData_Projectord5U`<abcData Projector LabelData ProjectorData_Projector_Labelj2U`aiOverheadOverheadd5U`<abcOverhead LabelOverheadOverhead_Labelm07U`abcekNumb Student WorkstationsNumb Student Workstations2number of computers in room for studets to work atNumb_Student_Workstationsd5U`<abcNumb Student Workstations LabelNumb Student WorkstationsNumb_Student_Workstations_Label` FormFooterFacultyTasks/&H00000000 DocCla0000000 DocClass=Form_studentsWenroll/&H0ͬZDetailFormHeaderFormFootermroomd room_Labelroom Labelmsized size_Labelsize LabeljFront_ComputerFront Computerd Front_Computer_LabelFront Computer Labelj Data_ConnectionData Connectiond Data_Connection_LabelData Connection Labelj Data_ProjectorData Projectord Data_Projector_LabelData Projector Labelj Overheadd Overhead_LabelOverhead LabelmNumb_Student_WorkstationsNumb Student Workstationsd Numb_Student_Workstations_LabelNumb Student Workstations LabelsFor0=Babche gh| ij,kFq`_7@studentsstudentsAriald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5` FormHeadero15Ucd"";"";"10";"4" FindAStud Table/Querystudentsfindstdd5]`8abcLabel25Student to Update:h1`axbci BackToMain Blob  PropData8:ATypeInfoBo8=)L)LBack To Main BackToMaino5U`b cpdn"";"";"";"";"";"";"10";"4"FindStud Table/QuerybSELECT DISTINCTROW [students].[Student ID], [students].[First], [students].[Last] FROM [students]; 1080;675;825findstdd5U`abdcPickStud_LabelStudent to Update`Detail m7U`axbce Student ID Student IDdStudent number - 4 digits - made text so leadinK&[g zeroes dont go away - not doing math on them anyway Student_IDd5U`<axbcStudent ID Label Student IDStudent_ID_Labelm7U`abcekFirstFirstStudent First Named5U`<abc First LabelFirst First_Labelm7U`aHbcekMiddleMiddleStudent Middle Initiald5U`<aHbc Middle LabelMiddle Middle_Labelm7U`abcekLastLastStudent Last Named5U`<abc Last LabelLast Last_Labelo05Ubcdefh nYearYear Value List"Fr";"So";"Jr";"Sr";"Grad"1440&Student Academic Year (Fr, So, Jr, Sr)d5U`<abc Year LabelYear Year_Labelm7U`axbcekMajorMajor Student Majord5U`axbc Major LabelMajor Major_Labelm07U`abcekNum Credits EarnedNum Credits Earned(Student Number of Credits Earned to DateNum_Credits_Earnedd5U`abcNum Credits Earned Label TotalCreditsNum_Credits_Earned_Labelm07U`aHbce kGPAGPAXStudent Current GPA (derived from student course grades - must be updated each semester)d5U`aHbc GPA LabelGPA GPA_Labelm7U`abcekHometownHometown:Student Hometown (in reality would have whole address too)d5U`abcHometown LabelHometownHometown_Labelm7U`abce k Balance Due Balance Due$#,##0.00;($#,##0.00),Amount Student Currently owes the university Balance_Dued5U`abcBalance Due Label Balance DueBalance_Due_Labelp3W`<a4bcd enrollments Subform1Form.enrollments Subform1 studentID Student IDenrollments_Subform1d5]`<aDbfcenrollments Subform1 Label enrollmentsenrollments_Subform1_Label` FormFootert Dept_Labelm7U`abcekͬZʖZDetailFormHeaderFormFootermStudent_IDStudent IDd Student_ID_LabelStudent ID LabelmFirstd First_LabelFirst LabelmMiddled Middle_LabelMiddle Labelm Lastd Last_LabelLast Labelo Yeard Year_LabelYear Labelm Majord Major_LabelMajo IKBGM"C#2L'()*+,-./014O6789:;<=>? E J$3NSPQRTWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~r LabelmNum_Credits_EarnedNum Credits Earnedd Num_Credits_Earned_LabelNum Credits Earned LabelmGPAd GPA_LabelGPA LabelmHometownd Hometown_LabelHometown LabelmBalance_DueBalance Dued Balance_Due_LabelBalance Due Labelpenrollments_Subform1enrollments Subform1d enrollments_Subform1_Labelenrollments Subform1 Labeld Label25h BackToMaind PickStud_LabeloFindAStudoFindStud`Blob PPropData<>sTypeInfot09;CA)L)L0=Babche ghXiJj"k;@students students1Ariald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5`HK&[ FormHeadero5Ucdd"";"";"10";"4"FindStud Table/Querystudentsfindstdd5UabcLabel23Student to Find:`Detail m7U`axbce Student ID Student IDdStudent number - 4 digits - made text so leading zeroes dont go away - not doing math on them anyway Student_IDd5U`<axbcStudent ID Label Student IDStudent_ID_Labelm7U`abcekFirstFirstStudent First Named5U`<abc First LabelFirst First_Labelm7U`aHbcekMiddleMiddleStudent Middle Initiald5U`<aHbc Middle LabelMiddle Middle_Labelm7U`abcekLastLastStudent Last Named5U`<abc Last LabelLast Last_Labelo05Ubcdefh nYearYear Value List"Fr";"So";"Jr";"Sr";"Grad"1440&Student Academic Year (Fr, So, Jr, Sr)d5U`<abc Year LabelYear Year_Labelm7U`axbcekMajorMajor Student Majord5U`axbc Major LabelMajor Major_Labelm07U`abcekNum Credits EarnedNum Credits Earned(Student Number of Credits Earned to DateNum_Credits_Earnedd5U`abcNum Credits Earned Label TotalCreditsNum_Credits_Earned_Labelm07U`aHbce kGPAGPAXStudent Current GPA (derived from student course grades - must be updated each semester)d5U`aHbc GPA LabelGPA GPA_Labelm7U`abcekHometownHometown:Student Hometown (in reality would have whole address too)d5U`abcHometown LabelHometownHometown_Labelm7U`abce k Balance Due Balance Due$#,##0.00;($#,##0.00),Amount Student Currently owes the university Balance_Dued5U`abcBalance Due Label Balance DueBalance_Due_Labelp3W`<a4bcd enrollments Subform2Form.enrollments Subform2 studentID Student IDenrollments_Subform2d5]`<aDbfcenrollments Subform2 Label enrollmentsenrollments_Subform2_Label` FormFooterx ͬZDetailFormHeaderFormFootermStudent_IDStudent IDd Student_ID_LabelStudent ID LabelmFirstd First_LabelFirst LabelmMiddled Middle_LabelMiddle Labelm Lastd Last_LabelLast Labelo Yeard Year_LabelYear Labelm Majord Major_LabelMajor LabelmNum_Credits_EarnedNum Credits Earnedd Num_Credits_Earned_LabelNum Credits Earned LabelmGPAd GPA_LabelGPA LabelmHometownd Hometown_LabelHometown LabelmBalance_DueBalance Dued Balance_Due_LabelBalance Due Labelpenrollments_Subform2enrollments Subform2d enrollments_Subform2_Labelenrollments Subform2 Labeld Label23oFindStudlo sectio0=Babc e ghgij$kE@Ariald2hgh MS Sans Serif`Detaild5U`Ha,bcXdeLabel0Deans Information Systemd5U`,ab4cYd Label1Choose Your Task:h1U`daDbEcSeeCourseCountsSee Course Counts[Event Procedure]h1U` abciBack Back to Main BackToMain(  @` @PBlob _PropDataK&[@BTypeInfow10E)L)Lͬ]ΩP)Detaild Label0d Label1h SeeCourseCountsh Backspecial0=Babc e ghgihj$kƶ&@Ariald2hgh MS Sans Serif`Detaild5U`abcYd eLabel0.Oh, overburdened master what can I do for you?h1U`ta8b c SeeRoster See Roster[Event Procedure]h1U`atbciBack Back to Main[Event Procedure]h1U`aDbQ ciGoodBackClose Menu and Back to Main BackBlob PropDataDFTypeInfos11?OI)L)LToMainIDd studentID_LabelstudentID LabelosectiD_LabelsectionID Labelmspecial_peͬ\ΩP)Detaild Label0h SeeRosterh Backh GoodBackLabelgrade L0=Babc0*e ghYijz+kn@ Ariald2hghMS Sans Serif`! Detaild5U`a,b%cde Label0(La Salle University d5U`abcYd LaBlob ,PropDataHJTypeInfo12M)L)Lbel1"Select Your Role:h1U`abcPickStudI am a Student"[Event Procedure]h1U`a b(ciPickFacFaculty"[Event Procedure]h1U`dabaciPickDean2Dean of Arts and Sciences"[Event Procedure]h1U`a$ btciPickAdminAdministrator"[Event Procedure]h1U`a\ bVciCommand7New CoursegetridofthistooLabelCredits CredFormFooter GoTo_' Dim stDocAsͬ\ΩP)Detaild Label0d Label1h PickStudh PickFach PickDeanh PickAdminh Command7FormFooterm0=Babche gUbW@studentsstudentsWenrollAriald2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4Blob VPropDataLNTypeInfo/13KWQ)L)Ln2o2p5r35zij MS Sans Serif{5K&[`  FormHeaderh1U`Da,bc Command26 Delete Record[Event Procedure]`Detail m7U`axbce Student ID Student IDdStudent number - 4 digits - made text so leading zeroes dont go away - not doing math on them anyway Student_IDd5U`<axbcStudent ID Label Student IDStudent_ID_Labelm7U`abcekFirstFirstStudent First Named5U`<abc First LabelFirst First_Labelm7U`aHbcekMiddleMiddleStudent Middle Initiald5U`<aHbc Middle LabelMiddle Middle_Labelm7U`abcekLastLastStudent Last Named5U`<abc Last LabelLast Last_Labelm7U`abcekYearYear&Student Academic Year (Fr, So, Jr, Sr)d5U`<abc Year LabelYear Year_Labelm7U`axbcekMajorMajor Student Majord5U` axbc Major LabelMajor Major_Labelm07U`abcekNum Credits EarnedNum Credits Earned(Student Number of Credits Earned to DateNum_Credits_Earnedd5U` abcNum Credits Earned Label TotalCreditsNum_Credits_Earned_Labelm07U`aHb ce kGPAGPAXStudent Current GPA (derived from student course grades - must be updated each semester)d5U` aHbc GPA LabelGPA GPA_Labelm7U`abcekHometownHometown:Student Hometown (in reality would have whole address too)d5U` abcHometown LabelHometownHometown_Labelm7U`ab ce k Balance Due Balance Due$#,##0.00;($#,##0.00),Amount Student Currently owes the university Balance_Dued5U` abcBalance Due Label Balance DueBalance_Due_Labelp3W`<a4bcd enrollments SubformForm.enrollments Subform studentID Student IDenrollments_Subformd5]`<aDbfcenrollments Subform Label enrollmentsenrollments_Subform_Label`8 FormFooterh1U`a Command22 Command22_Workstations_Label` FormFooter00 DocCla0000000 Dͬү7{NZDetailFormHeaderFormFootermStudent_IDStudent IDd Student_ID_LabelStudent ID LabelmFirstd First_LabelFirst LabelmMiddled Middle_LabelMiddle Labelm Lastd Last_LabelLast Labelm Yeard Year_LabelYear Labelm Majord Major_LabelMajor LabelmNum_Credits_EarnedNum Credits Earnedd Num_Credits_Earned_LabelNum Credits Earned LabelmGPAd GPA_LabelGPA LabelmHometownd Hometown_LabelHometown LabelmBalance_DueBalance Dued Balance_Due_LabelBalance Due Labelpenrollments_Subformenrollments Subformd enrollments_Subform_Labelenrollments Subform Labelh Command22h Command26Serifi1gh0=Babe ghgihj"k._@Ariald2hgh MS Sans Serif`@ Detaild5U`abcdLabel0!Where would you like to Go Today?h1U`8aBlob }PropDataPRTypeInfov14U)L@LbcSeeSchedSee My Schedule[Event Procedure]h1U`xa(bciBack Back to Main[Event Procedure]h1U`8abci PickRegisterRegister For Classes[Event Procedure]rytudents].[Student ID], [students].[First],ͬ\ΩP)Detaild Label0h SeeSchedh Backh PickRegisterDetai08=Babc,e gh|i|j"k@Е9vN@SectionsSectionK&[s Ariald2Blob m PropDataTV TypeInfo )DirDataSX    #$%&'()*+,-./0123456789:;<=>?@ABEFGHIJKLMNOPQRTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~e12f5g237hghMS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zijMS Sans Serif{5`FormHeader;(u_Label51m?Text52m@Text53fALine54fBLine55fCLine56DBalance DueEstudentIDFenrollments.sectionIDGspecial permissionHstop pointICatalog Courses.DeptJCatalog Courses.Course#KDescriptionmLText59dMLabel60FormFootermd Student_ID_LabelStudent ID Labelͬ ]ΩP)PageHeaderDetailPageFooterReportHeaderReportFooterGroupHeader0GroupFooter1mDeptdDept_LabelDept Labelm Course_Course#d CourPropDataCmdbars@L@LModulesv@L@LReportsh@L0#R0:<=Babc 0e ghgihj6kc$Z2۽@CountOfEnrollByCourse Query"Count Of Enroll By Dept and CourseArial8 0JhLexmark 3200 Series ColorFine` odXX  Lexmark 3200 Series ColorFineLPT1:LPT1: K&[ H/winspoolLexmark 3200 Series ColorFineLPT1:d278d eTimes New Romane24fg37jghm5CArialn=Arialo3AArialp4DeptCourse#` ReportHeaderd2`<a<bQcdLabel19"Count Of Enroll By Dept and Coursef2a<b$Line22` PageHeaderd`<a<b c, Dept LabelDept DetachedLabel Dept_Labeld`@ a<bHc, Course# LabelCourse# DetachedLabel Course__Labeld7`a<bc,CountOfstudentID LabelCountOfstudentID DetachedLabelCountOfstudentID_Labelf2b$Line23f2ab$Line24` GroupHeader0m 0<`<b cJi DeptDeptTimes New Roman`JDetailm`@ bHcCourse#Course#Course_m`bckCountOfstudentIDCountOfstudentID`8 GroupFooter1 m ` a<b$Text6݁="Summary for " & "'Dept' = " & " " & [Dept] & " (" & Count(*) & " " & IIf(Count(*) = 1, "detail record", "detail records") & ")"d` a,bcd Label7Sumd`X a,bcd Label8Avgd`Dabcd Label9Mind`X abcd Label10Maxd`Da,bcd Label11Percentm `abckSum Of CountOfstudentID=Sum([CountOfstudentID])Sum_Of_CountOfstudentIDm `8"a,b ckAvg Of CountOfstudentID=Avg([CountOfstudentID])Avg_Of_CountOfstudentIDm `PabckMin Of CountOfstudentID=Min([CountOfstudentID])Min_Of_CountOfstudentIDm `t"abckMax Of CountOfstudentID=Max([CountOfstudentID])Max_Of_CountOfstudentIDm `Pa,bckPercent Of CountOfstudentID==Sum([CountOfstudentID])/([CountOfstudentID Grand Total Sum])PercentPercent_Of_CountOfstudentID` PageFooterm ;<`<abc,i jText20=Now() Long DateTimes New Romanm ;<`abc,i jkText21$="Page " & [Page] & " of " & [Pages]Times New Roman`h ReportFooterm 5<`bc,i CountOfstudentID Grand Total Sum=Sum([CountOfstudentID])Times New Roman CountOfstudentID_Grand_Total_Sumd`<bGcd Label13 Grand Total08;804;708d5]`xa$ bcpickRoom_LabelpickRoom2NI8`0d Oo5U`bc(d fhn*"";"";"";"";"10";"30"nL/I "K:Combo18professorTable/QuerySELECT Professors.se__LabelCourse# Labelm CountOfstudentIDd CountOfstudentID_LabelCountOfstudentID Labelm Text6dLabel7dLabel8dLabel9dLabel10dLabel11mCountOfstudentID_Grand_Total_SumCountOfstudentID Grand Total SumdLabel13mSum_Of_CountOfstudentIDSum Of CountOfstudentIDmAvg_Of_CountOfstudentIDAvg Of CountOfstudentIDmMin_Of_CountOfstudentIDMin Of CountOfstudentIDmMax_K&[Of_CountOfstudentIDMax Of CountOfstudentIDmPercent_Of_CountOfstudentIDPercent Of CountOfstudentIDdLabel19mText20mText21fLine22fLine23fLine24belTitle DetachedLabel 0:<=Babc$e ghgihj6kc$'@ roster QueryrosterXArial8$JhLexmark 3200 Series ColorFine` odXX 2f@L@LBlob ScPropDataegTypeInfo> Lexmark 3200 Series ColorFineLPT1:LPT1: H/winspoolLexmark 3200 Series ColorFineLPT1:d278d eTimes New Romane24fg37jghm5CArialn=Arialo3AArialp4YearLastFirst` ReportHeaderd2`<a<bScdLabel14 Roster for:f2a<b$Line17o`bcpd,epf,"";"";"";"";"";"";"";"";"";"";"";"";"10";"5" sectionID sectionID Table/QueryߞSELECT DISTINCTROW [Sections].[sectionID], [Sections].[Dept], [Sections].[Course#], [Sections].[Section], [SectionsK&[].[Sem], [Sections].[Year] FROM [Sections];975;615;870;810;525;555` PageHeaderd`<a<b c, Year LabelYear DetachedLabel Year_Labeld` a<bc, Last LabelLast DetachedLabel Last_Labeld`La<bc, First LabelFirst DetachedLabel First_Labeld`8a<bc,Student ID Label Student ID DetachedLabelStudent_ID_Labeld`pa<bc, Middle LabelMiddle DetachedLabel Middle_Labeld`|a<bXc, Major LabelMajor DetachedLabel Major_Labelf2b$Line18f2ab$Line19` GroupHeader0m 0<`<b cJi YearYear&Student Academic Year (Fr, So, Jr, Sr)Times New Roman`JDetailm` bcLastLastStudent Last Namem`LbckFirstFirstStudent First Namem`8bck Student ID Student IDdStudent number - 4 digits - made text so leading zeroes dont go away - not doing math on them anyway Student_IDm`pbckMiddleMiddleStudent Middle Initialm`|bXckMajorMajor Student Major` PageFooterm ;<`<abc,i jText15=Now() Long DateTimes New Romanm ;<`abc,i jkText16$="Page " & [Page] & " of " & [Pages]Times New Roman` ReportFooterGPAGPAXStudent Current Gnt course grades - must be updated each seͬ\ΩP)PageHeaderDetailPageFooterReportHeaderReportFooterGroupHeader0mYeardYear_LabelYear LabelmLastd Last_LabelLast Labelm Firstd First_LabelFirst Labelo sectionIDmStudent_IDStudent IDdStudent_ID_LabelStudent ID LabelmMiddledMiddle_LabelMiddle LabelmMajordMajor_LabelMajor LabeldLabel14mText15mText16fLine17fLine18fLine190:<=Babc$e gG[@schedule QueryScheduleArial8 hLexmark 3200 Series ColorFine` odXX Root EntryZ_@VBA`L_VBAProject`L_VBA`L_ Lexmark 3200 Series ColorFineLPT1:LPT1: K&[ H/winspoolLexmark 3200 Series ColorFineLPT1:d278d eTimes New Romane24fg37jghm5CArialn=Arialo3AArialp4DeptCourse#` ReportHeaderd2`<a<b6cdLabel14Schedule` PageHeaderd`<a<b:c, Dept LabelDept DetachedLabel Dept_Labeld`a<bHc, Course# LabelCourse# DetachedLabel Course__Labeld`6a<b c, Title LabelTitle DetachedLabel Title_Labeld`xa<b c,sectionID Label sectionID DetachedLabelsectionID_Labeld`a<bc, time Labeltime DetachedLabel time_Labeld`a<bc, room Labelroom DetachedLabel room_Labeld`,a<bc,professor Label professor DetachedLabelprofessor_Labelf2`<ahb#Line17`Detailm`<a<b:cDeptDeptm`a<bHckCourse#Course#Course_m`6a<b ckTitleTitleo`bcxd<e fn "";"";"";"";"";"";"";"";"10";"4" sectionID sectionID Table/QueryySELECT DISTINCTROW [Sections].[sectionID], [Sections].[Dept], [Sections].[Course#], [Sections].[Section] FROM [Sections]; 0;615;870;810"SELECT DISTINCTROW [Sections].[sectionID], [Sections].[Dept], [Sections].[Course#], [Sections].[Section] FROM [Sections];";"Sections";"";"sectionID";"Dept";"PrimaryKey"m`a<bcktimetimem`a<bckroomroomm`,a<bck professor professor` PageFooterm ;<`<abc,i jText15=Now() Long DateTimes New Romanm ;<`abc,i jkText16$="Page " & [Page] & " of " & [Pages]Times New Romanf2`<ab$Line18` ReportFooterReportFooterGroupHeader0ͬ\ΩP)PageHeaderDetailPageFooterReportHeaderReportFootermDeptdDept_LabelDept LabelmCourse_Course#dCourse__LabelCourse# Labelm Titled Title_LabelTitle Labelo sectionIDd sectionID_LabelsectionID Labelm timedtime_Labeltime Labelmroomdroom_Labelroom Labelmprofessordprofessor_Labelprofessor LabeldLabel14mText15mText16fLine17fLine18rialS Sans Ser0:<=Babc 0e ͬ:=puLԴhKPageHeaderSectionDetailPageFooterSectionReportHeaderReportFooterGroupHeader0mStudent_IDStudent IDdStudent_ID_LabelStudent ID_LabelmFirstd First_Labelm Middled Middle_Labelm Lastd Last_Labelostudents_Yeardstude4n@L6LBlob L&PropDatamoTypeInfo08 :<=Babcwe g4d<$@fstudents and sections and courses join equiv to 1NF^K&[report leading to unnormalized students design3 Arial8 hLexmark 3200 Series ColorFine` odXX  Lexmark 3200 Series ColorFineLPT1:LPT1: H/winspoolLexmark 3200 Series ColorFineLPT1:d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4Student IDsectionID`ReportHeaderb_Ҟ^JRZ0d25`<a<bwcdLabel46^report leading to unnormalized students design3-kF+" 4f23a<bw Line49dDcx-A)̂^G`"PageHeaderSection\LܛLnd5`<a<bHc, Student ID_LabelStudent IDDetachedLabel Student_ID_LabelH~,/@R?!d5`a<bc,First_Label FirstDetachedLabeldHN-Ngzd5`a<bXc,Middle_Label MiddleDetachedLabelՄvCMo*02Vd5` a<bc,Last_LabelLastDetachedLabels TYGNjNd5` a<bpc,&students_Year_Labelstudents_YearDetachedLabel\LUdd5`a<b c,Major_Label MajorDetachedLabel楏6+E︁-d57`a<bc,0Num Credits Earned_LabelTotalCreditsDetachedLabel0Num_Credits_Earned_LabeldmͯMⰢd57`a<bpc,GPA_LabelGPADetachedLabel5nm2^68KAB>d5`p&a<bc,Hometown_LabelHometownDetachedLabel2ǯL4݆hd57`,a<bpc,"Balance Due_LabelBalance DueDetachedLabel"K&[Balance_Due_Label SfEӔ&d5`45a<b8c,sectionID_LabelSection IndexDetachedLabelPi)ˑK 7Cd5`9a<b8c,&Sections_Dept_LabelSections_DeptDetachedLabelJcTM~AWd5`>a<bdc,,Sections_Course#_Label Sections_Course#DetachedLabel,Sections_Course__Label4G(%d5`Ca<b c,Section_LabelSectionDetachedLabeldӅhJLjd5`Ga<b c,Sem_LabelSemDetachedLabel${jHZLSKd57`LJa<b8c,&Sections_Year_LabelSections_YearDetachedLabel$3@y|gd5`Na<bHc,time_LabeltimeDetachedLabelٓg<DцCdod5`DRa<bHc,room_LabelroomDetachedLabel^u\JQ[k6d5`Ua<bc,professor_LabelprofessorDetachedLabel2eE( 9d57`Ya<bc, stop point_LabelMax EnrollmentDetachedLabel stop_point_LabelK\vLmd5`^a<bc,Title_Label TitleDetachedLabel)%~C5~rƖd5`0fa<b c,"Description_LabelDescriptionDetachedLabelC=d57`@ta<buc,Credits_LabelCreditsDetachedLabeleB .L2j1if23bw Line50`a&L]iZwf23abw Line51˨DK27M=`GroupHeader06*ZVM m 7<`<bHcJeti Student IDStudent IDStudent number - 4 digits - made text so leading zeroes dont go away - not doing math on them anywayTimes New RomanStudent_ID)K#`gm 7<`bcJe*i k First First$Student First NameTimes New Roman1UA$5OL.m 7<`bXcJei k Middle Middle,Student Middle InitialTimes New Roman/RC m 7<` bcJei kLastLast"Student Last NameTimes New Roman0%=oA_zo 05:bc epfJh l n1=vgMZstudents_Yearstudents_YearValue List4"Fr";"So";"Jr";"Sr";"Grad"1440LStudent Academic Year (Fr, So, Jr, Sr)Times New Romanm 7<`b cJei k Major MajorStudent MajorTimes New Roman'tҳOXU Hm 07<`bcJei k$Num Credits Earned$Num Credits EarnedPStudent Number of Credits Earned to DateTimes New Roman$Num_Credits_Earned*|<@Mm 07<`bpcJevi kGPAGPA߰Student Current GPA (derived from student course grades - must be updated each semester)Times New Roman;DUCȂ$k,m 7<`p&bcJe i kHometownHometowntStudent Hometown (in reality would have whole address too)Times New Roman E\;v0Bm 7<`,bpcJeUi k Balance DueBalance Due*$#,##0.00;($#,##0.00)XAmount Student Currently owes the universityTK&[imes New RomanBalance_Due@_U ~EΦ`J Detail”#J  m`45b8cesectionIDsectionIDT"xN)#Rm`9b8cefkSections_DeptSections_Dept s D炳m`>bdcek Sections_Course# Sections_Course# Sections_Course_򀎆SMcl&lMpm`Cb cekSectionSection `r%A#=3m`Gb ceIkSemSemF S Su semester~NJ$OW)-m0`LJb8ce:kSections_YearSections_YearFyear offered - use 4 digit notationPIzF Q]؂m`NbHceVktimetime _Ctom`DRbHcekroomroomC=|Gm`Ubcekprofessorprofessor*BHs5m0`YbceIk stop pointstop pointstop_pointzNI7m`^bcek Title TitleLʯC,JJP+m`0fb ce k DescriptionDescriptionuíKNSm0`@tbuce*k CreditsCreditsYsOKVKu}`"PageFooterSectionERJܸm 7;<`<abc,i j Text47 =Now()Long DateTimes New RomankqbFm 7;<`dabc,i jk Text48H="Page " & [Page] & " of " & [Pages]Times New RomanKP hC2`ReportFooterR7)GAXtudent ID LabelmMiddledMiddle_LabelMiddle LabelmMajordMajor_LabelMajor LabeldLabel14mText15mText16fLine17fLine18fLine190:<=Babc$e gG[@schedule QueryScheduleArial8 hLexmark 3200 Series ColorFine` odXXnts_Year_LabelmMajordMajor_LabelmNum_Credits_EarnedNum Credits EarneddNum_Credits_Earned_LabelNum Credits Earned_LabelmGPAdGPA_LabelmHometowndHometown_LabelmBalance_DueBalance DuedBalance_Due_LabelBalance Due_LabelmsectionIDdsectionID_LabelmSections_DeptdSections_Dept_LabelmSections_Course_Sections_Course#dSections_Course__LabelSections_Course#_Labelm Sectiond!Section_Labelm"Semd#Sem_Labelm$Sections_Yeard%Sections_Year_Labelm&timed'time_Labelm(roomd)room_Labelm*professord+professor_Labelm,stop_pointstop pointd-stop_point_Labelstop point_Labelm.Titled/Title_Labelm0Descriptiond1Description_Labelm2Creditsd3Credits_Labeld4Label46m5Text47m6Text48f7Line49f8Line50f9Line51  ͬ>`oClƙReportHeaderdLabel50fLine53PageHeaderSectiondStudent_ID_LabelStudent ID_LabeldFirst_LabeldMiddle_LabeldLast_Labeldstudents_Year_Labeld Major_Labeld Num_Credits_Earned_LabelNum Credits Earned_Labeld GPA_Labeld Hometown_Labeld BalancFHDK&[v2345678OPQRSTUVW^`btachdefgikjlpmnoqsruzvwxy{|}~08 :<=Babcixe g8b$@fstudents and sections and courses join equiv to 1NF^report leading to unnormalized students design2 Arial8ixJhLexmark 3200 Series ColorFine` odXX  Lexmark 3200 Series ColorFineLPT1:LPT1: L/winspoolLexmark 3200 Series ColorFineLPT1:d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4Student IDsectionID`ReportHeader<}>pKJd2`<a<bwcdLabel50^report leading to unnormalized students design2YRm]BN}\f2a<bix Line538Av`D`"PageHeaderSectionPH0cN7d`<a<b c, Student ID_LabelStudent IDDetachedLabel Student_ID_LabelU@;H#v!d`a<bHc,First_Label FirstDetachedLabeln,oKA9G/d`a<bc,Middle_Label MiddleDetachedLabel"A- vd K&[`` a<bHc,Last_LabelLastDetachedLabelr(%IW]m1Yd` a<bc,&students_Year_Labelstudents_YearDetachedLabel[f"%LUZd`a<bc,Major_Label MajorDetachedLabelGCd,? d7`pa<bc,0Num Credits Earned_LabelTotalCreditsDetachedLabel0Num_Credits_Earned_Label)y(O4#8d7`0a<bc,GPA_LabelGPADetachedLabelm`B6J`D>ޙd`"a<b(c,Hometown_LabelHometownDetachedLabelϵUEzˉ}d7`P(a<bc,"Balance Due_LabelBalance DueDetachedLabel"Balance_Due_Label89AGRQd` 0a<bc,sectionID_LabelSection IndexDetachedLabel]0AiT!d`4a<bc,&Sections_Dept_LabelSections_DeptDetachedLabelLJI3Ld`8a<bc,,Sections_Course#_Label Sections_Course#DetachedLabel,Sections_Course__Labels]Ay QB]''4m` 0bcsectionIDsectionID Cgrjpm`4bckSections_DeptSections_Dept|P>qKqwm`8bck Sections_Course# Sections_Course# Sections_Course_jn.^G^%m`?A E J$3NSPQRTWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~cdefghijklnopstuvy{|}~tudentsWenrollForm_studentsWenrollZVB_Name = "Form_main" " Bas0{A9CE5C84-9C1B-10=Babe ghXiJjq%kNr@Ariald2hgh MS Sans Serif`@ Detaild5U`ab cdLabel0Administrativeh1U`abVc NewCourse New CourseCourses.newCourseh1U`l abciBackMain Back To Main BackToMainCmd.0Open}, AstI$ExiztN*:; rUResu@RC EndCXPickXA)GPWτBlob yPropData 1w{6L6LBlob | 22close current form -10open the main menumain0-10fg37jghrialn= Arialo3A Arialp422 =MOQSnewCourseopen in add mode so cannot update existing recordsCatalog Courses000 02go to position for new record2Catalog Courses5 PropData# 2~6L6LBlob $CPropData#K&[* %*place cursor on dept field (control)Dept_Year_Labelstudents_YearDetacel[f"%LUZd`a<bc,Major_22 /:place current position on student id attributeStudent ID )+-/147find in db the right student=[FindStud]1020-1-1  )put cursor back on my combo boxFindStudDetached3}6L6LBlob +.PropData0 DirData1\kT  PROJECTbPropData30PropData4Databases6L6L06L6LBlob DirData5CustomGroups6L6LDataAccessPages 6L6L9@hRЩRBlob VFTypeInfo]KPropData\, 8, Ver70 6 Exit%:6)2T MsgBox7.Descri ptionCRe{ }Y Grad"NRR  Y  Y  Y  Y Prog ClassPreProgPreClasspoCRTtsRvRwYYY8Catalog CoursesPrerequisites:Catalog CoursesPrerequisites1PrimaryKeyv1@ QnK(yT1@ @ @ @ @ @ @ @ @           !"#$%&' (!)"*#+$,%&'()*+,-. / 0 1 2 3456789:;<=>?@AB& MTH222MTH221 MTH221MTH120 MGMT303MGMT302 ENG108ENG107 CSC481CSC480 CSC464CSC354 CSC354CSC290 CSC280CSC230 CSC240CSC280 CSC290CSC280 CHEM302CHEM301 CHEM202CHEM201 CHEM112CHEM111 BIO162BIO161  Q@@@@LYd8B:LYd8B8SMWQ`88:MWQ`888SMWQ`:6:MWQ`:68SMWQ`<6:MWQ`<68SMkM:F6MkM:<6SMkM:H6MkM:F6SMkM<@>MkM:H6SMkM>B>MkM<@>SMkM>F8MkM>F6S QbU86FQbU86DS `U`m<6<`U`m<6:S `mW::8`mW8:6S `mW:::`mW::8S `mW:::`mW::8S YYIdParentIdName        s Y@NNVV66666 Y o Y o Y s Y 2 Y  Y NNameDeptPosition office phone emailNNNVXNNNNVYNNNNVZNYaYYY.rDDeptNamePrimaryKeyv1,U@BNT dM( p /L w ?  J J O IVGi+Fk.zAEH SB^#rA2A  @YoungCSCAdj AsstO 2342314jyoung-% ?WileyCSCAssocO 1331234wiley)" ?VenkatesanCSAsstbs3206122venkates/%?TurkCSAsstO 2301098jturk& ?TavanaMGMTAssocC 3144519tavana,$ ?SzabatMKTGAssocC 2318923szabat,$ ?SudeENGAdj AsstO 1088765sude*$ ?StullSOCAssocO 2359567jstull*" ?StevensCSInstructorbs3246439elsteven2(" ?SovenENGProfO 1252987soven(! ?Smith AMMISAsstC 2314592amsmith-$ ?SheehyHISAssocO 2122910broed*# ?ShalhoubCHEMAssocH 2135637shalhoub0&  ?RobisonECNAssocO 2289345robison-$ ?RhodaMGMTAssocC 2132314rhoda*# ?ReichardtCSCAdj AsstO 2342314reichard3)# ?RedmondCSCAssocO 3301096redmond-$ ?RatkusRELAssocW 1242345ratkus+# ?PaulinECNAsstO 1093245paulin*" ?PalisCSAssocbs3236077palis(! ?NguyenSOCAssocO 3126678nguyen+# ?MshombaECNProfO 2198538mshomba,# ?MoreauPHLProfW 1249238moreau*" ?MillardENGProfO 1231234millard,# ?MichalekMTHAssocO 3399192michalek/% ?MeadCSInstructorbs1256102mead+% ?McConnellMTHAdj AsstO 1316565mcconnel3)# ?McCartyMTHAssocO 1389128mccarty-$ ?Mc ManusCSCProfA 3171000mcmanus-$ ?Mc CoeyCSCAsstO 1361919mccoey+# ?aCSVis Assocbs3196439evama)" ?LongoCSCProfH 1291010longo(! ?LeisterCSDAsstO 1368745leister,# ?LeibigerHISAsstO 3323214leibiger.$ ?LeaubyMGMTAssocC 2223452leauby,$ ?KolasaCSInstructorbs1206052kolasa/'! ?KnappenbergerMTHAsstO 1351095knappenb3)#?KirschCSCAssocO 2374321kirsch+# ?Kelly GRELAssocW 1232312gkelly,$ ?Jones NCHEMAssocH 3136728njones-% ?Jones DMKTGAsstC 2217612jones+$ ?JoglekarMGMTAssocC 2179767praf,&  ?GrantCSInstructorbs3246439kgrant.&  ?FalconePSYAssocH1088765falcone,# ?FairHISAssocO 2162911fair'! ?ElliottCSCAsstO 1261130elliott,# ?DiDioMTHAssocO 2348745didio)" ?DesnoyersHISAssocO 2142912desnoyer0&  ?DasguptaCSVis Asstbs3216439bhaskar0'! ?CollinsPSYAssocH 1047623collins-$ ?CamomileCSDAsstO 1342134camomill.$ ?ButlerENGProfO 1293245butler*" ?Burke JPSYProfH 1051245jburke+# ?BurkeCHEMProf Isc3256032burke+$ ?BruceMGMTProfC 2139099gbruce*" ?BroganPOLAsstO 1145637brogan*" ?BrazinaACCTProfC 2129191brazina-$ ?BlumCSCAsstO 3381111blum&  ?GreenCSAdj AsstO 996439jgreen+# ?BeattyENGAsstO 1239192beatty*" ?BalloughBIOAssocH 2012122ballough/% ?BalchunisPOLAsstO 1129384balch,% ?ArmstrongPSYAssocH 1061212armstron0&  ?AndrilliMTHAssocO 1379101andrilli/% ? U @@@@@@@@@ @@    JMMmWLYdWMWQ`W MWQ`WMWQ`W3MkMWMkMWMkMWMkMWMkMWMkMWMkMWMkMW MkMW!MkMW"MkMW#MkMW&MkMW,MkMW/MkMW0MkMW7MkMW<MkMW=MkMW>MkMW?MkOW MkOWQMbW*QMbW-QMbW2QbUWQbUW QbUW(QbUW6QbUW9WYkWWYkWWYkWWYkW4`U`mW `U`mW`U`mW`U`mW1`U`mW;`YkW5`\mUW`\mUW:`mWW`mWW`mWW`mWW$`mWW%`mWW'fW^W)fd^Wfd^WfkvWfkvW fkvWfkvWiQ^WiQ^W.kdMW+kdMW8 U@@   @ @@@   @@JbOiY^^YWJi`kmidbUWLJ^MWobYkWLJ^^doUWWLQJmmvWL^o`WLiJxYbJWLidUJbWLioMQW Loi\Q[W Lom^QiW MJ`d`Y^QW MJmJbYdW=Md^^YbkWOQkbdvQikWOYOYdWQ^^YdmmWSJYiWSJ^JW7SJ^MdbQWSYkWQiWUiQQbWWYUW^QvW,[dU^Q\JiW[dbQkOW[dbQkbW\Q^^vUW\YikMWW\bJffQbLQiUQiW^QJoLvW^QYLYUQiW^QYkmQiW^dbUdW `MMdQvW"`M`JbokW#`MMJimvW$`MMdbbQ^^W%`YMWJ^Q\W'`Y^^JiOW(`diQJoW)`kWd`LJW*bUovQbW+fJkhoJ^QWfJo^YbW-fiokWJbW iJm\okW.iQO`dbOW/iQYMWJiOmW0iWdOJW1idLYkdbW2kWJ^WdoLW3kWQQWvW4kY`dbW&k`YmWJ`W5kdqQbW6kmdbQkYSQiWkmo^^W8koOQW9kxJLJmW:mJqJbJW;moi\W<sJMQvW!sY^QvW>vdobUW?W?W? U@@   @ @@@   @@JbOiY^^YWJi`kmidbUWLJ^MWobYkWLJ^^doUWWLQJmmvWL^o`WLiJxYbJWLidUJbWLioMQW Loi\Q[W Lom^QiW MJ`d`Y^QW MJmJbYdW=Md^^YbkWOQkbdvQikWOYOYdWQ^^YdmmWSJYiWSJ^JW7SJ^MdbQWSYkWQiWUiQQbWWYUW^QvW,[dU^Q\JiW[dbQkOW[dbQkbW\Q^^vUW\YikMWW\bJffQbLQiUQiW^QJoLvW^QYLYUQiW^QYkmQiW^dbUdW `MMdQvW"`M`JbokW#`MMJimvW$`MMdbbQ^^W%`YMWJ^Q\W'`Y^^JiOW(`diQJoW)`kWd`LJW*bUovQbW+fJkhoJ^QWfJo^YbW-fiokWJbW iJm\okW.iQO`dbOW/iQYMWJiOmW0iWdOJW1idLYkdbW2kWJ^WdoLW3kWQQWvW4kY`dbW&k`YmWJ`W5kdqQbW6kmdbQkYSQiWkmo^^W8koOQW9kxJLJmW:mJqJbJW;moi\W<sJMQvW!sY^QvW>vdobUW?W?W?V Y< N\\4444 Y Y Y Y Y Y Y roomsizeFront ComputerData ConnectionData ProjectorOverhead2Numb Student WorkstationsOO\^OOO\_OYaYY.rCPrimaryKeyroomv1@  [<pX@(hP8  x ` H 0  p X @ (  h P 8  x `   @@    @@ JO`YbmJk\kMJmJ^dUMdoikQkOQJbkmJk\kQbid^^`QbmkkoLSdi`Qbid^^`QbmkkoLSdi`8Qbid^^`QbmkkoLSdi`:QbmQibQsMdoikQ SJMo^mvmJk\k`JYbidd`kkQMmYdbkkmoOQbmkkmoOQbmk8kmoOQbmksQbid^^kmoOQbmmJk\kJ^^Qbid^^`Qbmk MdobmdSQbid^^LvOQfmJbOMdoikQ!iQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb:"iQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb<#idkmQiu$kMWQOo^Q%JomdQuQM&LJM\md`JYb'MdoikQk(SYbOkmO)JO`Yb*OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MQbid^^`QbmkkoLSdi`+kh+MMd`LdB++kh+MQbid^^`QbmkkoLSdi`8+kh+MkQMmYdbYO,+kh+MQbid^^`QbmkkoLSdi`:+kh+MkQMmYdbYO+kh+MkQMmYdbk+kh+MMd`Ld8B+kh+MkQMmYdbk+kh+MMd`Ld8F+kh+MkmoOQbmk+kh+MQbid^^`QbmkkoLSdi`8+kh+MkmoOQbmk+kh+MSYbOJkmoO+kh+MkmoOQbmk+kh+MSYbOkmoO+kh+MkmoOQbmk8+kh+MQbid^^`QbmkkoLSdi`:+kh+MkmoOQbmk8+kh+MSYbOkmoO+kh+MkmoOQbmksQbid^^+kh+MQbid^^`QbmkkoLSdi`+kh+OidkmQiu+kh+OkQMmYdbYO +kh+OkMWQOo^Q+kh+OkQMmYdbYO +kh+SMJmJ^dUMdoikQk +kh+SQbid^^`QbmkkoLSdi` +kh+SQbid^^`QbmkkoLSdi`8 +kh+SQbid^^`QbmkkoLSdi`:+kh+SQbmQibQsMdoikQ +kh+Sidd`k+kh+SkQMmYdbk+kh+SkmoOQbmk+kh+SkmoOQbmk8+kh+SkmoOQbmksQbid^^MJmJ^dUMdoikQkMdobmdSQbid^^LvMdoikQhoQivQbid^^`QbmkQbid^^`QbmkhoQivQbid^^`QbmkhoQiv8[dYbkmoOQbmkQbid^^QOkQMmYdbkM^JkkQk[dYbmQbid^^`QbmkhoQiv:[ob\MiQJmQkd`QkQMmYdbkJ[ob\MiQJmQkd`QkQMmYdbkmQkm[ob\Qbid^^`Qbmkbdm:66:hoQ#O 329 CO 327 CO 325 CO 323 CO 321 CO 319 CO 317 C#O 315 CO 313 CO 311 C#O 309 CO 307 CO 305 CO 303 CO 301 CO 229 CO 227 CO 225 CO 223 CO 221 CO 219 CO 217 CO 215 C#O 213 CO 211 KO 209 K#O 207 C#O 205 C#O 203 CO 201 O 200 O 129 O 127 O 123 CO 121 CO 119 KO 117 CO 115 KO 113 KO 111 CO 109 KO 107 CdO 100 H 103 CH 102 CH 101 (O 231 C#O 105 C#O 103 CC 206 C 205 2C 204 C 203 C 202 C 201 2H 141 cO 125 2W 99 o(W 101 C(W 95 R [@M:68]M:6:]M:6<]M:6>]M:6@] M:6B] W868]W86:]W86<]W8>8]d866]d86<] d86@] d86D]d86H]d888]d88<]d88@]d88D]d88H]d8:8]d8:<]d8:@]d8:D]d8:H]d:66]d:68]d:6<]d:6@] d:6D]!d:6H]"d:88]#d:8<]$d:8@]%d:8D]&d:8H]'d::8](d::<])d::@]*d::D]+d::H],d:<8] d<68]-d<6<].d<6@]/d<6D]0d<6H]1d<88]2d<8<]3d<8@]4d<8D]5d<8H]6d<:8]7d<:<]8d<:@]9d<:D]:d<:H];s868]sH@]sHH];R [@M:68]M:6:]M:6<]M:6>]M:6@] M:6B] W868]W86:]W86<]W8>8]d866]d86<] d86@] d86D]d86H]d888]d88<]d88@]d88D]d88H]d8:8]d8:<]d8:@]d8:D]d8:H]d:66]d:68]d:6<]d:6@] d:6D]!d:6H]"d:88]#d:8<]$d:8@]%d:8D]&d:8H]'d::8](d::<])d::@]*d::D]+d::H],d:<8] d<68]-d<6<].d<6@]/d<6D]0d<6H]1d<88]2d<8<]3d<8@]4d<8D]5d<8H]6d<:8]7d<:<]8d<:@]9d<:D]:d<:H];s868]sH@]sHH];K#O ME s  ˵ P 󉜉ψSӅ$yEւAo AEXN@0fN@junk enrollments not 2as#q@s#q@Catalog CoursesSections2PPPPPPPPPPN `m@m@ProfessorsSections2FFFFFFFFFFD ]l@l@RoomsSections2<<<<<<<<<<: [B@B@Relationships for UNIV2000new2\\\\\\\\\\Z AEXN@0fN@junk enrollments not 2002 Query2@@xll```````^ @<_O[@_O[@enrollments Query12Z@|RRRFFFFFFFD @8k;@k;@~sq_fstudents124MR2KeepLocal T~~~>>>>>>>< @6wtvN@wtvN@~sq_fSections24MR2KeepLocal T|||<<<<<<<: @4@@~sq_fEnter New Course:24MR2KeepLocal TNNNNNNNL @1 A@ A@~sq_fenrollments Subform24MR2KeepLocal TRRRRRRRP @.@@~sq_drosterX~sq_dsectionID24MR2KeepLocal TVVVVVVVT @+~.vN@~.vN@~sq_cstudents1~sq_cenrollments Subform224MR2KeepLocal Tpppppppn @(z@z@~sq_cstudents~sq_cenrollments Subform124MR2KeepLocal Tnnnnnnnl @&tvN@8tvN@~sq_cSections~sq_cCombo1624MR2KeepLocal TTTTTTTTR @$gg @gg @~sq_cenrollments Subform1~sq_cSectionID24MR2KeepLocal Tpppppppn @ݿ@T@MSysDb2"@:::......., @^@^@DataAccessPages2@@@@@@@@@@> R19R@19R@studentsenrollments2HHHHHHHHHHF Q' QN@' QN@Sectionsenrollments2HHHHHHHHHHF MQlĵ@Qlĵ@Catalog CoursesPrerequisites12\\\\\\\\\\Z Lb@b@Catalog CoursesPrerequisites2ZZZZZZZZZZX K4q[@4q[@students Query32Z@ LLL@@@@@@@> @JFqo[@ǻro[@students Query22Z@ LLL@@@@@@@> @I MK[@ MK[@students Query12Z@ LLL@@@@@@@> @HC[@{9C[@students Query Query2Z@VVVJJJJJJJH @FB'\$@N$@students and sections and courses join equiv to 1NF2 *IC@@ `m`@zNtN@students2 @>>>22222220 @E9u$@I$@Sections and courses join Query - equiv to 2NF2.L@@@~ `aI '@WXr@Sections2 @>>>22222220 @ jYKN  bb@; Y  Y  Y  Y s Y sY  Y  Y  Y Y  Y  sectionIDDeptCourse#SectionSemYeartimeroomprofessorstop pointjunkYbgr.ubhDeyybiKKKbjKKKbkKKK bKKK bKYYYYYUYY[YY.rI.Catalog CoursesSectionsDeptPrimaryKey$ProfessorsSectionsroomRoomsSectionssectionIDtimeC*pln@ 'C*plstudentsenrollmentsZ@C7! C*plstudents.Major- gC*plstudents.Year, gC*plstudents.Last, gC*plstudents.Middle. gC*plstudents.First- gC*plstudents.[Student ID]4 gC*plenrollments.sectionID4 gC*plenrollments''' C*plstudents!!! C*pl GC*pl GC*pl C*plstudents.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept(((enrollments.sectionID)=[Enter Course Index Number]))students.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID((([Catalog Courses].Dept)="BIO") AND ((Professors.Dept)="BIO"))((([Catalog Courses].Dept)="BUS") AND ((Professors.Dept)="MKTG"))[Sections].[sectionID] =[enrollments].[sectionID][students].[Student ID] =[enrollments].[studentID][Catalog Courses].[Course#] =[Sections].[Course#][Catalog Courses].[Dept] =[Sections].[Dept][enrollments].[special permission](((Sections.Sem)="S") AND ((Sections.Year)=1997))Sections.sectionID = enrollments.sectionID[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept(((Professors.Dept)=[Forms]![Sections]![Dept]))[Rooms].[Numb Student Workstations](((DCN@оN@schedule Query<<<<<<<<<<< o v1b ] $ r T 6  I y ;  P  gI+ L ]$pR4`,`oo @ @ @ @ D*plstudentsenrollmentsZ@C7! D*plSectionsenrollmentsT@C7! D*plCatalog CoursesSections`@K?/ D*plCatalog CoursesSectionsL@K?/ D*plSections.professor1 gD*plSections.room, gD*plSections.time, gD*plenrollments.sectionID4 gD*pl[Catalog Courses].Title6 gD*pl[Catalog Courses].[Course#]: gD*pl[Catalog Courses].Dept5 gD*plenrollments''' D*plstudents!!! D*plSections!!! D*plCatalog Courses/// D*pl GD*pl GD*pl D*pl GC*pln@ 'C*plstudentsenrollmentsZ@C7! C*plstudents.Major- gC*plstudents.Year, gC*plstudents.Last, gC*plstudents.Middle. gC*plstudents.First- gC*plstudents.[Student ID]4 gC*plenrollments.sectionID4 gC*plenrollments''' C*plstudents!!! C*pl GC*pl GC*pl C*pl GB U Sections.professor1 gB USections.room, gB USections.time, gB USections.Year, gB USections.Sem+ gB USections.Section/ gB USections.[Course#]1 gB USections.Dept, gB USections.sectionID1 gBUMax Of stop pointMax(Sections.[stop point])[33 oBUMin Of stop pointMin(Sections.[stop point])[33 oBUAvg Of stop pointAvg(Sections.[stop point])[33 oBUSections.Dept, gBUSections!!! BU GBU GBU BU GAU(((Sections.Year)<2002))7 'AUSectionsenrollmentsT@C7! AUSections.Ye @x a2[ l 6 I U  k  3 CXr&5BR^ p!@ _80418MGMT35401FTR9C 206Joglekar:0)$"  ]80417MGMT30202FMWF10C 203Joglekar<2+$"  \80416MGMT35302FMWF11C 202Bruce92+$"  [80415MGMT35301FMWF9C 203Bruce81*$"  Y80414MGMT30201FMWF2C 202Bruce81*$"  W80413CHEM30102FMWF12O 123Shalhoub<2+$"  U80412CHEM20102FMWF11O 325Shalhoub<2+$"  S80411CHEM15002FTR2O 113Shalhoub:0)$"  R80410CHEM11102FMWF10O 217Shalhoub<2+$"  P80409CHEM30101FMWF11O 113Jones N;2+$"  N80408CHEM20101FMWF9O 325Jones N:1*$"  L80407CHEM15001FTR9O 113Jones N90)$"  K80406CHEM11101FMWF10O 113Jones N;2+$"  B80405BIO21001FMWF12O 123Ballough;1*#!  ?80404BIO16101FMWF11O 113Ballough;1*#!  >80403BIO18001FMWF9O 325Ballough:0)#!  +80402BIO15701FMWF10O 217Ballough;1*#!  !80371CSC48001FMW3:30O 201Kirsch:2+#!   80361CSC37201FMW2O 200Wiley6/(#!  80351CSC32001FMWF11O 109Kirsch91*#!  80341CSC35401FMWF11O 113Turk71*#!  80331CSC31001FT6O 200Turk4.'#!  80323CSC24003FR6O 201Reichardt9.'#!  80322CSC24002FMWF10O 215Redmond:1*#!  80321CSC24001FMWF9O 109Blum60)#!  80311CSC29001FMWF12R2O 217Turk93,#!  80301CSC28001FMWF11R11O 219Elliott=4-#!  80202CSC15201FMWF12H 101DiDio81*#!  80201CSC15201FMWF11H 101DiDio81*#!  80105CSC15105FMWF12O 200Young81*#!  80104CSC15104FMWF11O 200Young81*#!  80103CSC15103FMWF10O 200Young81*#!  80102CSC15102FMWF9O 127Wiley70)#!  80101CSC15101FMWF8O 200Wiley70)#!  70238CSIT46140Smw420W 99Redmond:1+$"  #70234CSIT15440Stt740W 95Pasquale;1+$"  #70232CSIT15401Stt1230W 101Catanio<3,$"  # 69705CSIT32101Smw120O 231Redmond;2+$"   67488CSIT44740Smw610O 105Wacey92+$"  # 66422CSC23040Smw610O 231Pasquale;1*#!  # 66419CSC15240Stt610W 95Green70*#!  # 66418CSC15141Smw730O 125Fisher91*#!  #66417CSC15140Smw610W 95Simon70*#!  #66416CSC15102Stt200H 141Fala71*#!  #66415CSC15101Smw120H 141Fala71*#!  c62341CHEM11101Smw900W 95Prushan:1+$"  62272CSC15101Fmw610O 125Fisher91*#!  11121CSC29001FMWF 1230O 107Turk:4-#!  11112CSC28002FMWF 1130O 107Redmond=4-#!  11111CSC28001FMWF 930O 111Redmond<3,#!  a2] o! 3 B S  d  x + ?Ocx)<Qk *~ 80468MTH22101FMWF12O 107Knappenberger@1*#!  80467MTH12002FMWF11O 107Knappenberger@1*#!  80466MTH12001FMWF10O 107Knappenberger@1*#!  80465MTH11401FMWF9O 107Knappenberger?0)#!  80464ENG10708FTR9O 113Sude5/(#!  80463ENG10707FTR2O 113Sude5/(#!  80462ENG10706FMWF9O 113Sude60)#!  80461ENG20303FMWF12O 217Soven81*#!  80460ENG20302FTR2O 113Soven6/(#!  80459ENG10705FMWF9O 217Soven70)#!  80458ENG10704FMWF10O 113Soven81*#!  80457ENG15005FMWF12O 113Millard:1*#!  80456ENG15004FMWF11O 123Millard:1*#!  80455ENG10802FMWF9O 217Millard90)#!  80454ENG10703FTR9O 217Millard8/(#!  80453ENG15003FMWF10O 113Butler91*#!  80452ENG15002FMWF9O 325Butler80)#!  80451ENG10702FMWF2O 325Butler80)#!  80450ENG20301FMWF11O 113Beatty91*#!  80449ENG15001FMWF12O 123Beatty91*#!  80448ENG10801FMWF9O 217Beatty80)#!  80447ENG10701FMWF10O 217Beatty91*#!  80446ECN20102FMWF9O 113Robison90)#!  80445ECN20101FTR3:30O 113Robison;2+#!  ~80444ECN15502FMWF11O 325Robison:1*#!  }80443ECN15501FMWF10O 217Robison:1*#!  |80442ECN21304FMWF9O 113Paulin80)#!  {80441ECN21303FMWF2O 113Paulin80)#!  z80440ECN21302FTR2O 113Paulin7/(#!  y80439ECN15004FMWF11O 113Paulin91*#!  x80438ECN21301FMWF9O 217Mshomba90)#!  w80437ECN15003FTR2O 325Mshomba8/(#!  v80436ECN15002FMWF10O 325Mshomba:1*#!  u80435ECN15001FMWF11O 113Mshomba:1*#!  t80434MKTG30401FMWF9C 203Szabat91*$"  s80433MKTG30104FMWF10C 202Szabat:2+$"  q80432MKTG30103FTR9C 206Szabat80)$"  p80431MKTG30501FMWF10C 203Jones D;2+$"  o80430MKTG30102FMWF9C 202Jones D:1*$"  m80429MKTG30101FMWF12C 206Jones D;2+$"  l80428MGMT30209FMWF10C 203Tavana:2+$"  k80427MGMT30208FMWF11C 202Tavana:2+$"  i80426MGMT30207FMWF9C 202Tavana91*$"  h80425MGMT35403FMWF10C 203Rhoda92+$"  g80424MGMT35303FMWF2C 203Rhoda81*$"  e80423MGMT30206FMWF12C 203Rhoda92+$"  d80422MGMT30205FMWF9C 202Leauby91*$"  c80421MGMT30204FMWF11C 206Leauby:2+$"  a80420MGMT30203FMWF10C 203Leauby:2+$"  `80419MGMT35402FTR3:30C 202Joglekar=3,$" a2_o! 4 @ M `  s $ 4G^r&@M\ hz 80518BUS10102FMWF11O 113Brazina:1*#!  80517BUS10101FMWF9C 203Brazina90)#!  80516POL15102FMWF11O 113Brogan91*#!  80515POL15101FMWF12O 325Balchunis<1*#!  80514HIS32402FMWF10O 113Leibiger;1*#!  80513HIS25104FMWF11O 113Leibiger;1*#!  80512HIS15106FMWF9O 113Leibiger:0)#!  80511HIS15105FTR9O 113Leibiger9/(#!  80510HIS32401FMWF12O 217Desnoyers<1*#!  80509HIS25103FMWF10O 113Desnoyers<1*#!  80508HIS25102FMWF9O 113Desnoyers;0)#!  80507HIS25101FTR2O 113Desnoyers:/(#!  80506HIS33301FMWF11O 123Fair71*#!  80505HIS32901FMWF10O 217Fair71*#!  80504HIS15104FMWF9O 325Fair60)#!  80503HIS15103FMWF2O 113Fair60)#!  80502HIS30502FMWF10O 113Sheehy91*#!  80501HIS30501FMWF11O 113Sheehy91*#!  80500HIS15102FMWF9O 325Sheehy80)#!  80499HIS15101FTR9O 113Sheehy7/(#!  80498SOC15002FMWF10O 113Stull81*#!  80497SOC15001FMWF9O 217Nguyen80)#!  80496REL15302FMWF12O 113Ratkus91*#!  80495REL15002FMWF10O 113Ratkus91*#!  80494REL15301FMWF9O 113Kelly G90)#!  80493REL15001FMWF11O 113Kelly G:1*#!  80492PSY15502FMWF10O 325Falcone:1*#!  80491PSY15503FMWF12O 113Collins:1*#!  80490PSY15501FMWF9O 217Burke J90)#!  80489PSY15501FMWF10O 113Armstrong<1*#!  80488PHL15201FMWF9O 113Moreau80)#!  80487PHL15101FTR2O 217Moreau7/(#!  80486MTH22201FMWF10O 113McCarty:1*#!  80485MTH16003FMWF9O 113McCarty90)#!  80484MTH11307FTR9O 113McCarty8/(#!  80483MTH24002FMWF12O 111Michalek;1*#!  80482MTH16002FMWF11O 111Michalek;1*#!  80481MTH12006FMWF10O 217Michalek;1*#!  80480MTH11306FMWF9O 113Michalek:0)#!  80479MTH11305FMWF11O 123McConnell<1*#!  80478MTH11304FMWF10O 111McConnell<1*#!  80477MTH11303FMWF9O 111McConnell;0)#!  80476MTH11302FTR9O 111McConnell:/(#!  80475MTH22102FTR9O 113DiDio6/(#!  80474MTH16001FMWF11O 123DiDio81*#!  80473MTH12005FMWF9O 217DiDio70)#!  80472MTH24001FTR3:30O 109Andrilli<2+#!  80471MTH12004FMWF11O 109Andrilli;1*#!  80470MTH12003FMWF10O 109Andrilli;1*#!  80469MTH11301FMWF9O 109Andrilli:0)#!  abu# 1 J *82111CSD34001FM6O 129Camomile8.'#!  )82102CSD21002FMW3:30O 129Leister;2+#!  (82101CSD21001FMWF9O 129Leister90)#!  '81212CSIT42202FM6H 102Longo6/($"  &81211CSIT42201FT2H 102Longo6/($"  %81201CSIT22001FMWF12O 107Kirsch:2+$"  $81103CSIT15403FMW2O 127Reichardt;0)$"  #81102CSIT15402FTR2O 127Reichardt;0)$"  "81101CSIT15401FTR11O 127Reichardt<1*$"  80523BUS20003FMWF10C 203Brazina:1*#!  80522BUS20002FMWF11O 113Szabat91*#!  80521BUS15002FMWF9C 203Szabat80)#!  80520BUS15001FMWF12O 113Szabat91*#!  80519BUS20001FMWF9C 203Jones D90)#! a@@@ @        @ @@@@@@@@@@@@ @ @ @         LYdc!LYdc"LYdc#LYdc$Loke0Loke1LokfLokfLokfLokfLokfMWQ`cMWQ`c%MWQ`c&MWQ`c'MWQ`c(MWQ`c)MWQ`c*MWQ`c+MWQ`c,MkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMc MkMc MkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMcMkMc MkOf MkOf MkOf MkYmc MkYmc MkYmc MkYmcMkYmcMkYmfMkYmfMkYmfMkYmfMkYmf MkYmf QMbdQMbdQMbdQMbdQMbdQMbdQMbdQMbdQMbdQMbdQMbdQMbdQbUdQbUdQbUdQbUdQbUd QbUd!QbUd"QbUd#QbUd$QbUd%QbUd&QbUd'QbUd(QbUd)QbUd*QbUd+QbUd,QbUd-WYkeWYkeWYke WYke!WYke"WYke#WYke$WYke%WYke&WYke'WYke(WYke)WYke*WYke+WYke,WYke-`U`mc-`U`mc.`U`mc/`U`mc0`U`mc1`U`md`U`md`U`md`U`md`U`md`U`md`U`md`U`md`U`md`U`md `\mUd `\mUd `\mUd `\mUd `\mUd`\mUd`mWd.`mWd/`mWd0`mWd1`mWe`mWe`mWe`mWe`mWe`mWe`mWe`mWe`mWe`mWe `mWe `mWe `mWe `mWe `mWe`mWe`mWe`mWefW^efW^efd^e.fd^e/fkvefkvefkvefkveiQ^eiQ^eiQ^eiQ^ekdMekdMepa88888c8888:c888:8cB::D:cB:<>8cBB>8@cBB>8BcBB>8DcBB>8FcBB>8Hc BB>::c BD>FFc BHD6@c D6:<:c D6:<>cD6:cF686@cF6:68cF6:6:cF6<68cF6<88cF6<:8cF6<::cF6<:<cF6<<8cF6<>8cF6<@8cF66:c!F6>6<c"F6>6>c#F6>6@c$F6>6Bc%F6>6Dc&F6>6Fc'F6>6Hc(F6>86c)F6>88c*F6>8:c+F6>8<c,F6>8>c-F6>8@c.F6>8Bc/F6>8Dc0F6>8Fc1F6>8HdF6>:6dF6>:8dF6>::dF6>:<dF6>:>dF6>:@dF6>:BdF6>:DdF6>:Fd F6>:Hd F6><6d F6><8d F6><:d F6><<dF6><>dF6><@dF6>>6dF6>>8dF6>>:dF6>><dF6>>>dF6>>@dF6>>BdF6>>DdF6>>FdF6>>HdF6>@6dF6>@8d F6>@:d!F6>@<d"F6>@>d#F6>@@d$F6>@Bd%F6>@Dd&F6>@Fd'F6>@Hd(F6>B6d)F6>B8d*F6>B:d+F6>B<d,F6>B>d-F6>B@d.F6>BBd/F6>BDd0F6>BFd1F6>BHeF6>D6eF6>D8eF6>D:eF6>D<eF6>D>eF6>D@eF6>DBeF6>DDeF6>DFe F6>DHe F6>F6e F6>F8e F6>F:e F6>F<eF6>F>eF6>F@eF6>FBeF6>FDeF6>FFeF6>FHeF6>H6eF6>H8eF6>H:eF6>H<eF6>H>eF6>H@eF6>HBeF6>HDeF6>HFeF6>HHeF6@66eF6@68e F6@6:e!F6@6<e"F6@6>e#F6@6@e$F6@6Be%F6@6De&F6@6Fe'F6@6He(F6@86e)F6@88e*F6@8:e+F6@8<e,F6@8>e-F6@8@e.F6@8Be/F6@8De0F6@8Fe1F6@8HfF6@:6fF6@:8fF6@::fF6@:<fF8868fF886:fF886<fF8:68fF8:88f F8:8:f F:868f F:86:f F:888f ua M:6:c-M:6:c/M:6:dM:6:dM:6:dM:6:dM:6:d M:6:dM:6<c.M:6<c0M:6<dM:6<dM:6<dM:6<dM:6<d M:6<d M:6<dM:6<e0M:6<fM:6<fM:6<fM:6Bc1M:6BdM:6Bd M:6Bd W868cW868cW86:f W86:f W8>8cW8>8cd86@c d86Dcd86Dcd86Dd.d86Dd/d86Dd0d86Dd1d86Dfd86Hcd86Hcd86Hed86Hed86Hed86Hed888cd888ed888ed888e d888e d888ed88<cd88<c#d88<c%d88<c&d88<c(d88<c*d88<dd88<dd88<dd88<dd88<dd88<dd88<dd88<dd88<d"d88<d&d88<d'd88<d)d88<d+d88<d,d88<d-d88<ed88<e d88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<ed88<e d88<e!d88<e"d88<e&d88<e'd88<e(d88<e*d88<e+d88<e,d88<e-d88<e/d88<e1d88<fd88<fd8:<c$d8:<c,d8:<dd8:<d%d8:<ed8:<e d8:<e%d8:@cd8:@cd8:Dcd8:Dfd8:Dfd8:Dfd8:Hf d8:Hf d8:Hf d:66cd:66cd:66cd:66cd:66cd:66cd:68cd:68c d:8@cd:8Dcd:8Dc!d:8Dc)d:8Ddd:8Ddd:8Ddd:8Ddd:8Dd#d:8Dd$d:8Dd(d:8Dd*d:8Ded:8De d:8Ded:8Ded:8Ded:8De$d:8De)d:8Hcd:<8c d:<8c d<:@c"d<:@c'd<:@c+d<:@dd<:@dd<:@dd<:@d d<:@d!d<:@ed<:@ed<:@e#d<:@e.s868c sH@csH@csH@c sH@csHHc.pa88888c8888:c888:8cB::D:cB:<>8cBB>8@cBB>8BcBB>8DcBB>8FcBB>8Hc BB>::c BD>FFc BHD6@c D6:<:c D6:<>cD6:cF686@cF6:68cF6:6:cF6<68cF6<88cF6<:8cF6<::cF6<:<cF6<<8cF6<>8cF6<@8cF66:c!F6>6<c"F6>6>c#F6>6@c$F6>6Bc%F6>6Dc&F6>6Fc'F6>6Hc(F6>86c)F6>88c*F6>8:c+F6>8<c,F6>8>c-F6>8@c.F6>8Bc/F6>8Dc0F6>8Fc1F6>8HdF6>:6dF6>:8dF6>::dF6>:<dF6>:>dF6>:@dF6>:BdF6>:DdF6>:Fd F6>:Hd F6><6d F6><8d F6><:d F6><<dF6><>dF6><@dF6>>6dF6>>8dF6>>:dF6>><dF6>>>dF6>>@dF6>>BdF6>>DdF6>>FdF6>>HdF6>@6dF6>@8d F6>@:d!F6>@<d"F6>@>d#F6>@@d$F6>@Bd%F6>@Dd&F6>@Fd'F6>@Hd(F6>B6d)F6>B8d*F6>B:d+F6>B<d,F6>B>d-F6>B@d.F6>BBd/F6>BDd0F6>BFd1F6>BHeF6>D6eF6>D8eF6>D:eF6>D<eF6>D>eF6>D@eF6>DBeF6>DDeF6>DFe F6>DHe F6>F6e F6>F8e F6>F:e F6>F<eF6>F>eF6>F@eF6>FBeF6>FDeF6>FFeF6>FHeF6>H6eF6>H8eF6>H:eF6>H<eF6>H>eF6>H@eF6>HBeF6>HDeF6>HFeF6>HHeF6@66eF6@68e F6@6:e!F6@6<e"F6@6>e#F6@6@e$F6@6Be%F6@6De&F6@6Fe'F6@6He(F6@86e)F6@88e*F6@8:e+F6@8<e,F6@8>e-F6@8@e.F6@8Be/F6@8De0F6@8Fe1F6@8HfF6@:6fF6@:8fF6@::fF6@:<fF8868fF886:fF886<fF8:68fF8:88f F8:8:f F:868f F:86:f F:888f a@@ @ @ @ @ @ @@@   @@`Bf `Bf `s8:6c`s8:6c `s:c`s:f`s< <6c `s< <6f `s>:6c`sB86c`sB86c`sB86c `sB86c `sD<6c`sH66c`sS88<6c`sS8:<6c`sSH<6c`sS86c`sS86c`sS86c!`sS86c%`sS86c)`sS86c0`sS86d`sS86d`sS86d `sS86d `sS86d`sS86d`sS86d`sS86d`sS86d"`sS86d'`sS86d/`sS86e`sS86e `sS86e `sS86e`sS86e`sS86e`sS86e`sS86e`sS86e!`sS86e$`sS86e(`sS86e-`sS86f`sS88c`sS88c`sS88c`sS88c`sS88c#`sS88c(`sS88c+`sS88c/`sS88d`sS88d`sS88d`sS88d`sS88d`sS88d`sS88d%`sS88d0`sS88e`sS88e`sS88e `sS88e `sS88e`sS88e `sS88e%`sS88e,`sS88e/`sS88e1`sS88f`sS88i88c`sS8:c`sS8:c`sS8:c$`sS8:c,`sS8:d`sS8:d `sS8:d`sS8:d&`sS8:d*`sS8:d1`sS8:e`sS8:e`sS8:e`sS8:e)`sS8:e.`sS8:f`sS8:f`sS8:i:c`sS:c-`sS:d`sS:d`sS:d `sS:e"`sSFc`sSHc`sSHc`sSHc"`sSHc'`sSHc.`sSHd`sSHd`sSHd `sSHd`sSHd`sSHd`sSHd`sSHd`sSHd!`sSHd$`sSHd(`sSHd+`sSHd.`sSHe`sSHe`sSHe`sSHe `sSHe`sSHe`sSHe`sSHe`sSHe`sSHe`sSHe#`sSHe'`sSHe+`sSHe0`sSHf`sSHf`sSHf iBcm:f mBcmi88fmi:c*mi:dmi:dmi:d)mi:d,mi:emi:e&mi:fmi< <6dmi< <6dmi< <6emiHc&miHc1miHd miHd#miHd-miHemiHemiHemiHemiHe*mm8:<6c mm:66cmmB86c mmD>6c2@Zk/ L  A L  ~ ` B $ X  i[Ky&v5d dwY+@ @ @G*pl [First]& gG*pl[Student ID]+ gG*plstudents!!! G*pl G*pl GF *plSections.sectionID1 'F *plstudents.[Student ID]4 'F*plstudentsenrollmentsZ@C7! F*plSectionsenrollmentsT@C7! F*plCatalog CoursesSections`@K?/ F*plCatalog CoursesSectionsL@K?/ F*platalog Courses].Credits8 gF*pl[Catalog Courses].Description< gF*pl[Catalog Courses].Title6 gF*plSections.[stop point]4 gF*plSections.professor1 gF*plSections.room, gF*plSections.time, gF*plSections_YearSections.YearF++ oF*plSections.Sem+ gF*plSections.Section/ gF*pl Sections_Course#Sections.[Course#]Q11 oF*pl Sections_DeptSections.DeptF++ oF*pl Sections.sectionID1 gF*pl students.[Balance Due]5 gF*pl students.Hometown0 gF*plstudents.GPA+ gF*plstudents.[Num Credits Earned]< gF*plstudents.Major- gF*plstudents_Yearstudents.YearF++ oF*plstudents.Last, gF*plstudents.Middle. gF*plstudents.First- gF*plstudents.[Student ID]4 gF*plenrollments''' F*plstudents!!! F*plSections!!! F*plCatalog Courses/// F*pl GF*pl GF*pl F*pl GE *plSections.Year, 'E *plSections.[Course#]1 'E *plSections.Dept, 'E*plCatalog CoursesSections`@K?/ E*plCatalog CoursesSectionsL@K?/ E*pl atalog Courses].Credits8 gE*pl [Catalog Courses].Description< gE*pl [Catalog Courses].Title6 gE*pl Sections.[stop point]4 gE*pl Sections.professor1 gE*plSections.room, gE*plSections.time, gE*plSections.Year, gE*plSections.Sem+ gE*plSections.Section/ gE*plSections_Course#Sections.[Course#]Q11 oE*plSections_DeptSections.DeptF++ oE*plSections.sectionID1 gE*plSections!!! E*plCatalog Courses/// E*pl GE*pl G YGrad"N  nn Y  Y  Y  Y  Y e Y sY Y  Y (Y  Student ID First MiddleLastYear Major$Num Credits EarnedGPAHometownBalance DuePmynMeccoeonNtsDnOynp}nq}YYYYYY.rFLast MajorPrimaryKeyStudent IDYear%A%A%A% A% A% A% A% A%A%A%B%B%B%B%B%B%B%B%B %B %B %B %B %B %B %B % B  %!B%C%"C%$C%%C%&C%'C%(C%)C%*C%+C%,C%-C%.C%/C%0C%#D%1D%3D%4D%5D%6D%7D%8D%9D%:D%;D%<D%=D%>D%?D%@D%AD%BD%CD%DD%2E%EElElElElElElElElElEl El El E l E l E lE lE lElElE lE lE%FE*plCatalog CoursesSectionsL@K?/ E*pl atalog Courses].Credits8 gE*pl [Catalog Courses].Description< gE*pl [Catalog Courses].Title6 gE*pl Sections.[stop point]4 gE*pl Sections.professor1 gE*plSections.room, gE*plSections.time, gE*plSections.Year, gE*plSections.Sem+ gE*plSections.Section/ gE*plSections_Course#Sections.[Course#]Q11 oE*plSections_DeptSections.DeptF++ oE*plSections.sectionID1 gE*plSections!!! E*plCatalog Courses/// E*pl GE*pl Gv1b @ @ @ @ @ @ @ @ @ @ @ @ @ @?"*?"+?",?"-?".?"/?"0?"1?"2?"3?"4?"5?"6?")@"7@"9@":@";@"<@"=@">@%@%@%@"8A%A%A%A%A%A% A% A% A% A% A%A%A%B%B%B%B%B%B%B%B%B %B %B %B %B %B %B %B % B  %!B%C%"C%$C%%C%&C%'C%(C%)C%*C%+C%,C%-C%.C%/C%0C%#D%1D%3D%4D%5D%6D%7D%8D%9D%:D%;D%<D%=D%>D%?D%@D%AD%BD%CD%DD%2E%EElElElElElElElElElEl El El E l E l E lE lE lElE%Ff stop pointMin(Sections.[stop point])[33 oBUAvg Of stop pointAvg(Sections.[stop point])[33 oBUSections.Dept, gBUSections!!! BU GBU GBU BU GAU(((Sections.Year)<2002))7 'AUSectionsenrollmentsT@C7! AUSections.Year, gAUenrollments.grade0 gAU"enrollments.[special permission]? gAUenrollments.sectionID4@ pm` k t $M + 0K J7 E H @@@@  @@    @@ JO`YbmJk\kMJmJ^dUMdoikQkOQJbkmJk\kQbid^^`QbmkkoLSdi`Qbid^^`QbmkkoLSdi`8Qbid^^`QbmkkoLSdi`:QbmQibQsMdoikQ SJMo^mvmJk\k`JYbidd`kkQMmYdbkkmoOQbmkkmoOQbmk8kmoOQbmksQbid^^kmoOQbmmJk\kJ^^Qbid^^`Qbmk MdobmdSQbid^^LvOQfmJbOMdoikQ!iQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb:"iQfdim^QJOYbUmdobbdi`J^YxQOkmoOQbmkOQkYUb<#idkmQiu$kMWQOo^Q%JomdQuQM&LJM\md`JYb'MdoikQk(SYbOkmO)JO`Yb*OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MQbid^^`QbmkkoLSdi`+kh+MMd`LdB++kh+MQbid^^`QbmkkoLSdi`8+kh+MkQMmYdbYO,+kh+MQbid^^`QbmkkoLSdi`:+kh+MkQMmYdbYO+kh+MkQMmYdbk+kh+MMd`Ld8B+kh+MkQMmYdbk+kh+MMd`Ld8F+kh+MkmoOQbmk+kh+MQbid^^`QbmkkoLSdi`8+kh+MkmoOQbmk+kh+MSYbOJkmoO+kh+MkmoOQbmk+kh+MSYbOkmoO+kh+MkmoOQbmk8+kh+MQbid^^`QbmkkoLSdi`:+kh+MkmoOQbmk8+kh+MSYbOkmoO+kh+MkmoOQbmksQbid^^+kh+MQbid^^`QbmkkoLSdi`+kh+OidkmQiu+kh+OkQMmYdbYO +kh+OkMWQOo^Q+kh+OkQMmYdbYO +kh+SMJmJ^dUMdoikQk +kh+SQbid^^`QbmkkoLSdi` +kh+SQbid^^`QbmkkoLSdi`8 +kh+SQbid^^`QbmkkoLSdi`:+kh+SQbmQibQsMdoikQ +kh+Sidd`k+kh+SkQMmYdbk ף@@9999ChrisAPaulFrDArtBaaton Rouge?1+'!9191DwyanePWadeSoDArt22,("  P@8181GilbertAArenasFrDArtLandover?5/+#! #ffF@@B7171PaulPPierceSoCHEMBoston:2,(  cbx@7070TimDDuncanSrHISSan Antonio=0+' ni@6161MichaelSJordanSrMKTGWilmingtonA5/+#!@5555PennyAHardawayFrCSCCherry HillA4/+! )\?@5151BaronUDavisSoBIOWestwood;1,(! @O4141GlennBRobinsonJrHISPhiladelphiaB4/+! ffv@3131ShaneDBattierFrCHEMVorhees=4.*! ffF@2222LarryRHughesSoBIOPhiladelphia@2-)! [R>@@B2121KeithVVan HornSrMGMTCherry HillB5/+! 33?1818KevinGGarnettFrBIOChicago<3.*! C+@1212KobeJBryantSoBIOLower Merion?1,( b@1123ShawnWBradleyFrCSCPalmyra<3.*! 0ˡM@ 1119MarcusSCambySoCHEMPennsauken?3-)"  kww@1117GrantPHillSrCSCPennsauken<0+'! Qb8@1116AllenXIversonJrBIOMaple Shade@3.*! ^t@1115ShaqOO'NealJrMKTGVorhees;2,(  66@1113KennyTAndersonSoMGMTCamden=5/+! @@1111CharlesDBarkleyFrHISPennsaukenA50,#! -`@@x}1093ChrisTWebberSoCSCHaddonfield?2-)! (ffF@1011AsonJKiddSoMGMTOakland90*& # m@ @ @ 8688o86H<o8888o888<o888@o888Bo888Do888Ho88:<o8:8:o 8F8Fo :8:8o ::::o <8<8o >8>8o@8@8o@@@@oB8B8oD6D6oD8D8oF8F8oH8H8oHHHHoQ m @ @ @SioSioSio Sio SioSioSio[io[io[iokdokdokdokdokdo kdo kdokdokdokiokio kiokio7Dh5U7 D x 5 > j @ g I  f'o$cnZ,}:EF  @ @ J*pl [Sections].[Year]0 gJ*pl [Sections].[Sem]/ gJ*pl [Sections].[Section]3 gJ*pl [Sections].[Course#]3 gJ*pl [Sections].[Dept]0 gJ*pl[Sections].[sectionID]5 gJ*pl[enrollments].[grade]4 gJ*plD@! gJ*plnrollments].[sectionID]8 gJ*plnrollments].[studentID]8 gJ*pl[students].[Student ID]6 gJ*pl[students].[Last]0 gJ*pl[students].[First]1 gJ*plenrollments''' J*plstudents!!! J*plSections!!! J*plCatalog Courses/// J*pl GJ*pl J*pl GI*plstudentsenrollmentsd@ C7! I*pl[enrollments].[grade]4 gI*pl D@ gI*pl nrollments].[sectionID]8 gI*pl nrollments].[studentID]8 gI*pl [students].[Balance Due]7 gI*pl [students].[Hometown]4 gI*pl[students].[GPA]/ gI*pl![students].[Num Credits Earned]> gI*pl[students].[Major]1 gI*pl[students].[Year]0 gI*pl[students].[Last]0 gI*pl[students].[Middle]2 gI*pl[students].[First]1 gI*pl[students].[Student ID]6 gI*plenrollments''' I*plstudents!!! I*pl GI*pl I*pl GH*plstudents Queryenrollmentsp@OC- H*pl[enrollments].[grade]4 gH*pl D@ gH*pl nrollments].[sectionID]8 gH*pl nrollments].[studentID]8 gH*pl [students Query].[Balance Due]= gH*pl [students Query].[Hometown]: gH*pl[students Query].[GPA]5 gH*plJ@ gH*pl[students Query].[Major]7 gH*pl[students Query].[Year]6 gH*pl[students Query].[Last]6 gH*pltudents Query].[Middle]8 gH*pl[students Query].[First]7 gH*pl[students Query].[Student ID]< gH*plenrollments''' H*plstudents Query--- H*pl GH*pl H*pl GG*pl [Balance Due], gG*pl [Hometown]) gG*pl[GPA]$ gG*pl[Num Credits Earned]3 gG*pl [Major]& gG*pl[Year]% gG*pl[Last]% gG*pl [Middle]' g$ @ @ @ @ @ @ @ @ @ @ @ @ @ @E lE lE lElElE lE lE lE%FFlFlFlFlFlFlFlFlFlFl Fl!Fl"Fl#Fl$Fl%F l&F l'F l(F l)F l*Fl+Fl,Fl-Fl.Fl/Fl0Fl1Fl2Fl3Fl4Fl5Fl6Fl7Fl8F l9F l:FlGl;Gl=Gl>Gl?GrGrGrGrGrGrG rG rGlJ r?J r@J rAJ rBJ rCJtJtJtJtJtJtJtJtJtJt Jt Jt Jt Jr1Kt KtKtKtKtKtKtKtStSt0St1St2St3St4St6St8St:StSt@StBS tDS tFStGS t5S t7S t9S t;S t=S t?S tAS tCS  tES tHStTtITTTTTTTTT T T T T  T T T T TTtJUU#U$U%U&U'U(U)U*U+U,U-U.U /U 0U 1U2U4U 3UW5W7W8W9W6 gZDv1 G O 1  z F  ʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʈ j <  b $ t6Jf-|,ĦĦĦĦĦĦĦĦĦĦĦĦĦĦ @ @ @T0students!!! T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)C7!T0studentsenrollmentsd@)T0studentsenrollmentsd@)T0studentsenrollmentsd@)CT0studentsenrollmentsd@)CT0studentsenrolT0studentsenrollmentsd@)T0studentsenrollmentsd@)C7! TFil Til GS DCount(enrollments.studentID)= /SSectionsenrollmentsT@'C7! S Sections.Section/ gS Sections.Section/ gS Sections.room, gS Sections.room, gSSections.time, gS Sections.time, gSSections.Year, gS Sections.Year, gSSections.Sem+ gS Sections.Sem+ gSSections.professor1 gS Sections.professor1 gSSections.[Course#]1 gS Sections.[Course#]1 gSSections.Dept, gS Sections.Dept, gSSections.sectionID1 gS Sections.sectionID1 gSCountOfstudentIDCount(enrollments.studentID)[11 oSenrollments''' SSections!!! S GS GS S GK*pl[Year]% gK*pl[Last]% gK*pl [Middle]' gK*pl [First]& gK*pl[Student ID]+ gK*plstudents!!! K*pl K*pl GJ*plSectionsenrollmentsb@%C7! J*plstudentsenrollmentsd@$C7! J*plCatalog CoursesSectionsb@#K?/ J*plCatalog CoursesSectionsV@"K?/ J*pl[Catalog Courses].[Credits]: gJ*pl![Catalog Courses].[Description]> gJ*platalog Courses].[Title]8 gJ*pl[Catalog Courses].[Course#]: gJ*pl[Catalog Courses].[Dept]7 gJ*pl[Sections].[stop point]6 gJ*pl[Sections].[professor]5 gJ*pl[Sections].[room]0 gJ*pl[Sections].[time]0 g( cl llll P p R Catalog CoursesSectionsSectionsCourse#Catalog CoursesCourse#xZL<Catalog CoursesSectionsSectionsDeptCatalog CoursesDeptzrTL<ProfessorsSectionsSectionsprofessorProfessorsNamephTB2RoomsSectionsSectionsroomRoomsroomRJ@8(studentsenrollmentsenrollmentsstudentIDstudentsStudent IDl\J4SectionsenrollmentsenrollmentssectionIDSectionssectionID~l\J4Catalog CoursesPrerequisites1PrerequisitesPreClassCatalog CoursesCourse#rbHCatalog CoursesPrerequisites1PrerequisitesPreProgCatalog CoursesDeptpbHCatalog CoursesPrerequisitesPrerequisitesClassCatalog CoursesCourse#j`FCatalog CoursesPrerequisitesPrerequisitesProgCatalog CoursesDepth`FL QLYd8B:SMWQ`88:SMWQ`:6:SMWQ`<6:SMkM:F6SMkM:H6SMkM<@>SMkM>B>SMkM>F8S QbU86FS `U`m<6<S `mW::8S `mW:::S `mW:::S j@  MSysObjects### CStr(Database)5 3  #L QLYd8B8SMWQ`888SMWQ`:68SMWQ`<68SMkM:<6SMkM:F6SMkM:H6SMkM<@>SMkM>F6S QbU86DS `U`m<6:S `mW8:6S `mW::8S `mW::8S enrollments not 2002 Query^^^^^^^^^^^ @oQN@oQN@junk create some sections test\\\\\\\\\\\ ?oQN@oQN@@junk create some sections aVVVVVVVVVVV >LN@LN@joint enrollments Query2PPPPPPPPPPP =)N@LN@join students enrolled sections/classesnnnnnnnnnnn <)N@)N@enrollments Query1DDDDDDDDDDD ;N@)N@enrollments QueryBBBBBBBBBBB XN@N@enrollments66666666666 :XN@XN@CountOfEnrollByCourse QueryVVVVVVVVVVV N@N@Catalog Courses>>>>>>>>>>> 9N@N@~sq_fstudentsWenrollHHHHHHHHHHH 8N@N@~sq_fstudents1<<<<<<<<<<< 7N@N@~sq_fstudents::::::::::: 6xN@N@~sq_fSections::::::::::: 5xN@xN@~sq_fRooms44444444444 4xN@xN@~sq_fEnter New Course:LLLLLLLLLLL 3U`N@U`N@~sq_fenrollments Subform2RRRRRRRRRRR 2U`N@U`N@~sq_fenrollments Subform1RRRRRRRRRRR 1U`N@U`N@~sq_fenrollments SubformPPPPPPPPPPP 02"N@2"N@~sq_fCatalog CoursesHHHHHHHHHHH /2"N@2"N@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV .2"N@2"N@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT -N@N@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx ,N@N@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn a @ @ @ @ @LYd8@Dc!LYd8B8c#LYd8F6c"LYd:86c$Lok868e0Lok868e1Lok8@6fLok8@6fLok:66fLok:66fLok:66fMWQ`888cMWQ`888c%MWQ`888c)MWQ`8@6c&MWQ`8@6c*MWQ`:68c'MWQ`:68c+MWQ`<68c(MWQ`<68c,MkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@:c MkM8@:cMkM8@:cMkM8@DcMkM8@DcMkM8@DcMkM8B:cMkM8B:cMkM:B>cMkM:B>cMkM:B>cMkM:B@c MkM<@:cMkM<@>cMkMF6c MkO:86f MkO:86f MkO<>6f MkYm8>Dc MkYm>B8cQMb8@6dQMb8@6dQMb8@6dQMb8@6dQMb8@@dQMb8@@dQMb:68dQMb:68dQMb:8<dQMb:8<dQMb:8<dQMb:8<dQbU86DdQbU86Dd QbU86Dd#QbU86Dd'QbU86Dd(QbU86Dd+QbU86Dd,QbU86Dd-QbU86FdQbU86Fd$QbU8@6dQbU8@6d!QbU8@6d"QbU8@6d%QbU8@6d&QbU:6<dQbU:6<d)QbU:6<d*WYk8@8eWYk8@8eWYk8@8e"WYk8@8e#WYk8@8e*WYk8@8e+WYk:@8e&WYk:@8e'WYk:@8e(WYk:@8e,WYk<6@e WYk<6@e!WYk<:>e)WYk<:>e-WYk<:He$WYk<<<e%`U`m<6:c-`U`m<6:c0`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d `U`m<@<c.`U`m<@<c/`U`m<@<d`U`m<@>c1`U`m<@>d`U`m<@>d`\mU<68d `\mU<68d `\mU<68d `\mU<68d`\mU<6>d`\mU<6@d `mW88<e`mW88<e`mW88<e`mW88<e `mW88<e `mW88<e `mW88<e`mW88Dd.`mW8:6d/`mW8:6d0`mW8:6e`mW8:6e`mW8:6e`mW8:6e `mW8>6e`mW8>6e `mW8>6e`mW::8d1`mW::8e`mW:::e`mW:>6e`mW:>6efW^8@8efW^8@:efd^8@8e.fd^8@8e/fkv8@@efkv8@@efkv8@@efkv8@@eiQ^8@6eiQ^8@6eiQ^8@<eiQ^8@<ekdM8@6ekdM8@6e~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn ca@   @@ @@@   @ @  @@    @@@@@@@@@@ @@@  @@    JbOiY^^YeJbOiY^^YeJbOiY^^YeJbOiY^^YeJi`kmidbUeLJ^MWobYke.LJ^^doUWc!LJ^^doUWc"LJ^^doUWc#LJ^^doUWc$LQJmmvdLQJmmvdLQJmmvdLQJmmvdLY^^Jc L^o`cLiJxYbJe0LiJxYbJe1LiJxYbJfLidUJbe/LioMQc-LioMQc.LioMQc/Loi\QcLoi\Q[eLom^Qid Lom^Qid!Lom^Qid"MJ`d`Y^Qf Md^^YbkeOQkbdvQike&OQkbdvQike'OQkbdvQike(OQkbdvQike)OYOYdcOYOYdcOYOYdeOYOYdeOYOYdeQ^^YdmmcSJYie"SJYie#SJYie$SJYie%SJ^MdbQeUiJbmcUiJbmc[dU^Q\Jic0[dU^Q\Jic1[dU^Q\Jid[dbQkOd [dbQkOd [dbQkOd [dbQkOf[dbQkbc%[dbQkbc&[dbQkbc'[dbQkbc(\Q^^vUe\Q^^vUe\YikMWc\YikMWc \YikMWf\bJffQbLQiUQid.\bJffQbLQiUQid/\bJffQbLQiUQid0\bJffQbLQiUQid1\d^JkJc \d^JkJc^QJoLvd^QJoLvd^QJoLvd^QYLYUQie*^QYLYUQie+^QYLYUQie,^QYLYUQie-^QYkmQif ^QYkmQif ^dbUdf ^dbUdf `Jc `MMJimve`MMJimve`MMJimve`MMdbbQ^^e`MMdbbQ^^e`MMdbbQ^^e `MMdbbQ^^e `QJOc`YMWJ^Q\e `YMWJ^Q\e `YMWJ^Q\e `YMWJ^Q\e`Y^^JiOd#`Y^^JiOd$`Y^^JiOd%`Y^^JiOd&`diQJoe`diQJoe`kWd`LJd`kWd`LJd`kWd`LJd`kWd`LJdbUovQbefJo^YbdfJo^YbdfJo^YbdfJo^YbdiJm\okeiJm\okeiQO`dbOciQO`dbOciQO`dbOc iQO`dbOciQO`dbOciQYMWJiOmciQYMWJiOmfiQYMWJiOmfiQYMWJiOmfiWdOJdiWdOJdiWdOJdidLYkdbdidLYkdbdidLYkdbdidLYkdbdkWJ^WdoLc)kWJ^WdoLc*kWJ^WdoLc+kWJ^WdoLc,kWQQWvekWQQWvekWQQWve kWQQWve!kdqQbd'kdqQbd(kdqQbd)kdqQbd*kmQqQbkckmQqQbkckmo^^ekoOQd+koOQd,koOQd-kxJLJmd kxJLJmdkxJLJmdkxJLJmfkxJLJmfkxJLJmfmJqJbJdmJqJbJdmJqJbJd moi\cmoi\cmoi\cmoi\cqQb\JmQkJbc sY^QvcsY^QvcsY^QvcvdobUcvdobUcvdobUcHHHHHHH /2"N@2"N@~sq_dSchedule~sq_dsectionIDVVVVVVVVVVV .2"N@2"N@~sq_drosterX~sq_dsectionIDTTTTTTTTTTT -N@N@~sq_cstudentsWenroll~sq_cenrollments Subformxxxxxxxxxxx ,N@N@~sq_cstudents1~sq_cFindStudVVVVVVVVVVV +N@N@~sq_cstudents1~sq_cenrollments Subform2nnnnnnnnnnn *N@N@~sq_cstudents~sq_cFindStudTTTTTTTTTTT )N@N@~sq_cstudents~sq_cFindAStudVVVVVVVVVVV (N@N@~sq_cstudents~sq_cenrollments Subform1lllllllllll 'gN@gN@~sq_cSections~sq_cCombo18RRRRRRRRRRR &)N@gN@~sq_cSections~sq_cCombo16RRRRRRRRRRR %)N@)N@~sq_cenrollments Subform2~sq_csectionIDnnnnnnnnnnn QQvcP=*z @ -  } j C 0  m Z G 3 p]I6#r_LK8%uaN;'Y  Y Y  Y2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2  2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 7 7 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 7 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 7 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 7 7 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 7 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 7 2 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp 2 LVALh  @ @ @ @άB0Catalog CoursesProfessorsά"&qenrollments qenrollments_1ʾCatalog CoursesάB0Catalog CoursesProfessorsά"&qenrollments qenrollments_1LVAL*l n    ɾ@ @ @ @ @ @ @ @ @ @ @MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationReplicableUseTransactionC <      MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR24ODBCTimeoutMaxRecords" < MR24ODBCTimeoutMaxRecords" < MR24ODBCTimeoutMaxRecords" < MR2BValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCMR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: < MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOn1 <   MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR24ODBCTimeoutMaxRecords" < MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOn1 <   MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationReplicableUseTransactionC <      MR24ODBCTimeoutMaxRecords" < MR24ODBCTimeoutMaxRecords" < MR2ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlaces WCourse#       mS Title       mUDescription      Credits *     3   >0 And <62 *"Credits must be 1-5" mQDept       mMR20 Title AuthorCompany` university Mike Redmond La Salle4QvcO<<<<<<<<<<)   x e R > +  {  g T A -}jVC0/kXD1 na2 aϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp a2 `2 `ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp `2 ^2 ]2 ]ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp ]2 ' 2 & 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp & 2 &ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp & 2 % 2 % ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp % 2 $ 2 $ ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp $ 2 # 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp # 2 #ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp # 2 "2 "ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp "2 !2 !ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp !2  2  ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 R2 Rϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp R2 Q2 Qϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp Q2 M2 Mϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp M2 L2 Lϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp L2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp bLVALt@@@( G&qCatalog Courses qSections2qenrollmentsά yD ] rCatalog CoursesCatalog Courses8Yenrollmentsenrollments$`SectionsSections!}studentsstudents  m\PrerequisitesPrerequisites.ProfessorsProfessors{VRoomsRoomsnCatalog Courses_1Catalog CoursesulSections_1SectionsTxSections_2Sectionsz,Sections_3Sections( G&qCatalog Courses qSections2qenrollments FvubO ; (    w d P = *   yfS?,|hUTA.}jWC0 ;ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp ;2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 :2 :ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp :2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 9 2 9 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 9 2 8 2 8 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 8 2 7 2 7 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 7 2 6 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp 6 2 6ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 6 2 5 2 5 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 5 2 4 2 4 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 4 2 3 2 3 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 3 2 2 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 1 2 1 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 1 2 0 2 0 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 0 2 / 2 / ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp / 2 . 2 . ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp . 2 - 2 - ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp - 2 , 2 , ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp , 2 + 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp + 2 +ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp + 2 * 2 * ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp * 2 ) 2 ) ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp ) 2 ( 2 ( ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp ( 2 ' 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp ' 2 'ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp pFcP=) y f R ? ,   {  z  yfR?,{hUA.~jWD0  Y Y  Y  Y  YH2 G2 Gϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp G2 F2 Fϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp F2 m2 mϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp m2 E2 Eϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp E2 a2 aϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp a2 D2 Dϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp D2 C2 Cϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp C2 [2 [ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp [2 U2 Uϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp U2 Q2 Qϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp Q2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 @3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp 2 Tϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 T3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp Tϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 &3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp &2 &ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp &2 B2 Bϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp B2 A2 Aϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp A2 @2 @ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp @2 ?2 ?ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp ?2 >2 >ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp >2 =2 =ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp =2 <2 <ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp <2 ;2 LVALh , @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ ά&qCatalog Courses qSections( G&dCatalog Courses dSections2dstudentsdenrollments( G&dstudents denrollments( G&qSectionsά5#u0SectionsPenrollmentsά z0Catalog CoursesProfessorsLVAL  Q  eee Wm H%!HGtE| =6rC N@CN@roster Query88888888888 [IN@="0000" And <="9999"* ""must be numeric" m email   \ Tassumes local - only has userid not domain    mMR2rValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControl QProg       mS Class       mPreProg   0 (Dept of Prerequisite    mPreClass   4 ,Class# of Prerequisite    mMR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOn1 <   MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    LVALhDQ'''pe ?''' ''P 'h ' <`''''"'B'b'H'''''0'P'x'''''''`''''"'B'b'              )enrollments.sectionIDenrollments%students.Student IDstudentsstudents.Firststudents.Middlestudents.Laststudents.Yearstudents.Major'' @''p'6_@'' '' `'$ '$ '$ '$ "'$ B'$ b'$students '  ' 'X'p'zNtN@enrollmentsx 'P '` '0'p'@roster Query'' H'8' @'p' 'x' '' '' 0'' P''H')students.[Student ID]@''''0'P''$ '$ '$ "'$ B'$ b'$students ' ' '( ' '0 ' "'8 ' B'@ ' b'H '@''''0'P'`'$enrollments `'H 'H'h ' ''5[Enter Course Index Number]h ' '8'' p'8'X'x''' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' '' ''('''h'H'0' H'X' H'X' H'X' H'X' H'X' H'X' 'z '`''''$'' ''z 'h'('''H''8$''H''p'P''''''''  ' ' ' P' ' ' 'D '''''''@''''P''''X'0'students p' ' ' ' 'YearStudent IDPrimaryKey MajorLastenrollments P' x'  '  ' '%studentsenrollmentsstudentID%SectionsenrollmentssectionIDPrimaryKey X''@'  0' ' 0'X''  Student ID''v "'!''v P&' &'8&''8'8'q8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8'8''' '(''&' ' '$' 'enr LVAL  MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationColumnWMR2fODBCTimeoutMaxRecordsColumnWidthColumnHidden" < S82[enrollments].[stuMR2fODMR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOn1 <   MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <    LVALv1b N  : k & W  C t/MR2^ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlacesRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToList -Student ID t   Student number - 4 digits - made text so leading zeroes dont go away - not doing math on them anyway    m First *  , $Student First Name    m Middle   4 ,Student Middle Initial    m{Last   * "Student Last Name    mYear v  T LStudent Academic Year (Fr, So, Jr, Sr)   H @="Fr" Or ="So" Or ="Jr" Or ="Sr"8 0"Must be Fr So Jr or Sr" o Value List< 4"Fr";"So";"Jr";"Sr";"Grad"    1440  1440twip Hometown    | tStudent Hometown (in reality would have whole address too)    mBalance Due   ` XAmount Student Currently owes the university2 *$#,##0.00;($#,##0.00)   0  ;*$Num Credits Earned    X PStudent Number of Credits Earned to Date   TotalCredits  0   >=0> 6"Invalid Number of Credits" m GPA *   Student Current GPA (derived from student course grades - must be updated each semester)   0   >=0 And <=4V N"Invalid GPA - must be between 0 and 4" mu Major   " Student Major    m LVAL0 00 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @zzzzzzzzz z z z zzzʾstudents simulate bad enrollment designstudentsWenrollreport leading to unnormalized students design2Create data access page in Design viewAutoExec^3ά&qCatalog Courses qSections2qstudentsqenrollments? LVALO ollmentsH'' H'' ''"''@"'"'x"'"'' '`#'#'#'#'%Sectionsenrollments( $'#' h '65[Enter Course Index Number]$'#'#'"'<$' "'d$'8$'@$'($' '''%'8$'%studentsenrollmentsstudentsStudent IDH' ' ' 'P&'p$'&'&'&'x"''8''8'(''&'`''''(''''`''''X'0'e + u S ; k ƈC_dkl@dkl@temp u_dkl@ ;m@0temp update Sections Query2Y@|@nbbVVVVVVVT @^l@Vl@temp Rooms Query2. @@ |@fZZNBBBBBB@ `7z@z@~sq_fstudents2_(=4MR2KeepLocal TH<<<<<<: `\ndE@c:Ll@potential advisees2@ @^RRFFFFFFFD @Z^@^@junk roster288888888886 Y u~@-~@~sq_djunk sched~sq_dsectionID2s @4MR2KeepLocal Th\\\\\\Z `X|@|@junk sched266666666664 D@.PA@schedule Query2F} H@ @bVVJ>>>>>>< `W@>@simulate bad section enrollments2$!@@zznbbbbbb` `ȑ0V@0V@MSysIMEXColumns2@@@@@@@@@@> ,V@i-V@MSysIMEXSpecs2<<<<<<<<<<: V͇fS@͇fS@report leading to unnormalized rooms design2xxxxxxxxxxv UɴʌS@NtьS@Rooms and sections - equiv to 1NF2@<@@||pddddddb `T΋wP@TH{P@simulate bad enrollment design2z$@@vvj^^^^^^\ `S8pN@qN@section enrollment counts Query2@ @xll```````^ @GC[@S[@students Query2Z@JJJ>>>>>>>< @;7vcO<)   x e R > +    z  yfS?,+{hgTA@0fN@junk enrollments not 2002 Query2@@xll```````^ @<_O[@_O[@enrollments Query12Z@|RRRFFFFFFFD @8k;@k;@~sq_fstudents124MR2KeepLocal T~~~>>>>>>>< @6wtvN@wtvN@~sq_fSections24MR2KeepLocal T|||<<<<<<<: @4@@~sq_fEnter New Course:24MR2KeepLocal TNNNNNNNL @1 A@ A@~sq_fenrollments Subform24MR2K_2 _ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp _2 ^2 ^ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp \2 \ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp \2 [2 [ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp [2 Z2 Zϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp Z2 Y 3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp Y 2 Yϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp Y 2 X2 Xϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp X2 W2 Wϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp W2  3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp  2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2  3|VHa,UN;46z43UU#qE: l)0l]GIX|lҬ/Gp  2 ϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp  2 V2 Vϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp V2 U2 Uϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp U2 T2 Tϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp T2 S2 Sϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp S2 K2 Kϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp K2 J2 Jϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp J2 I2 Iϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp I2 H2 Hϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp lb!s:  B s 6 ˪˪˪˪˪˪˪˪˪˪˪˪˪ˌ n F  j ' H 9ǝǝǝǝǝǝǝǝǝǝǝǝǝǝǝa3Jd+ktVWtVVVVV8\Professors%%% \ G\ G\Fil \il GY GYSections!!! Y[Sections].[Year]0 gY[Sections].[Sem]/ gY[Sections].[Section]3 gY[Sections].[Course#]3 gY[Sections].[Dept]0 gY[Sections].[sectionID]5 gY Y GWSectionsenrollmentsT@C7! W enrollments.grade0 gW "enrollments.[special permission]? gW enrollments.studentID4 gW Sections.[stop point]4 gW Sections.professor1 gWSections.room, gWSections.time, gWSections.Year, gWSections.Sem+ gWSections.Section/ gWSections.[Course#]1 gWSections.Dept, gWSections.sectionID1 gWenrollments''' WSections!!! W GW GW  W GUb@ 'U  Rooms.room) 'URoomsSectionsRooms.room = Sections.roomS+ U Sections.Year, gU Sections.Sem+ gU Sections.sectionID1 gUSections.time, gUB@, gURooms.Overhead- gURooms.[Data Projector]5 gURooms.[Data Connection]6 gURooms.[Front Computer]5 gU Rooms.size) gU Rooms.room) gUSections!!! URooms U GU GU U GT<@studentsenrollmentsZ@*C7! T<@ enrollments.grade0 gT<@ "enrollments.[special permission]? gT<@ enrollments.sectionID4 gT<@ students.[Balance Due]5 gT<@ students.Hometown0 gT<@students.GPA+ gT<@students.[Num Credits Earned]< gT<@students.Major- gT<@students.Year, gT<@students.Last, gT<@students.Middle. gT<@students.First- gT<@students.[Student ID]4 gT<@enrollments''' T<@students!!! T<@ GT<@ G YN  Y Y Y Y  Y  L Y  DY Y  Y DY Y  Y   Y DDateDelim"DateFourDigitYear DateLeadingZerosDateOrderDecimalPointFieldSeparatorFileType SpecIDSpecNameSpecTypeStartRowTextDelimTimeDelimDDDDYPrimaryKey,LVALϞJJJJJJJθV s 6 ˪˪˪˪˪˪˪˪˪˪˪˪˪ˌ n F  j ' H 9students.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID[Sections].[sectionID] =[enrollments].[sectionID][students].[Student ID] =[enrollments].[studentID][Catalog Courses].[Course#] =[Sections].[Course#][Catalog Courses].[Dept] =[Sections].[Dept][enrollments].[special permission][students].[Student ID] =[enrollments].[studentID][enrollments].[special permission][students Query].[Student ID] =[enrollments].[studentID][enrollments].[special permission][students Query].[Num Credits Earned]students.[Student ID] = enrollments.studentIDSections.sectionID = enrollments.sectionID[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept[Catalog Courses].[Course#] = Sections.[Course#][Catalog Courses].Dept = Sections.Dept(((students.First)=[What is your first name?]) AND ((students.Last)=[What isURoomsSectionsRooms.room = Sections.roomS+ U Sections.Year, gU Sections.Sem+ gU Sections.sectionID1 gUSections.time, gUB@, gURooms.Overhead- gURooms.[Data Projector]5 gURooms.[Data Connection]6 gURooms.[Front Computer]5 gU Rooms.size) gU Rooms.room) gUSections!!! URooms U GU GU U GT<@studentsenrollmentsZ@*C7! T<@ enrollments.grade0 gT<@ "enrollments.[special permission]? gT<@ enrollments.sectionID4 gT<@ students.[Balance Due]5 gT<@ students.Hometown0 gT<@students.GPA+ gT<@students.[Num UɴʌS@NtьS@Rooms and sections - [Sections].[sections(((Sections.Sem)="F") AND ((Sections.Year)=1999))Rooms.[Numb Student Workstations](((students.Major)=[Professors]![Dept]))Sections.sectionID = enrollments.sectionID(((Sections.Sem)="F") AND ((Sections.Year)=2002))LVALh hhh81 G O 1  z F  ʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʦʈ j <  b $ t6Jf-|, <,X2XrXXXXX"XBXbXxX,X X`XXXXXX0XPXxX(XHXHXHά&qstudents qenrollmentsʾstudentsά0RoomsPSectionsά&qstudents qenrollmentsά5#0SectionsPenrollmentsLVAL@<FDm))t} :?)8 <, $TRz,Hx@h,((((, $TRz               Rooms.room RoomsRooms.size'Rooms.Front Computer)Rooms.Data Connection'Rooms.Data ProjectorRooms.Overhead=Rooms.Numb Student WorkstationsSections.timeSections#Sections.sectionIDSections.SemSections.Year`  X xNtьS@HX(@MSy ~ti   ~s,$ ~0#~T ~`f ~m ~je ~L"~ ~R ~wsz ~Na  ~"~ RoomsP  @ yYsN@SectionsP   8hN@ARooms and sections - equiv to 1NFX@        P  X  `     @  h   +Rooms.[Front Computer] -Rooms.[Data Connection] +Rooms.[Data Projector] ARooms.[Numb Student Workstations]` @h  ~~   ~ $ ~ T ~  ~ ~~ ~ Rooms     $  T          `  R ~4 z ~  ~  ~Sections R z  @h h! 8h)x Ț x x x x x x Țh Țh Țh xh z 0P(@ (~Xx X(8Hz ( p~@X8p x X   8 pT0 xx X8phRooms h  xroomPrimaryKeySections H  X p      # LVAL3  timesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catalog CoursesSections 0x  h @ h  roomv  ##v &%'c0h!h!qh!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!h!' (' "x%&SectionsȚ8 x8Ț8 x8 #X#$#$# $,D$P$$T$`$$d$ X#Sections.Year $~^$$%$  #Sections.Sem%"F"L%@$h$0$$X%8H% RoomsroomȚP  xP &h%P&& P ('8'@'P'"room  #d' &'`'h'&room &P&# @ Țh! xh!xh!('P((((P((((hK&[hNh V 8 0 r  V *7ptd"p˔*p˔Blob 5TypeInfoH=PropDataGGTFPSECFHBBSDEHZPEPGNKDDXUTK:'_VBA_PROJECT Fdir ͬ 1ܟh(`G!% PageHeaderSectionDetailPageFooterSectionReportHeaderReportFooterGroupHeader0mroomdroom_Labelmsized size_Labelj Front_ComputerFront Computerd Front_Computer_LabelFront Computer_Labelj Data_ConnectionData Connectiond Data_Connection_LabelData Connection_LabeljData_ProjectorData ProjectordData_Projector_LabelData Projector_Labelj08 :<=Babc2e g͇fS@BRooms and sections - equiv to 1NFVreport leading to unnormalized rooms design Arial8 hEPSON Stylus Photo 785EPX`f odhhRL*** xhhDLLName32=E_DU12SE.DLL d &K&[2EPSON Stylus Photo 785EPX   E-winspoolEPSON Stylus Photo 785EPXUSB001d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4roomtime`ReportHeader@-8sO7FO/d25`<a<bLcdLabel18Vreport leading to unnormalized rooms design 1G^L =tf23a<b2 Line21'ۙCIz`"PageHeaderSectionAaga:b d5a<bc room_LabelroomDetachedLabeldOEc'=hd57`a<b\c size_LabelCapacityDetachedLabellvDXEZݶd5`(a<bc (Front Computer_LabelFront ComputerDetachedLabel(Front_Computer_Label6CLX:`[0d5`@a<b`c *Data Connection_LabelData ConnectionDetachedLabel*Data_Connection_Labelbm"_I >7rd5`a<bc (Data Projector_LabelData ProjectorDetachedLabel(Data_Projector_Label>#LKA d5`(a<bc Overhead_LabelOverheadDetachedLabely"P]G/0$d57`a<b\ c >Numb Student Workstations_Label2Numb Student WorkstationsDetachedLabel>Numb_Student_Workstations_Label ҴM$9Md5`(a<bc time_LabeltimeDetachedLabelB?K a8jd5`+a<b4c sectionID_LabelSection IndexDetachedLabelJlm͍Cf23b2 Line22@$QCL6(7ޟMf23ab2 Line23Dag"`GroupHeader0RFNt J ` Detail>zSME m5broomroomLunique identifier for room e.g. at134uII m05`b\ksizesizecapacityzuDj`(iFront ComputerFront Computerl'K&[Nwhether there is a computer up front for the professorFront_Computer/,Lk@99j`@iData ConnectionData ConnectionData_Connection4~D{j`iData ProjectorData ProjectorData_ProjectorCZlt|wM>O?j`(iOverheadOverhead<}@schedule Queryjunk sched Arial8 h\\ADM-SRV1\O126-HP4100?dXXLetter.HP LaserJet 4100 PCL 62xeP.Ca=~~ZD /PI <4! 6/;7܍Y993p tևm;qHv3#e2uD[-P+h9"0v>' 6OiDgC U^t;:K{}@a2F[ mR>tVR[z/:O?[RNyB~W:臌֪ g5g] \Ta 59 ܢ^IY Q`:JpF(K&[First_Labelm Student_IDStudent IDd Student_ID_LabelStudent ID_LabelmMiddledMiddle_LabeloYeardYear_Labelm54ACAB" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_main=0, 0, 0, 0, C Form_studentTasks=0, 0, 0, 0, C Form_FacultyTasks=0, 0, 0, 0, C Form_DeansTasks=0, 0, 0, 0, C Form_studentsWenroll=0, 0, 0, 0, C x Form_mainForm_mainForm_studentTasksForm_studentTasksForm_FacultyTasksForm_FacultyTasksForm_DeansTasksForm_DeansTasksForm_s08:<=Babc2e g^@roster Queryjunk roster Arial82h\\ADM-SRV1\O126-HP4100?dXXLetter.HP LaserJet 4100 PCL 62xeP.Ca=~~ZD /PI <4! 6/;7܍Y993p tևm;qHv3#e2uD[-P+h9"0vg gr1\db@L@LBlob PropDataacCTypeInfoDHAVTPFCOJAWTPDFCEFNJMIMEMKLJ:HOBMAVLIDOFSODAHMCNIEIODPONC:k AOGTLGLWSKDIHEUKBTZD_JAHOZOB: HQPWRRHJBCGVTXDNCFZVSNLGICNTL:,  !"#$%&'()*+-./0123456789:;<=>?@ABCDEFGIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijlmnopqrstuvwxyz{|}~>' 6OiDgC U^t;:K{}@a2F[ mR>tVR[z/:O?[RNyB~W:臌֪ g5g] \Ta 59 ܢ^IY Q`:JpF%LVAL" NY Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectIdMR2ODBCTimeoutMaxRecordsColumnWidthColumnHiddenRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <     C("[students].[Last]  K0*[students].[Hometown]  Q60[students].[Balance Due] U S82[enrollments].[sectionID]  eJD[enrollments].[special permission] G K0*[enrollments].[grade]  MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationColumnWidthColumnHidden: <    E*$Sections.sectionID H  ; Sections_Dept   A& Sections_Course#   A& Sections.Section   9Sections.Sem   ; Sections.Year I  ; Sections.time V  ; Sections.room   E*$Sections.professor   K0*Sections.[stop point]   O4.[Catalog Courses].Title   S82[Catalog Courses].Credits *  MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationColumnWidthColumnHidden: <    K0*students.[Student ID] t  ="students.First *  ?$students.Middle   ; students.Last   ; students_Year    ="students.Major   [@:students.[Num Credits Earned]   9students.GPA v  C("students.Hometown    M2,students.[Balance Due] U  E*$Sections.sectionID   ; Sections_Dept f  A& Sections_Course#   A& Sections.Section   9Sections.Sem I  ; Sections_Year :  ; Sections.time V  ; Sections.room   E*$Sections.professor   K0*Sections.[stop point] I  O4.[Catalog Courses].Title   S82[Catalog Courses].Credits *  LVALICFD)GF3 *G ;?(6F3GF3F36F3XT <\F3F3F3F3(F3jF3F3F3F3 F3:F3hF3F3F3 F3F3ZF3zF3F3F3F3HF3F3\F3F3F3F3(F3XF3xF3F3F3F3(F3hF3F3F3F3F3HF3hF3F3F3F3(F3`F3\F3F3F3F3F3F3F3F3F3F3PF3PF3PF3PF3PF3PF3PF3PF3PF3PF3F3F3F3\F3F3F3F3HF3jF3F3F3F3 F3:F3F3F3F3 F38F3ZF3zF3F3F3F3HF3F3               (                       <    %students.Student IDstudentsstudents.Firststudents.Middlestudents.Laststudents_YearYearstudents.Major5students.Num Credits Earnedstudents.GPA!students.Hometown'students.Balance Due#Sections.sectionIDSectionsSections_DeptDeptSections_Course# Course#Sections.SectionSections.SemSections_YearYearSections.timeSections.room#Sections.professor%Sections.stop point)Catalog Courses.TitleCatalog Courses5Catalog Courses.Description-Catalog Courses.Credits0F3 F3` F3F3F3N$@L F30 F34|4 F3 F34|4 F3 F34|4 F3 F34|4F3|4|F3|4|F3|4|F3|4|(F3|4|jF3|4|F3|4|F3|4|F3|4| F3|4| :F3|4| hF3|4| F3|4| F3|4|  F3|4|F3|4|ZF3|4|zF3|4|F3|4|F3|4|F3|4|HF3|4|F3|4|Catalog Courses`F3F3@F3+F3F3agnN@SectionsF3  F3F3*F3F3N@students@F3   F3(F3P(F3F3zNtN@enrollmentsF3F3F32F3F3' QN@estudents and sections and courses join equiv to 1NF0 F3 F3 F3 F3 F3F3 F3F3 F3 F3 F3(F3 (F30F3 XF38F3 @F3F3 F3F3 F3F3  F3F3 (F3F3 hF3F3 F3F3 F3F3 F3F3 F3F3 HF3F3 hF3F3 F3F3  F3HF3 PF3F3 F3F3 F3F3)students.[Student ID]F3F3F3F3(F3XF39students.[Num Credits Earned]@F3F3F3+students.[Balance Due]F3(F3hF3F3F3F3F3HF3hF3F3)Sections.[stop point]F3-[Catalog Courses].TitlePF39[Catalog Courses].DescriptionF31[Catalog Courses].CreditsF3MF3|HF3|F3|Catalog Courses tF3hF3 F3pF3 F3xF3PF3F3F3:F3| F3|  F3|ZF3|zF3|F3|F3|Sections :F3HF3 zF3PF3 F3XF3 F3`F3 F3hF3LVAL *F3pF3 ZF3xF3 zF3F3 F3F3 F3F3(F3hF3F3F3F3F3HF3hF3F3F3 F3|~F3|8F3|F3|jF3|F3|F3|F3| F3| students F3HF3 F3PF3 F3XF3 F3`F3 :F3hF3 jF3pF3 F3xF3 F3F3 F3F3 F3F3F3F3F3F3(F3XF3@F3F3F3F3enrollments F3;F3-F3 F38F3F3F3XF3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3F3(F3GF3.F3!ȚF3P(F3 ȚF3P(F3 ȚF3P(F3 ȚF3P(F3 ȚF3P(F3 ȚF3P(F3 xF3P(F3 xF3P(F3 ȚF3P(F3 xF3P(F3  ȚF3*F3 ȚF3*F3 ȚF3*F3 ȚF3*F3 ȚF3*F3 xF3*F3 ȚF3*F3 ȚF3*F3 ȚF3*F3 xF3*F3  ȚF3+F3 F3+F3 $xF3+F3 F3z 1F35F3FF32F34F34F3| F3H#F3#F3h)F3#F3x)F3#F3)F3($F3)F3`$F3)F3$F3)F3$F3)F3%F3)F3@%F3)F3F3z h0F34F3XFF30F3p4F34F305F3(| F3x%F3)F3%F3 +F3%F30+F3 &F3@+F3X&F3P+F3&F3`+F3&F3p+F3'F3+F38'F3+F3p'F3+F3F3z /F36F3 FF3/F3`5F305F3|0 F3'F3+F3 'F3,F3(F3,F3 H#F3 #F3 #F3 #F3 ($F3 `$F3$F3$F3 (%F3@%F3  x%F3 %F3 %F3  &F3 X&F3&F3 &F3 'F3 8'F3p'F3 <'F3 'F3(F3l/F3/F3/F3 /F3(/F30/F38/F3@/F3H/F3P/F3X/F3`/F3h/F3p/F3x/F3/F3/F3/F3/F3/F3/F3/F3/F3h4F34F35F36F3H#F3#F3#F3#F3($F3`$F3$F3$F3%F3@%F3x%F3%F3%F3 &F3X&F3&F3&F3'F38'F3p'F3'F3'F3(F3-+F3*F3P(F32F3Catalog Courses 00F3 H0F3 X0F3PrimaryKeyDept Course#Sections  1F3  01F3 H1F3 h1F3 x1F3  1F3 1F3  1F3timesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catalog CoursesSectionsstudents x2F3 2F3 2F3 2F3 2F3YearStudent IDPrimaryKey MajorLastF3z 3F3FF34F3| F3enrollments *F3 4F3 P(F34F3h4F3  2F3 04F3 2F34F3X/F3  PrimaryKey4F3  2F3 4F3 2F35F3/F3  Student ID LVALN  +F3@5F3`/F3  h/F3  *F3p5F35F3  6F3  +F3 5F3+F3 5F3PrimaryKey06F3F3v X=F3@=F3F3v (>F3=F3@F3F3v p@F3@@F3BF3F3v BF3BF3DF340XTF3;F3;Fq3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3;F3PEF3 F3EF3DF3 hF3=F3`>F3>F3>F3>F3F3 7F3?F3?F3?F3?F3%studentsenrollments  X=F3?F3 ?F3?F3?F3?F3>F3%studentsenrollmentsSectionssectionIDȚF38F3 ȚF38F3 ȚF38F3 xF38F3p@F3@F3@F3PAF3@F3`AF3AF3pAF3F3 8F3BF3 (BF30BF3@BF3sectionID  `>F3TBF3 AF3|BF3PBF3XBF3AF3sectionIDCatalog CoursesPrimaryKeyȚF39F3 ȚF39F3 xF39F3BF3BF3 CF3CF3XCF3CF3F3 9F3@DF3 XDF3pDF3DF3"PrimaryKey @F3  @F3DF3 CF3DF3DF3DF3CF3PrimaryKey X=F3  p@F3XCF3AF3=F3>F3 @  @ ȚF3;F3 ȚF3;F3 xF3;F3xF3;F3xF3;F3xF3;F3EF3DF3EF3GF3 FF3GF3XFF3 GF3FF30GF3FF3@GF3 FF3PGF3XFF3`GF3FF3pGF3FF3GF3+F3*F3P(F32F3LVALLFDH+F7.H+ ";?`!F7H+F7F7!F7@7 <42F7`F7F7F7F7"F7BF7bF7F7F7F70F7hF74 F7`F7F7F7F7F70F7PF7pF7F7F7F7HF74HF7HF7HF7HF7HF7HF7HF7HF7HF7HF7F7F7F742F7F7F7F7F7"F7BF7bF7F7F7F70F7hF7                    <    #Sections.sectionIDSectionsSections_DeptDeptSections_Course# Course#Sections.SectionSections.SemSections.YearSections.timeSections.room#Sections.professor%Sections.stop point)Catalog Courses.TitleCatalog Courses5Catalog Courses.Description-Catalog Courses.Creditsx F7  p F7HF7 F7xF7I$@,8F7XF7|(F7@F7|2F7||Z`F7||F7||F7||F7||"F7|X=F3BF7|-bF7|enF7|udF7|] F7|(>F3 0F7|1 hF7|ll Catalog Courses F7` F7 F7PF7xF7agnN@SectionshF7  F7PF7F7xF7N@]Sections and courses join Query - equiv to 2NFXF7@F7 F7 F7 `F7( F7 F70 F7 F78 F7 F7@ F7 F7H F7 0F7P F7 PF7X F7 pF7` F7  h F7 F7 F7 F7 F7 F7 F7X F7 F7`F7F7F7F7F70F7PF7pF7)Sections.[stop point]h F7-[Catalog Courses].Title F79[Catalog Courses].Description F71[Catalog Courses].Credits F7MF7|X# 0F7|Se thF7|.Y aCatalog Courses F7F7 F7F7 D F7F7 F7 F7 F72F7|F7||F7||"F7||BF7||bF7||F7|F7|Se Sections 2F7F7 rF7F7 F7F7 F7F7 F7F7 "F7F7 BF7F7 bF7F7 F7F7 F7F7 F7`F7F7F7F7F70F7PF7pF7h F7 F7$F7F7 xF78F7pF7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7X+F7pF7ȚF7F7 ȚF7F7 ȚF7F7 ȚF7F7 ȚF7F7 xF7F7 ȚF7F7 ȚF7F7 ȚF7F7 xF7F7  ȚF7PF7 F7PF7 $xF7PF7 F7z F7*F7F7h F7|@F7F7F7F70F7F7hF7F7F7F7F7F7F7F7HF7F7F7 F7F70F7F7z @F7H!F7x*F7`F7 F7h F7|XF7LVALN  /a6pWI@%I@prw_tblLogrXs@BBB66666664 @C@ D@prw_tblHistoryrX@JJJ>>>>>>>< @|?@A@Paste ErrorsrX::::::::::8 F9@{k9@og_TblValuesAndLabelsrX@XXXLLLLLLLJ @4@>5@og_TblTemprX@PBBB66666664 @2@2@NORM_tblMULockrX@JJJ>>>>>>>< @J*@+@mx_TblImexColsrX)@JJJ>>>>>>>< @'@1[(@mlbl_tblUserSizesrXq@PPPDDDDDDDB @e@%!@mlbl_tblRepPropertiesrXd@XXXLLLLLLLJ @@S@mlbl_tblMailingLabelPreferencesrX@Plll```````^ @Qx@S@mlbl_tblLabelSizesrX@PRRRFFFFFFFD @ L @D @mlbl_qryUserLblListrX*@P|@(`TTHHHHHHHF @ @@mlbl_qryLblListrX@|@(XLL@@@@@@@> @M1@җ@LBWiz_tblValLstrX@BLLL@@@@@@@> @C+)@ @im_TblInputMaskrXs@BLLLF7@F7 (F7hF7`F7xF7  F7 F7 0F7 hF7 F7F7 F7 HF7 F7F7 <F7 (F7`F7\<F7F7F7F7F7F7F7F7F7F7 F7(F70F7!F7@!F7F7F70F7hF7F7F7F7HF7F7F7F7(F7`F7%PF7F7Catalog Courses F7 F7 F7PrimaryKeyDept Course#Sections F7  F7 F7 F7 F7   F7 ( F7  8 F7timesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catalog CoursesSections PF7x F7F7  F7  F7 F7!F7  @!F7  PF7  F7PF7 !F7PrimaryKeyh!F7F7v %F7%F7F7v ('F7&F7)F74]0@7F7$F7$Fq7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7$F7)F7 F7)F70)F7 p%F7F7!F7(F7SectionsȚF7!F7 ȚF7!F7 xF7!F7xF7!F7%F7F7&F7&F7@&F7&F7x&F7&F7Catalog CoursesPrimaryKeyȚF7#F7 ȚF7#F7 xF7#F7('F7&F7`'F7'F7'F7'F7F7 #F7(F7 (F7(F7(F7"PrimaryKey %F7  &F7(F7 (F7(F7(F7(F7'F7PrimaryKey %F7 &F7@&F7'F7x&F7 @ @ @ȚF7$F7 ȚF7$F7 xF7$F7xF7$F7xF7$F7)F7)F7*F7*F7@*F7*F7x*F7+F7*F7+F7x*F7(+F7*F78+F7PF7F7L LVALh NU0?DwdhʾexxxProfessorsSections and courses join Query - equiv to 2NFstudentsWenrollreport leading to unnormalized students design3ά%Q&qSections qenrollmentsʾexxxProfessorsSections and courses join Query - equiv to 2NFstudentsWenrollreport leading to unnormalized students design3ά%Q&qSections qenrollmentsv1 Qbid^^`QbmkQufdimkfQMYSYMJmYdbzzzzz z z z zzzzzzzzzzzzz$z% z& z' z( z) z* z+ z, z- z. z/ z0 z1 z2 z3 z4z5z6z7z8z9z:z;z<z=z>z?z@zAzBzCzDzEzFzGzHzIzJzKzLzMzNzOzP}}}}}}}}}}}} }!}"}#}$}%}&}'}(})}*}+},}-}. }/ }0 }1!}2!}3!}4"}5"}6"}7#}8#}9#}:#};$}<$}=$}>%}?%}@%}A&}B&}C&}D&}E'}F'''((()))* * * + + ++,,,---...///00011 1!2"2#2$3%3&3'4(4)4*5+5,5-6.6/606172737485868798999::>:?:@;D;E;<<<===>>> ? ? ? @ @@AAABBBC0C1C2D3D4D5E9E:E;F?F@FAGBGCGDHEHHIIIJJJKK K L}L}L}M}M}M}N}N} N} O} O} O} P}P}P}Q}Q}Q}R}R}R}S S S TTTUUUVVV !"#$%&;<=ABC&&&&Q'Q(Q)U*U+U,[-[.[/a6a7a8m<m=m>zzzz zz zzzz!z"z# qY N66Y Y  Y ~Y Y Y Y Y AttributesDataTypeFieldNameIndexTypeSkipColumn SpecID Start WidthYY Index1PrimaryKeyϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp 2 V2 Vϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp V2 U2 Uϒ8ka,UN t943UU#qh/za)0l]GIX|lҬ/Gp U2 T2 Tϒ8ka,UN t943UU#qh/za)0l]GI,V@i-V@MSysIMEXSpecs2<<<<<<<<<<: V͇fS@͇fS@report leading to unnormalized rooms design2xxxxxxxxxxv UɴʌS@NtьS@Rooms and sections - equiv to 1NF2@<@@||pddddddb `T΋wP@TH{P@simulate bad enrollment design2@@vjj^^^^^^^\ @S8pN@qN@section enrollment counts Query2@ @xll```````^ @GC[@S[@students Query2Z@JJJ>>>>>>>< @v1 kmoOQbmYO2Ydb4kmoOQbmYO2kmoOQbmYO2kmoOQbmYO2idd`'kYxQ(idd`'kYxQ(idd`'kYxQ(vQJivQJizzz$z% z& z' z( z) z* z+ z, z- z. z/ z0 z1 z2 z3 z4z5z6z7z8z9z:z;z<z=z>z?z@zAzBzCzDzEzFzGzHzIzJzKzLzMzNzOzP}}}}}}}}}}}} }!}"}#}$}%}&}'}(})}*}+},}-}. }/ }0 }1!}2!}3!}4"}5"}6"}7#}8#}9#}:#};$}<$}=$}>%}?%}@%}A&}B&}C&}D&}E'}F'''((()))* * * + + ++,,,---...///00011 1!2"2#2$3%3&3'4(4)4*5+5,5-6.6/606172737485868798999::>:?:@;D;E;<<<===>>> ? ? ? @ @@AAABBBC0C1C2D3D4D5E9E:E;F?F@FAGBGCGDHEHHIIIJJJKK K L}L}L}M}M}M}N}N} N} O} O} O} P}P}P}Q}Q}Q}R}R}R}S S S TTTUUUVVV !"#$%&;<=ABC&&&&Q'Q(Q)U*U+U,[-[.[/a6a7a8m<m=m>zzzz zz zzzz!z"z# 2 4 4<5---;AAAf ϭFn̄N  Enrollments Export Specification/:.,'YUSQOMKKKG  Prerequisites Export Specification/:.,']YWUSQOOOK  Rooms Export Specification/:.,'MIGECA???;  Professors Export Specification/:.,'WSQOMKIIIE  Rooms Export Specification/:.,'MIGECA???;  Sections Export Specification/:.,'SOMKIGEEEA  Students Export Specification/:.,'SOMKIGEEEA  CatalogCourses Export Specification/:.,'_[YWUSQQQM 6                  DataTypemx_TblImexColsDataTypemx_TblImexCols.DataTypeVF**  SkipColumnmx_TblImexColsSkipColumnmx_TblImexCols.SkipColumn^J..  IndexTypemx_TblImexColsIndexTypemx_TblImexCols.IndexTypeZH,,  Widthmx_TblImexColsWidthmx_TblImexCols.Widthr  CreditsCatalog CoursesCreditsCreditsbTFA junk ;A junk  Numb Student Workstation Numb Student Workstatio Numb Student Workstatio <grade  2special permission 2special permission511  studentID#  LVAL. NppppacCmdUndosGacCmdInsertLookupFieldrGacCmdCompileLoadedModules!qGacCmdTransparentBorderpGacCmdTransparentBackground"oGacCmdPropertiesnGacCmdTileHorizontallymGacCmdDocumenterlGacCmdAnalyzeTablekGacCmdAnalyzePerformancejGacCmdDatasheetViewiGacCmdFor8JacDataAccessPageBrowseGacCmdMicrosoftScriptEditor"GacCmdSaveAsDataAccessPage!GacCmdDemoteGacCmdGroupByTableGacCmdPromoteGacCmdDataAccessPageDesignView%GacCmdEditTriggersGacCmdConnectionGacCmdDiagramDeleteRelationship&GacCmdDiagramNewTableGacCmdDiagramLayoutDiagram!GacCmdDiagramLayoutSelection#GacCmdDiagramAutosizeSelectedTables*GacCmdDiagramRecalculatePageBreaks)GacCmdDiagramViewPageBreaks"GacCmdDiagramModifyUserDefinedView)GacCmdDiagramShowRelationshipLabels*GacCmdDiagramAddRelatedTables$GacCmdDiagramNewLabelGacCmdZoomSelectionGacCmdViewTableUserViewGacCmdViewTableKeysGacCmdViewTableColumnProperties&GGacCmdRemoveGacCmdHidePaneGacCmdViewTableNameOnlyGacCmdViewTableColumnNames!GacCmdQueryAddToOutputGacCmdQueryGroupByGacCmdViewVerifySQLGacCmdViewShowPaneGridGacCmdViewShowPaneDiagram GacCmdViewShowPaneSQLGacCmdViewViewsGacCmdViewStoredProcedures!GacCmdViewDiagramsGacCmdViewFieldListGacCmdNewObjectDiMR2ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlacesu ` XRooms.size DESC, Rooms.[Front Computer] DESCroom   T Lunique identifier for room e.g. at134    msize    capacity  Capacity  20    >5N F"We dont have any rooms that small" m"Front Computer   t lwhether there is a computer up front for the professor Yes/No  No   j~$Data Connection    Yes/No  No   j|"Data Projector    Yes/No  No   jdOverhead    Yes/No   j82Numb Student Workstations   l dnumber of computers in room for studets to work at   0   mLVAL} HFD8GF8j p~?#G8GG$GGG <hGGGGRGGGHGGGG@GxGGxGxGxG(G`G`G`GhGGGGRGGG     <         'Catalog Courses.DeptCatalog Courses-Catalog Courses.Course#)Catalog Courses.Title)enrollments.sectionIDenrollmentsSections.timeSectionsSections.room#Sections.professor G G GGG.PA@@G`G 0GHG G0GGG hG0 G0 G0 G0 RG0 G0 G0!Catalog Courses GX G GGGagnN@Sections G   G GhGGN@studentsG  hGhGGzNtN@enrollmentsGGG@GG' QN@schedule Query`GHG0GG G G G G G0 G G8 G @G@ G xGH G GP G+[Catalog Courses].Dept G5[Catalog Courses].[Course#] G-[Catalog Courses].Title GG@GxGG hG0?G0G0Catalog Courses G G G G $ G G G G G?RG0olmG0 G0D Sections RGPG GXG G`G@GxGGstudentsG0enrollments GGGGGG`GGG3[What is your first name?]G1[What is your last name?]GPG Gp(GG G8GXGxGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG(G9G(G GG GG GG G@G GhG GhG GhG Gz Gp#G7GG@#G"Gp4`GpGGGGG GGz  G88G G!G8GG0GGz PGx"G8GhG"G!G"G5HGPGXGGGGG pG G <G  G PG G GD(pGxGGGGGGp"G"G8#GpGGGGPGGG GhG@GCatalog Courses G 0G @GPrimaryKeyDept Course#Sections  G   G 0 G P G ` G   G  G  GtimesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catals @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @Jr8Jr9Jr:Jr;JrJ r?J r@J rAJ rBJ rCJtJtJtJtJtJtJtJtJtJt Jt Jt Jt Jr1Kt KtKtKtKtKtKtKtStSt0St1St2St3St4St6St8St:StSt@StBS tDS tFStGS t5S t7S t9S t;S t=S t?S tAS tCS  tES tHStTtITTTTTTTTT T T T T  T T T T TTtJUU#U$U%U&U'U(U)U*U+U,U-U.U /U 0U 1U2U4U 3UW5WGWHWIWJWKWLWMWNWOWPWQWRW SW TW UW VW WWXW6YYYbYaY[Y\Y]Y^Y_Y`YZ\c\i\j\k\\\\\\\\\\  \  \  \  \  \\\ \ \d^^&^'^(^)^*^+^,^-^.^/^ 0^_1_M_N_O_P_Q_2_2_2_2_2_2_2_2_2_2ParentId = 251658241 and Type = 6 and Connect Is NullLVAL<V P L ` : og CoursesSectionsenrollments `!G !G  !G  !G !G%studentsenrollmentsstudentID%SectionsenrollmentssectionIDPrimaryKey hG"GG  @G("Gp"G  hG 8"GPrimaryKey G"G"G  8#G  hG "GhG #G hGP#GpG  xG  PrimaryKey#GGv *G*GGv /GX/G1GGv 1G1G4GGv X4G 4GH6Gs 0Gp(Gp(Gqp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(Gp(G6G G 7G`6G )GG*G05GGX*G3GG-Gp0GstudentsG$G G$G G$G *GG*G`+G(+Gp+G+G+G+G+G *Gstudents.First+G G43[What is your first name?]<,G+G+G+G+GH,GG $G,G,G-G-GLast  x-G$-G G21[What is your last name?]|-G -G(-GX,G-G h,G-G-G-G-G G$G-G8,Genrollments%studentsenrollmentsG(%G G(%G G(%G/G-G/G@0G0GP0GG (%G0G1G 1G01G%studentsenrollments  *GD1G p0Gl1G@1GH1G`0G%studentsenrollmentsSectionssectionIDG@&G G@&G G@&G G@&G1Gx1G2G2GP2G2G2G2GG @&G3G 3G3G3GsectionID  /G3G 3G3G3G3G2GsectionIDCatalog CoursesPrimaryKeyGX'G GX'G GX'GX4G3G4G5G4G5GG X'G5G 5G5G5G"PrimaryKey 2G  P2G6G 05G,6G6G6G 5GPrimaryKey4G2G0G4G2G0G@@@Gp(GGp(GGp(GGp(GGp(GGp(G 7G86GX7Gp8G7G8G7G8G8G8G88G8G7G8G8G8G88G8G GhG@GK&[z2P  I(winspool\\ADM-SRV1\O126-HP4100IP_172.25.41.156d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4*Dept & ", " & Course#timesectionID`ReportHeaderwB8 hd25`<a<bScdLabel14junk sched?n0X;K+f23a<b2 Line17F1)J9!ʽ`"PageHeaderSection٪=C|N@] d5`<a<bc,Dept_LabelDeptDetachedLabel ؍J=r$d5`Ta<bsc,Course#_LabelCourse#DetachedLabelCourse__Label]4lI_但ҥd5` a<b c,Title_Label TitleDetachedLabelWxB EZF)d5`a<bc,time_LabeltimeDetachedLabel#'\CMx! d5`a<bc,room_LabelroomDetachedLabel(@jKyNd5`H!a<bc,professor_LabelprofessorDetachedLabel"5EHePd5`&a<b c,sectionID_LabelsectionIDDetachedLabel %o0cFFfyf23b2 Line18Y-M=K?f23ab2 Line19 ^4o# I]0rT`GroupHeader0|~Oaώm7<`<bchei jDeptDeptTimes New Roman(FG]rMh= om7<`Tbschei jkCourse#Course#Times New RomanCourse_jNnJm7<` b che i jk Title TitleTimes New RomanQ)0p3Exn`aGroupHeader1rE n(@Qsm 7<`bcJeti timetimeTimes New RomanI7|N/E::m 7<`bcJei kroomroomTimes New RomanvuLQA9::m 7<`H!bcJei kprofessorprofessorTimes New Roman )2^@HNZ _`J Detail,|Ju^o`bc&e fZ"";"";"";"";"";"";"";"";"";"";"";"";"10";"10"c2n>oLݰ/X?sectionIDsectionIDTable/Query<SELECT DISTINCTROW [Sections].[sectionID], [Sections].[Dept], [Sections].[Course#], [Sections].[Section], [Sections].[Sem], [Sections].[Year] FROM [Sections];.975;61) LVAL  @ @ @ @ @ @ @ @ @ @ @ @Jr8Jr9Jr:Jr;JrJ r?J r@J rAJ rBJ rCJtJtJtJtJtJtJtJtJtJt Jt Jt Jt Jr1Kt KtKtKtKtKtKtKtStSt0St1St2St3SMR2BValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListQ < 4enrollments.sectionID DESCm*$special permission       mMR2BValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListQ < 4enrollments.sectionID MR2BValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListQ < 4enrollments.sectionID DESCm*$special permission       mS grade       m[studentID       m=sectionID       o Table/QueryD <SELECT DISTINCTROW [Sections].[sectionID], [Sections].[Dept], [Sections].[Course#], [Sections].[Section], [Sections].[Sem], [Sections].[Year] FROM [Sections];   6 .975;615;870;810;525;555  4350twip LVAL_(=hD y   ,?0y  y ( y y   y y y 2y Ry ry y y y y y y y y @y `y y y y y y y y y y y y y y y y y! y 2y Ry ry y y y y                (   %students.Student IDstudentsstudents.Firststudents.Middlestudents.Laststudents.Yearstudents.Major5students.Num Credits Earnedstudents.GPA!students.Hometown'students.Balance Duey  y  y y  0y z@y y ,","y 0,"y 0,"y 0,"2y 0,"Ry 0,"ry 0,"y 0,"y 0,"y 0,"!y 0," students y    y  y  y 0y zNtN@~sq_fstudentsy  y y  y y y y  y y  @y y  `y y  y y  y y  y  y  y  y y y y  y @y `y y y y y y 0 y 0 y 0 2y 0 Ry 0ry 0y 0 y 0b3y 0Hy 0 students y y  y y  y y  2y y  Ry y  ry y  y  y  y  y  y  y  y y y y y  y @y `y y y y y  y y y 0y 8y `y y y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y ( y y xy 0y y Hy y  Hy y  Hy y  Hy y  Hy y  Hy y  y y  y y  Hy y  y y  y z Py y hy Xy y (y 8y `y Hy y Xy y hy y xy @y y xy y y y y y  y  (y  `y  y  y  y @y xy  (y y P(y y y y y y (y 0y 8y @y y (y `y y y y @y xy y y  y students y  y  y  y   y YearStudent IDPrimaryKey MajorLast8y y v Xy (y @y y y yq y y y y y y y y y y y y y y y y y y y y y y y y y y y y y  ( y y y y y studentsPrimaryKeyy y Xy y Xy y y y y y y  y LVALhD  S  N-?  @     p     P    0 0 0 0 0   p         <    'Catalog Courses.DeptCatalog Courses-Catalog Courses.Course#)Catalog Courses.Title5Catalog Courses.Description-Catalog Courses.Creditsp h  8   ?@H h   ( p ( ( (  (!Catalog Courses      agnN@'~sq_fCatalog Coursesh  x  P            P      ( p ( (S, (  (!Catalog Courses    p    (   0   8  P          8 P h   @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @  @     H   H   H      $    z h   `h  @ 8 x H   X  h    @  <x    <8 @ H P X  @ x     Catalog Courses      PrimaryKeyDept Course#  v 0     q                               @  x  % Catalog CoursesPrimaryKey  0 x 0    h     K&[5;870;810;525;555`"PageFooterSectionzN&53m 7;<`<abc,i j Text15 =Now()Long DateTimes New RomanE7B5m 7;<`abc,i jk Text16H="Page " & [Page] & " of " & [Pages]Times New Romanb-iLJ4T#-`ReportFooterpHFOxtm*KLMNPQRSTUVWXY[\]^`btachdefgikjlpmnoqsruzvwxy{|}~5C0* pHd university4@j = r > J< ADAO>BDAO *\G{00025E01-u0C  0046}#5.0#0#C:\PROGRAM FILES\COMMON MICROSOFT SHA0RED\w350.DLL#Microsoft  3.51 Object Li`braryHUstdole>fstdoPle^f\c^043[W-^2^WINNT\System32\12.tlb#OLE Automation/ VBIDE>VBIPDECÀCE157C5.3P\\Bc-srv1\PUBLIC\OFF0ICE2@ V\PFiles\Common\MSShared\VB A6E6EX T.OLBTVisual Basic for A pplic2s Extensibtil !- @Form_mainGA]rm_ainHAVTPFCOJAWTPDFCEFNJMIMEMKLJ28AVTPFCOJWDBE@N@ MTMTMKFLAH@1µ% B,+"B(B+B0studentTasksG VF2ue3t$ask6OBMAVLIDOFSODAHMCNIEIODPONC6OM7jLƒO2S8HTM;NEO5@P@N`aFacultyFacDudtyAOGTLGLWSKDIHEUKBTZD_JAHOXZOBGLDG 1WS 2DUH3U`B`Z_4A 4OZm@BA+6-6%6Deans5D~a`5sk5QPWRRHJBCGVTXDNCFZVSNLGICNTLCQ6pPjPjBlob &=TypeInfo8pPropData78'̔p͔Blob TypeInfoR&PropDataQ5lr6L6LBlob (PropDataqsTypeInfooDirDatau6PropDatagScripts[z6L6L0x6L6L3`j@L@LBlob *X LVALh άy0Professorsstudents}LVALN˪˪˪˪˪ˌ n F  j ' H 9ǝǝǝǝǝǝǝǝǝǝǝǝǝǝǝa3Jd+ktVWYSections!!! Y[Sections].[Year]0 gY[Sections].[Sem]/ gY[Sections].[Section]3FD/ s ` }? P `"bPp888888"b           #Sections.sectionIDSectionsSections.DeptSections.Course#Sections.SectionSections.SemSections.Yearph( -~@@X"؀ab؀G؀"G؀5H؀GX؀GSectionsX  @N@9~sq_djunk sched~sq_dsectionIDX   @ Hx  +[Sections].[sectionID]![Sections].[Dept]'[Sections].[Course#]'[Sections].[Section]H[Sections].[Sem]![Sections].[Year] "؀ab؀7G؂؀G"؀GG؀؀G Sections "  b         H hX8Ph                                    z 8XPXX8p(8     8 p@ (8pSections     8 H  p   timesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catalog CoursesSectionsv hhqhhhhhhhhhhhhhhhhhhhhhhhhhhhhH X8PSectionsPrimaryKeyPHhX(XLVALlphDK3S 3S P,?C S ( C  ?@ABCDE[IJKLMNOPSTUVWXYZ^_`abcdefghijklmnopqr5Catalog_Courses_DeptCatalog Courses_Deptm6Catalog_Courses_Course_Catalog Courses_Course#m7Titlem8Descriptionm9Credits:PageFooterSectionm;Text51m<Text52=ReportFooterjunk rosterjunk schedbreport leading to unnormalized students design3breport leading to unnormalized students design2"All EnrollmentsHCount Of Enroll By Dept and CourserosterX 6CB0 3CB0 2CB0 1CB0 0CB0 5CB0 4CB0 7CB0 8CB0 22fill the whole screenopen main menumain0-10  lLJI3Ld`8a<bc,,SectionAutoExecBackToMainCoursesfindstd,Sections_Course__ 3CB0 2CB0 1CB0 0CB0ection_LijnDetachedLabel=ۛQNMSysDbSem_LabelSemDetacheScheduleZreport leading to lSections_YearDetacOverheaddOverhead_LabelmNumb_Student_WorkstationsNumb Student WorkstationsdNumb_Student_Workstations_LabelNumb Student Workstations_Labelmtimedtime_LabelmsectionIDdsectionID_LabeldLabel18mText19mText20fLine21fLine22fLine23SemYearunnormalized rooms design>Rela  MajordMajor_LabeldLabel14mText15mText16fLine17fLine18fLine19mText20sectionIDLine19 tionships for UNIV2000new PropaͬOĜ~kI̡ ěPageHeaderSectionDetailPageFooterSectionfLine0fLine1gImage2gImage3fLine4fLine5f Line6g Image7g Image8f Line9f Line10fLine11gImage12gImage13f+K&[N  Line14fLine15fLine16gImage17gImage18fLine19fLine20fLine21gImage22gImage23fLine24fLine25fLine26gImage27gImage28f Line29f!Line30f"Line31g#Image32g$Image33f%Line34f&Line35f'Line36g(a<bVc, Student ID_LabelStudent IDDetachedLabel Student_ID_LabelG4@-\1d`a<bc,Middle_Label MiddleDetachedLabel"}3NF=m`bcek Middle Middle,Student Middle Initial /E+4Enz io09bce fhvnzeMH$n:jYearYearValue List4"Fr";"So";"Jr";"Sr";"Grad"1440LStudent Academic Year (Fr, So, Jr, Sr)m`%bVcek Major MajorStudent MajoraA^T`"PageFooterSection LVO3m ;<`<abc,i j Text15 =Now()Long DateTimes New Roman{1`(C̈2lm ;<`abc,i jk Text16H="Page " & [Page] & " of " & [Pages]Times New RomanO`ΐaO]J`ReportFooter:2M[M `5CustomGroupsImage37g)Image38f*Line39f+Line40f,Line41g-Image42g.Image43f/Line44f0Line45f1Line46g2Image47g3Image48f4Line49n5ecl0d6ecltitle0n7ecl1d8ecltitle1n9ecl2d:ecltitle2n;ecl3d<ecltitle3n=ecl4d>ecltitle4n?ecl5d@ecltitle5nAecl6dBecltitle6nCecl7dDecltitle7nEecl8dFecltitle8nGecl9dHecltitle9nIecl10dJecltitle10KReportHeaderLReportFooterdMLabel72dNLabel73Q6pPjPjBlob &=TypeInfo08:<=Babc,,K&[ @ @(e gJ;@:Relationships for UNIV2000new Arial8,(hEPSON Stylus Photo 785EPX`f odhh0RL*** xhhDLLName32=E_DU12SE.DLL d 2EPSON Stylus Photo 785EPX  ***E-winspoolEPSON Stylus Photo 785EPXUSB001d2 Tahomag37n Tahoma`ReportHeader9H8vdbh ceLabel72:Relationships for UNIV2000newޫmMʊdabH cLabel738Wednesday, December 10, 2003h\hC$(=`"PageHeaderSectionNٽK<{$` DetailXΆAyŽ=f23` ab Line0ʧg`0 a[bc< Image3x( P@@@@@@@-K&[ @ @ @ @ @ @ @@@@@@@@Ɂ_C@f` abc$ Line4mYT\[Is f23` ab Line59'@af23`afb Line6QsGg`abHc` Image7h(@@@@@@@@@@@@@@@.K&[HF@F,;g`0 a'bc< Image8x( P@@@@@@@@@@@@@@b6=B[XW=Vf` arbc$ Line9ozF-f23``aVb Line10XaNnD9Ha;f23`ab Line114߰EIfg`a"bHc`Image12h(@@@@@@@@@@@@@@@/K&[)>OeFY/Yg`xabc<Image13x( P@@@@@@@@@@@@@@aOcP,f`abc Line14:?bHإUf23``a"b Line15MXmG_ f23`a~b Line16y^3j BI3 C?8g`abHc`Image17h(@@@@@@@@0K&[@@@@@@@.I1Hb5 v4g`xabc<Image18x( P@@@@@@@@@@@@@@u ߛ 2HnYf`abc Line19ՈxEFLS^f23`ab Line20%M4E 1f23`ab Line21X] Ceνg`a bHc`Image22h(@@@@@@@@1K&[@@@@@@@`{k"B@ C%g`asbc<Image23x( P@@@@@@@@@@@@@@2K&[6XJc]f` ab( c< Line24v33H3}if23`ab Line25*,wUU@E+f23`afb Line26wI_FLd@tAg`abHc`Image27h(@@@@@@@@@@@@@@@qt G3dg`a?bc<Image28x( P@@@@@@@@@@@@@@3K&[d _ Z 7 T  _ } }{*R Yg=*e3Ac{Of` arb( c< Line29ԃ)Mhf23`pajb Line30(7zO{ff23`azb Line31XFn"E=ONg`abHc`Image32h(@@@@@@@@@@@@@@@$F)M Mp+# $g`abc<Image33x( P@@@@@@@4K&[{hUB/A S @ ,  |  B /   l Y @@@@@@@ݢSENr57f`$avbc Line34`oJoEy3xf23`pab Line35 woD'vf23`@a b Line36pyEQ~u:ig`da bHc`Image37h(@@@@@@@@@@@@@@@(Ra$L%,>g`a;bc<Image38x( P@@@@@@@5K&[,Z ) _ @ ~ ! [.n?{*t!s@@@@@@@¡Fpgf`$a bc  Line39H]~EOyB ާBf23`afb Line40CjKu@f23`a b Line41\[tFYSd}g`az bHc`Image42h(@@@@@@@@@@@@@@@6K&[NnnY_PKsf23`a. b Line46츌0DYBg`a bHc`Image47h(@@@@@@@@@@@@@@@7K&[v1b FNkG%_g` a7bc<Image48x( P@@@@@@@@@@@@@@>·GlQ f`a: bcl Line49wKCVf;n03ab@cd ecl0Value Listf"Dept";"Course#";"Title";"Description";"Credits";""ݿKKWwEd235 `ahbcecltitle0Catalog Courses󨔶M8Ɏn03aP b@c<dXlecl1Value Listn"studentID";"sectionID";"special permission";"grade";""YBG)eGd235 `P ah b<cecltitle1enrollments{{X̅@fEhn03a`b cdp lecl2Value List"sectionID";"Dept";"Course#";"Section";"Sem";"Year";"time";"room";"professor";"stop point";"junk";""u PIذ;0d235 ``a 8K&[vcO<)   x e R > +  {  g T A -bcecltitle2Sections ,?L ުp#n03ahb cd lecl3Value List"Student ID";"First";"Middle";"Last";"Year";"Major";"Num Credits Earned";"GPA";"Hometown";"Balance Due";""IpJՃ d235 `ha bcecltitle3students=K`gkn03a bdcd(lecl4Value ListL"Prog";"Class";"PreProg";"PreClass";""$}|JpAd235 ` abcecltitle4PrerequisitesYmYGLs6oln03ab cdlecl5Value Listh"Name";"Dept";"Position";"office";"phone";"email";""ѯ/&E7Ld235 `aHbcecltitle5Professorsf4hKKjn03ab8 cdlecl6Value List"room";"size";"Front Computer";"Data Connection";"Data Projector";"Overhead";"Numb Student Workstations";""j.>tH5#d235 `a` bcecltitle6 Rooms4CXK[~rên03adbXcdlecl7Value Listf"Dept";"Course#";"Title";"Description";"Credits";""6#]H=4!R=d235 `dabcecltitle7"Catalog Courses_1ntoL3̇Mn03ab@cdlecl8Value List"sectionID";"Dept";"Course#";"Section";"Sem";"Year";"time";"room";"professor";"stop point";"junk";""8˵JT#Iu=7d235 `ahbcecltitle8Sections_1'J+On03a#bcdl ecl9Value List"sectionID";"Dept";"Course#";"Section";"Sem";"Year";"time";"room";"professor";"stop point";"junk";""ePRMDZ({=d235 `#abcecltitle9Sections_2<0jLCn03ahb@cdl ecl10Value List"sectionID";"Dept";"Course#";"Section";"Sem";"Year";"time";"room";"professor";"stop point";"junk";""&`%I*ԮH#d235 `hahbcecltitle10Sections_3>nͣ(F䌑`1`"PageFooterSectionNJ `G1`hReportFooter J {EB^({OWR HB0GRXa2F@VNG@(CN LP io5+PEPsWenrollGFUPsWn4rl@8QGTFPSECFHBBSDEHZPEPGNKDDXUTK#6FS4jCPH`SB HUPP:N9DPXU K0Sҍ6q/ qxME 9K&["am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB#Microsoft Access 11.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO350.DLL#Microsoft DAO 3.51 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINNT\System32\stdole2.tlb#OLE Automationh*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#\\Bc-srv1\PUBLIC\OFFICE2000PRO\PFiles\Common\MSShared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3 >8HAVTPFCOJAWTPDFCEFNJMIMEMKLJ024459f5a4Form_main% 8HOBMAVLIDOFSODAHMCNIEIODPONC034459f5a4C"Form_studentTasksa8AOGTLGLWSKDIHEUKBTZD_JAHOZOB044459f5a4["Form_FacultyTasks08QPWRRHJBCGVTXDNCFZVSNLGICNTL054459f5a4cForm_DeansTasks+H 8GTFPSECFHBBSDEHZPEPGNKDDXUTK064459f5a4k(Form_studentsWenrollq`x0H`,I>7;1ZpsEd5d]_BeM&(b@M-ۊ{/h I=;E<>D.AccessVBAWin16~Win32MacVBA6# university.DAOstdole`VBIDEA Form_mainN _EvaluateChooseStud_ClickErr_ChooseStud_Click. stDocNamezstLinkCriteriaYDoCmdƧOpenFormExit_ChooseStud_Click4MsgBoxRErro Description PickStud_Click Err_PickStud_ClickIExit_PickStud_Click PickFac_Click|Err_PickFac_Click,Exit_PickFac_ClickaKPickDean_ClickErr_PickDean_ClickOExit_PickDean_ClickPickAdmin_ClickCErr_PickAdmin_Click:aExit_PickAdmin_ClickForm_studentTasksaSeeSched_Click0Err_SeeSched_Click OpenReport acPreviewoExit_SeeSched_Click+ Back_Click/Err_B: LVAL    MR2ODBCTimeoutMaxRecordsColumnWidthColumnHiddenRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <     C("[students].[Last]  K0*[students].[Hometown]  Q60[students].[Balance Due] U S82[enrollments].[sectionID]  eJD[enrollments].[special permission] G K0*[enrollments].[grade]  MR2AccessVersion Build6Track Name AutoCorrect Info0Perform Name AutoCorrectCpgConversionProjVerZ 08.50 6    #MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC <     MR2ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlacesOrientation$UnicodeCompressionJ  , $Sections.room DESCsectionID   " Section Index   2 *>"00000" And <"99999"P H"Section ID must be 5 digit numeric" m `Course#       m MR2ODBCTimeoutMaxRecordsColumnWidthColumnHiddenRecordLocksRecordsetType FilterOrderByOrderByOnOrientation: <     C("[students].[Last]  K0*[students].[Hometown]  Q60[students].[Balance Due] U S82[enrollments].[sectionID]  eJD[enrollments].[special permission] G K0*[enrollments].[grade]  MR2AccessVersion Build6Track Name AutoCorrect Info0Perform Name AutoCorrectCpgConversionProjVerZ 08.50 6    #MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC <     \LVALl ME s  J ' ʈssȦ*]PXAA\ FEѳ@FEѳ@Admin*********** [B@B@Relationships for UNIV2000new2\\\\\\\\\\Z AEXN@0fN@junk enrollments not 2002 Query2@@xll```````^ @<_O[@_O[@enrollments Query12Z@|RRRFFFFFFFD @8k;@k;@~sq_fstudents124MR2ά zD 9Catalog CoursesCatalog Courses]enrollmentsenrollmentsstudentsstudents  PrerequisitesPrerequisitesMProfessorsProfessors+Catalog Courses_1Catalog Courses{7RoomsRooms0SectionsSectionsulSections_1SectionsTxSections_2Sectionsz,Sections_3SectionsLVALtudents].[Num Credits Earned] [students].[GPA]@ )[students].[Hometown]p /[students].[Balance Due] 1[enrollments].[studentID] 1[enrollments].[sectionID]( C[enrollments].[special permission]h )[enrollments].[grade] +[Sections].[sectionID] ![Sections].[Dept]( '[Sections].[Course#]X '[Sections].[Section] [Sections].[Sem] ![Sections].[Year] ![Sections].[time]( ![Sections].[room]X +[Sections].[professor] -[Sections].[stop point] /[Catalog Courses].[Dept] 5[Catalog Courses].[Course#]8 1[Catalog Courses].[Title]x =[Catalog Courses].[Description] 5[Catalog Courses].[Credits]  x  x   x   x   x Dept Course#Catalog Courses                   Dept8 Course#x     x   x   x  x  x   x B  x b  x   x   xsectionIDDept Course#YearSections h# `#  # #  # #   #   #  # #  B  #  b  #   #   #  sectionID( DeptX Course#   Year( X   r x  x  x  x $ x B x b x  x  x  x Yearstudents r &   &   &   &  & &  B '  b '   '   '   '   8 h  Year  @ p   x h' x  x  x sectionIDenrollments  h(  x( p(   (   (  ( sectionIDh    H 9   8  (   (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (  (   S @< 'H 3  H 3  H 3  H 3  H 3  H 3   3   3  H 3   3  H x5  H x5  H x5  H x5  H 6  H 6  H 6  H 6  H 6   6  H 6  H 6  H 6   6  H 8  H 8  H 8   8  $ 8   z @ @B S LVAL@  B A  h- - 4 - 4 . 4 H. 5 . 5 . (5 . 85 (/ H5 `/ X5  z @ 8S @ A p / h5 / 6 0 6 @0 6  z p> B R > hB B B  x0 6 0 7 0 7  1 8 X1 8 1 (8 1 88 2 H8 82 X8 p2 h8  z = C R = B B   2 x8 2 9 3 9  P3 9 3 9  h-  -  -  .  H.  . . .  ((/ `/  /   /  d0  @0   x0  0  0   1  X1 1  1  2  82 p2  2  2  <3  P3 3 t< < < < = = = = = (= 0= 8= @= H= P= X= `= h= p= x= = = = = = = = = = h- - - . H. . . . (/ `/ / / 0 @0 x0 0 0  1 X1 1 1 2 82 p2 2 2 3 P3 3 -8 6 3 x5 Catalog Courses 8>  P>  `> PrimaryKeyDept Course#Sections (?   8?  P?  p?  ?   ?  ?   ? timesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catalog CoursesSectionsstudents @  @  @  @  @ YearStudent IDPrimaryKey MajorLastenrollments `A  A   A   A  A %studentsenrollmentsstudentID%SectionsenrollmentssectionIDPrimaryKey 3 B  6 XB 0=   x5 0B <   Student ID8=   x5 xB P=   PrimaryKey 8 B X=   `=   6 B =   =   PrimaryKey C  v HJ 0J  v K J M  v hM 8M O  v O O Q  H Hq H H H H H H H H H H H H H H H H H H H H H H H H H H H H PR  ( R R XI  I P  I N  C K studentsH C   C HJ 9 J J enrollments%studentsenrollmentsH D  H D   D K J PK K K K  D pL L L L %studentsenrollments( HJ L  LVAL% K L L L K %studentsenrollmentsSectionssectionIDH E  H E  H E   E hM M M HN M XN N hN  E O  O (O ]] Admin=K&[Tasks'   B@ @|x>p &!(A@$@XoPHZAttribute VB_Name = "Form_main" " Bas0{A9CE5C84-9C1B-11D3-9E07-00509508 298F} |GlobalSpacFalse dCreatablTru Pre declaId"Expose_TemplateDeriv%CustomizD$Option Comp@ D3T   LVALq qqqqqqqqqq` ````` MR2(ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlacesOrientation$UnicodeCompressionDefaultViewIMEModeIMESentenceModeSmartTagsS  , $Sections.room DESC sectionID   " Section Index   2 *>"00000" And <"99999"P H"Section ID must be 5 digit numeric" m   rCourse#       m   Section <   "01"   & >"00" And <"99"N F"Section must be two digit numeric" m   ltime t      m   lroom       m   vprofessor       m   stop point    $ Max Enrollment  25    >10 And <100L D"Invalid Stop Point - enter 11-99" mlDept       m    Sem   & F S Su semester    m "S"   #Year (  N Fyear offered - use 4 digit notation  2007  & >1954 And <2350N F"I dont think this year is correct" m5junk   MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationDefaultViewUseTransactionFailOnErrorU <         MR2ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC <     MR2ODBCTimeoutMaxRecordsColumnWidthColumnHiddenRecordLocksRecordsetType FilterOrderByOrderByOnOrientation <  j b[simulate bad section enrollments].sectionID DESC   S82[enrollments].[studentID]   eJD[enrollments].[special permission] e K0*[enrollments].[grade]  LVAL!hD,7 $, @--?!7 ,7 X7 !7  <427 r7 7 7 7 7 "7 B7 b7 7 7 7 @7 4 7 `7 7 7 7 7 7 07 P7 x7 7 7 (7 4H7 H7 H7 H7 H7 H7 H7 H7 H7 H7 7 7 7 427 r7 7 7 7 7 "7 B7 b7 7 7 7 @7                       d   #Sections.sectionIDSectionsSections.DeptSections.Course#Sections.SectionSections.SemSections.YearSections.timeSections.room#Sections.professor%Sections.stop point)enrollments.studentIDenrollments;enrollments.special permission!enrollments.grade0 7  ( 7  7 7 P7 >@,7 (7 ,,7 7 ,,27 (,r7 (,7 (,7 (,7 (,7 (,"7 (,B7 (,b7 (,Q7 (, 7 (, 7 (, @7 (, Sections 7    7  7 7 P7 a³@enrollmentsp7 (7 X7 7 P7 @?simulate bad section enrollments(7 7  7 7  `7 7  7  7  7  7  7 7  7 ( 7  7 0 7  07 8 7  P7 @ 7   H 7 x 7  7 7  7 7  (7 7  7 `7 #Sections.[Course#] 7 7 7 7 7 07 P7 )Sections.[stop point]H 7 7 ?enrollments.[special permission] 7 (7 27 ( r7 ( 7 ( 7 ( 7 ( 7 ( "7 ( B7 ( b7 ( 7 ( Sections 27 7  r7 7  7 7  7 7  7 7  7 7  "7 7  B7 7  b7 7  7 7  7 `7  7 7 7 7 7 07 P7 H 7 7 ( 7 ( @7 ( enrollments 7 @7 7 H7  @7 P7 7  7 (7  7 #7 7 P7 87 p7 7 7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 X7 7 7 ,7 7 H7 7  H7 7  H7 7  H7 7  H7 7  7 7  H7 7  H7 7  H7 7  7 7  H7 7  H7 7  H7 7  7 z 7 !7 `+7 7  7 7 (7  7 X7 7 7 7 7 07 7 @7 87 P7 p7 `7 7 p7 7 7 7 7 7 z h7 +7 7  7 h7 P7 7 7 7 7 7    7  X7  7  7  7 87  p7  7  7 LVAL7  P7  d7  7 \8h7 p7 x7 7 7 7 7 7 7 7 7 7 7 7  7 X7 7 7 7 87 p7 7 7 7 P7 7 7 7 7 Sections 7   7  7  7  7   7  (7   87 timesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catalog CoursesSectionsenrollments 7   7   ( 7   P 7  h 7 %studentsenrollmentsstudentID%SectionsenrollmentssectionIDPrimaryKey 7 7  7   7   7  7 7 h7   PrimaryKey !7 7 v )7 )7 )7 7 v *7 X*7 p*7 7 #7 #7q #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 #7 @+7  X7 `+7 +7 (%7 7 !7 "7 enrollments%SectionsenrollmentsH7 !7  7 !7 )7 7 *7 8*7 SectionssectionIDH7 "7  7 "7 *7 H*7 *7 *7 *7 *7 7 #7 7 #7 `+7 +7 +7 +7 `+7 +7 +7 +7 7 7 LVALʾexxxCatalog CoursesCountOfEnrollByCourse QueryentsstudentsWenrollreport leading to unnormalized rooms designCreate data access page in Design viewAutoExec^3 LVALЄ  άLC&xSectionsάLC&xSectionsάL&xRoomsLVALhD ;. e P?;; ;`; <T;|;;;;$;D;H;p;;;;;8;`;`;`;`;`;`;`;T;|;;;;$;D;        Rooms.room RoomsRooms.size'Rooms.Front Computer)Rooms.Data Connection'Rooms.Data ProjectorRooms.Overhead=Rooms.Numb Student Workstations;;H;;x;Vl@;; T;hJ |;hJ ;hJ ;hJ ;hJ $;hJ D;hJ Rooms;X;;;x;l@temp Rooms Query; H;H; p;P; X;; ;; ;; ;; ;P;H;p;+Rooms.[Front Computer]X;-Rooms.[Data Connection];+Rooms.[Data Projector];;ARooms.[Numb Student Workstations];T;hJ |;hJ ;hJ ;hJ ;hJ $;hJ D;hJ Rooms T;H ; |;P ; ;X ; ;` ; ;h ; $;p ; D;x ;H;p;X;;;;; ;x;X; x;8;X;x;;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;; ;;(;;;H;; ;; ;; ;; ;; ;; ;; ;z x;;;J;H;;;;;;;(;;`;(;;8; H;;;;(;`;;D8;@;H;P;X;`;h;H;;;;(;`;;; Rooms ;  ;roomPrimaryKey;;v ;;;;x;xq;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;x;; ;;;;`;RoomsroomH;`; ;`;;H;(;`;(;;x;;p;;;;LVAL whD @C L  ?0@ @@@ <,@*@J@r@@@@@@B@j@,@@8@`@@@@@@0@X@+@@@@@@@@@@@,@*@J@r@@@@@@B@j@                     #Sections.sectionIDSectionsSections.DeptSections.Course#Sections.SectionSections.SemSections.YearSections.timeSections.room#Sections.professor%Sections.stop pointSections.junk0@  (@ H@@x@Nkl@@ @ @hJ*@hJJJ@hJr@hJ@hJ @hJ @hJ @hJ@hJB@hJhJ j@hJ Sectionsp @    @X @8@x@l@3temp update Sections Query @ p @ @ @ @ @ @ @ @ @ @ @ @  @( @ 0 @@ @ H @` @  h @ @  @ @[sectionID]p @ [Dept] @[Course#] @[Section] @ [Sem] @ [Year] @ [time] @ [room]0 @[professor]H @[stop point]h @ [junk] @ @hJJ*@hJroJ@hJsir@hJFr@hJmp@hJDa@hJne@hJDa@hJjeB@hJOv j@hJ Sections @ @ *@ @ J@ @ r@ @ @ @ @ @ @ @ @ @ @ @ B@ @ j@@p @ @ @ @ @ @ @0 @H @h @ @ @@@ x@8@h@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@0@@ H@8@ H@8@ H@8@ H@8@ H@8@ @8@ H@8@ H@8@ H@8@ @8@  @8@ `@z @@@J @@@P@@@`@x@p@@@@@ @@X@@@@@@@@  @ @ @@ x@ @@  @ X@ @@@T,@@H@P@X@`@h@p@x@@@@@@@@x@@@ @X@@@@8@Sections X@  h@ @ @ @  @ @  @timesectionIDRoomsSectionsroom#ProfessorsSectionsPrimaryKeyDept-Catalog CoursesSections8@@v X@(@@@@LVAL@q@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@SectionsPrimaryKey@@X@@X@@@@@@@8@a @ @ @ @ @LYd8@Dc!LYd8B8c#LYd8F6c"LYd:86c$Lok868e0Lok868e1Lok8@6fLok8@6fLok:66fLok:66fLok:66fMWQ`888cMWQ`888c%MWQ`888c)MWQ`8@6c&MWQ`8@6c*MWQ`:68c'MWQ`:68c+MWQ`<68c(MWQ`<68c,MkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@8cMkM8@:c MkM8@:cMkM8@:cMkM:<6c MkM:>6cMkM:>6cMkM:>6cMkM:F6cMkM:F6cMkM:F6cMkM:H6cMkM:H6cMkM<86cMkM<:6cMkM<@>cMkMF6c MkO:86f MkO:86f MkO<>6f MkYm8@>c MkYm8@>cMkYm8@>fMkYm8@>fMkYm8@>fMkYm::6fMkYm<:8c MkYm>::f MkYm>::f MkYm>>Dc MkYm>B8cQMb8@6dQMb8@6dQMb8@6dQMb8@6dQMb8@@dQMb8@@dQMb:68dQMb:68dQMb:8<dQMb:8<dQMb:8<dQMb:8<dQbU86DdQbU86Dd QbU86Dd#QbU86Dd'QbU86Dd(QbU86Dd+QbU86Dd,QbU86Dd-QbU86FdQbU86Fd$QbU8@6dQbU8@6d!QbU8@6d"QbU8@6d%QbU8@6d&QbU:6<dQbU:6<d)QbU:6<d*WYk8@8eWYk8@8eWYk8@8e"WYk8@8e#WYk8@8e*WYk8@8e+WYk:@8e&WYk:@8e'WYk:@8e(WYk:@8e,WYk<6@e WYk<6@e!WYk<:>e)WYk<:>e-WYk<:He$WYk<<<e%`U`m<6:c-`U`m<6:c0`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d`U`m<6:d `U`m<@<c.`U`m<@<c/`U`m<@<d`U`m<@>c1`U`m<@>d`U`m<@>d`\mU<68d `\mU<68d `\mU<68d `\mU<68d`\mU<6>d`\mU<6@d `mW88<e`mW88<e`mW88<e`mW88<e `mW88<e `mW88<e `mW88<e`mW88>d.`mW8:6d/`mW8:6d0`mW8:6e`mW8:6e`mW8:6e`mW8:6e `mW8B6e`mW8B6e `mW8B6e`mW::8d1`mW::8e`mW:::e`mW:>6e`mW:>6efW^8@8efW^8@:efd^8@8e.fd^8@8e/fkv8@@efkv8@@efkv8@@efkv8@@eiQ^8@6eiQ^8@6eiQ^8@<eiQ^8@<ekdM8@6ekdM8@6e`a@   @@ @@@@ @@    @@@     @ @@@@@@@@@@@ @@@  @@JbOiY^^YeJbOiY^^YeJbOiY^^YeJbOiY^^YeJi`kmidbUeLJ^MWobYke.LJ^^doUWc!LJ^^doUWc"LJ^^doUWc#LJ^^doUWc$LQJmmvdLQJmmvdLQJmmvdLQJmmvdL^o`cLiJxYbJe0LiJxYbJe1LiJxYbJfLidUJbe/LioMQc-LioMQc.LioMQc/Loi\Q[eLom^Qid Lom^Qid!Lom^Qid"MJ`d`Y^Qf MJmJbYdc Md^^YbkeOQkbdvQike&OQkbdvQike'OQkbdvQike(OQkbdvQike)OYOYdcOYOYdcOYOYdeOYOYdeOYOYdeQ^^YdmmcSJYie"SJYie#SJYie$SJYie%SJ^JcSJ^JcSJ^MdbQeSYkWQicSYkWQicUiQQbc [dU^Q\Jic0[dU^Q\Jic1[dU^Q\Jid[dbQkOd [dbQkOd [dbQkOd [dbQkOf[dbQkbc%[dbQkbc&[dbQkbc'[dbQkbc(\Q^^vUe\Q^^vUe\YikMWc\YikMWc \YikMWf\bJffQbLQiUQid.\bJffQbLQiUQid/\bJffQbLQiUQid0\bJffQbLQiUQid1^QJoLvd^QJoLvd^QJoLvd^QYLYUQie*^QYLYUQie+^QYLYUQie,^QYLYUQie-^QYkmQif ^QYkmQif ^dbUdf ^dbUdf `MMJimve`MMJimve`MMJimve`MMdbbQ^^e`MMdbbQ^^e`MMdbbQ^^e `MMdbbQ^^e `YMWJ^Q\e `YMWJ^Q\e `YMWJ^Q\e `YMWJ^Q\e`Y^^JiOd#`Y^^JiOd$`Y^^JiOd%`Y^^JiOd&`diQJoe`diQJoe`kWd`LJd`kWd`LJd`kWd`LJd`kWd`LJdbUovQbefJkhoJ^Qc fJkhoJ^QcfJo^YbdfJo^YbdfJo^YbdfJo^YbdfiokWJbciJm\okeiJm\okeiQO`dbOciQO`dbOciQO`dbOc iQO`dbOciQO`dbOciQYMWJiOmciQYMWJiOmfiQYMWJiOmfiQYMWJiOmfiWdOJdiWdOJdiWdOJdidLYkdbdidLYkdbdidLYkdbdidLYkdbdkWJ^WdoLc)kWJ^WdoLc*kWJ^WdoLc+kWJ^WdoLc,kWQQWvekWQQWvekWQQWve kWQQWve!kY`dbckdqQbd'kdqQbd(kdqQbd)kdqQbd*kmo^^ekoOQd+koOQd,koOQd-kxJLJmd kxJLJmdkxJLJmdkxJLJmfkxJLJmfkxJLJmfmJqJbJdmJqJbJdmJqJbJd moi\cmoi\cmoi\cmoi\csJMQvc sY^QvcsY^QvcsY^QvcvdobUcvdobUcvdobUccccUPrushanCHEMProfsc3256032burke+$ ?UPrushanCHEMAsst ProfH 3256032prushan2)# ?UStonesiferCSAdj Asstbs3216439bhaskar2)#?UÏGreenCSCAdj AsstO 996439jgreen,$ ?UStonesiferCSCAdj AsstO 996439stonesif3)#?UFisherCSCInstructorO 1316439jfisher1(" ?UPasqualeCSCInstructorC 3106052pasquale4*$ ?UÏWaceyCSCAdj AsstO 1316439wacey,% ?USimonCSCInstructorbs1256102mead-'! ?USimonCSCInstructorC 3106102simon.'! ?RWp' p 5 H  ˨˨˨˨˨˨˨˨˨˨˨˨˨˨˨˨˨ˊ l D  S  w Y ; ;;;;;;;;;;;;;;;;;;;;;;;;;; ]_ _ _ Sections.junk,_ Sections.junk, g__ Sections.junk, g_ Sections.junk, g__ Sections.junk, g__ Sections.junk, _ Sections.junk, g_ Sections.junk, g_ _b@  '_Sections.Year2005=+ w_Sections!!! _ G_ G_ _ G^  Rooms.room) '^B@  g^Rooms.Overhead- g^Rooms.[Data Projector]5 g^Rooms.[Data Connection]6 g^Rooms.[Front Computer]5 g^ Rooms.size) g^ Rooms.room) g^Rooms ^ G^ G^ ^ G\P@  '\ students.Major- '\ students.Last, '\Professors.phone/ g\ Professors.office0 g\ Professors.Dept. g\ Professors.Name. g\ students.[Balance Due]5 g\ students.Hometown0 g\students.GPA+ g\students.[Num Credits Earned]< g\students.Major- g\students.Year, g\students.Last, g\students.Middle. g\students.First- g\students.[Student ID]4 g\students!!! ÏCSC230Programming and GUIs5@0$ ȏMTH160Discrete Math I(@5+ MTH114Calculusfor business majors9 m b@1123CarmeloWAnthonyFrCSCPalmyra>50,#!m F @O4141LeBronBJamesJrHISPhiladelphia@2-)" m @5555DwightAHowardFrCSCCherry Hill@3.*" m *+@^9191DwyanePWadeSoDArtFt LauderdaleA2,(" UÏHighleyCSCAsstbs3236077highley,# ?UFalaCSCInstructorC 2256439fala,&  ?UȏTurkCSCAsstO 2301098jturk'  ?UCatanioCSCAsstO 1356122catanio,# ?FLVALVMR2(ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlacesOrientation$UnicodeCompressionDefaultViewIMEModeIMESentenceModeSmartTagsS  , $Sections.room DESC sectionID   " Section Index   2 *>"00000" And <"99999"P H"Section ID must be 5 digit numeric" m   rCourse#       m   Section <   "01"   & >"00" And <"99"N F"Section must be two digit numeric" m   ltime t      m   lroom       m   vprofessor       m   stop point    $ Max Enrollment  25    >10 And <100L D"Invalid Stop Point - enter 11-99" mlDept       m    Sem   & F S Su semester    m "S"   #Year (  N Fyear offered - use 4 digit notation  2007  & >1954 And <2350N F"I dont think this year is correct" m5junk   LVALʾexxxenrollmentssstemp update Sections QuerystudentsWenrollreport leading to unnormalized rooms designCreate data access page in Design viewAutoExecu^3