ࡱ> npmy ,bjbj 4T{{\$; ,,,8dD\,TNwT,MMMMMMM$ORM4ww44MN!!!4K!4M!!{DlG0h: .E*K$N0TNFFSh FSTGG8FSGh}J!<1MM!4TN4444FS : AUSTIN COMMUNITY COLLEGE DEPARTMENT OF COMPUTER STUDIES AND ADVANCED TECHNOLOGY MASTER Course Syllabus: ITSE1303 (3-3-1) Introduction to Database - MySQL Synonym [XXXXX Term] Lecture: [insert campus, classroom, days and times here] Lab: [insert campus, classroom, days and times here] Instructor: [insert name here] Office Telephone: [223-xxxx] Fax: [223-xxxx] Office: [insert office location here] Office Hours: [insert office hours here and in the online office hours application] E-mail: [xxxx@austincc.edu] Home page: [http://www.austincc.edu/xxxx] Course Description: Applications development using database programming techniques emphasizing database structures, modeling, and database access. This course instructs the student in the essential concepts and design methodology for the Relational Database Model as implemented by Oracle. Other topics include: the Data Definition Language, the Data Manipulation Language, database normalization, transaction processing, security, multi-user problems and solutions. Pre-requisite: COSC1315 Fundamentals of Programming or department approval Approved Course Texts/Readings: [Insert the name, author, publisher, and ISBN of the approved textbook/materials from the official departmental list] Instructional Methodology: This course will have 75% lecture and 25% laboratory. The CIS open labs are available for students for work outside of scheduled lab time. Course Rationale: This course is designed as a survey course to teach students to design, implement, and maintain databases. The Relational Database Model and the SQL language will be emphasized. On-line Transaction Processing Systems will be studied and contrasted with Distributed Database Management Systems and Data Warehousing Systems. Web databases will be introduced. The Oracle DBMS will be used throughout the course in Lectures and in labs. Course Objectives / Learning Outcomes: [Instructor may add to but not delete] 1. Recognise the basic concepts of the analysis and design of a database. 2. Summarise the process of Database Development and Administration using SQL. 3. Enhance Programming and Software Engineering skills and techniques using SQL. 4. Develop a basic understanding of background materials needed for technical support using SQL. 5. Solve Database problems using MySQL by applying SQL commands to Create, Insert, Update, and Retrieve a simple database. 6. Recognise the services provided by a Database Management System. 7. Recognise the use and application of the Relational Database Model. 8. Recognise Transaction Processing and Multi-user Database support. 9. Recognise the difference between a Production transaction database and a Data Warehouse. 10. Recognise the Client/Server structures used in Database Management Systems. 11. Develop and complete the design and Implementation of a basic database solution using the MySQL Database Management System. SCANS (Secretarys Commission on Achieving Necessary Skills): Refer to  HYPERLINK "http://www.austincc.edu/cit/courses/scans.pdf" http://www.austincc.edu/cit/courses/scans.pdf for a complete definition and explanation of SCANS. The following list summarizes the SCANS competencies addressed in this particular course: RESOURCES 1.1 Manages TimeINTERPERSONAL 2.1 Participates as a member of a team 2.6 Works with Cultural DiversityINFORMATION 3.1 Acquires and Evaluates Information 3.2 Organizes and Maintains Information 3.3 Uses Computers to Process InformationSYSTEMS 4.1 Understands Systems TECHNOLOGY 5.2 Applies Technology to Task BASIC SKILLS 6.1 Reading 6.5 ListeningTHINKING SKILLS 7.2 Decision Making 7.3 Problem Solving 7.4 Mental Visualization 7.5 Knowing How to Learn 7.6 ReasoningPERSONAL SKILLS 8.1 Responsibility 8.2 Self-Esteem 8.3 Sociability 8.4 Self-Management 8.5 Integrity/Honesty Grade Policy: Grade will be assigned based both on concepts and practical application. Exams, quizzes, and lab projects will be a part of the grade. An overall grade will be assigned on the following grading scale: 90% - 100% A 80% - 89% B 70% - 79% C 60% - 69% D 0% - 59% F [Instructor must add specific details here including missed exams and assignments] Course/Class Policies: Academic Integrity A student is expected to complete his or her own projects and tests. Students are responsible for observing the policy on academic integrity as described in the current Student Policies Handbook. The penalty accessed will be in accordance with the  HYPERLINK "http://www.austincc.edu/admrule/1.04.006.htm" \o "current policy" current policy. For this course, the penalty for scholastic dishonesty is a grade of F for the course. Incomplete A student may receive a temporary grade of I (Incomplete) at the end of the semester only if ALL of the following conditions are satisfied: The student is unable to complete the course during the semester due to circumstances beyond their control. The student must have earned at least half of the grade points needed for a C by the end of the semester. The request for the grade must be made in person at the instructors office and necessary documents completed. To remove an I, the student must complete the course by two weeks before the end of the following semester. Failure to do so will result in the grade automatically reverting to an F. Freedom of Expression Policy It is expected that faculty and students will respect the views of others when expressed in classroom discussions. Tutoring Free tutoring is provided for this course both on line and face-to-face. For online schedules and details please refer to  HYPERLINK "http://www.austincc.edu/cit" http:://www.austincc.edu/cit . Testing Center Policy [Open Campus Sections Only]  HYPERLINK "http://www.austincc.edu/testctr/" http://www.austincc.edu/testctr/ Attendance / Withdrawal Regular and punctual class and laboratory attendance is expected of all students. If attendance or compliance with other course policies is unsatisfactory, the instructor may withdraw students from the class. It is the students responsibility to complete a Withdrawal Form in the Admissions Office if they wish to withdraw from this class. The last date to withdraw for this semester is [insert date here]. It is not the responsibility of the instructor to withdraw the students from their class even though the instructor has the prerogative to do so under the above listed circumstances. Students who enroll for the third or subsequent time in a course taken since Fall 2002 are charged a higher tuition rate. State law permits students to withdraw from no more than six courses during their entire undergraduate career at Texas public colleges or universities. With certain exceptions, all course withdrawals automatically count towards this limit. Details regard this policy can be found in the ACC College Catalog. Student Files Privacy The information that a student stores in his/her student volume in the Computer Studies Labs may be viewed by their instructor for educational and academic reasons. Students with Disabilities Each ACC campus offers support services for students with documented physical or psychological disabilities. Students with disabilities must request reasonable accommodations through the Office for Students with Disabilities on the campus where they expect to take the majority of their classes. Students are encouraged to make this request three weeks before the start of the semester. (Refer to the current ACC Student Policies). Communication The ACC online Blackboard system  HYPERLINK "http://acconline.austincc.edu/" http://acconline.austincc.edu and the ACCmail accounts will be used as the official communication system during this semester. Lecture notes, handouts, changes to course schedule or assignments and your grades will be posted on Blackboard and all email communication will be via the ACCmail accounts. All students are expected to check both Blackboard and their ACCmail accounts on a regular basis. For information on how to log onto Blackboard and ACCmail please visit the following sites:  HYPERLINK "http://irt.austincc.edu/blackboard/StudentSupport.php" http://irt.austincc.edu/blackboard/StudentSupport.php and  HYPERLINK "http://www.austincc.edu/google/" http://www.austincc.edu/google/. Safety Statement Each student is expected to learn and comply with ACC environmental, health and safety procedures and agree to follow ACC safety policies. Emergency posters and Campus Safety Plans are posted in each classroom. Additional information about safety procedures and how to sign up to be notified in case of an emergency can be found at http://www.austincc.edu/emergency/. Anyone who thoughtlessly or intentionally jeopardizes the health or safety of another individual will be immediately dismissed from the days activity, may be withdrawn from the class, and / or barred from attending future activities. COURSE SCHEDULE [Instructor must add a course schedule for the semester indicating required readings, exams and assignments. The topic list should be copied from the list of topics approved at the time the textbook was adopted.]     Updated 9/20/2011 Page  PAGE 1 PQW^jrs{}# % & 1 7 G I Z ] a e f g k n v ޯ޼ޯީށtk޼thzh 9CJhzh 9B*CJphhLh 9B*CJph h 95CJhh 9B*phh 9 h 95 h +OCJhh 9B*CJphh 95CJ\h 9h0GB*CJph h-CJ hX,$CJ h 9CJh 9h 9B*CJph h0GCJ h0G5h0G*PQ% & I g x  < =   gd 9gd 9&$$d!%d$&d!'d$N!O$P!Q$a$ $^a$gdN $^a$gdN^gdNv x      : < = R    # % ` b v w xxkh {mh {mB*CJphh {mB*CJphh {mhLB*CJph hLCJ h[ q5CJ h {m5CJ h^5CJh0G5CJ\ hm_$CJ h0G5CJ h0GCJh 95CJ\h^h 9;CJhzh 9B*CJphhh 9B*CJph h 95CJ h 9CJ' a b ijklmnoW N ^`gd ^`gd=t`gd `gd`; $$1$gdF.$a$gdm_$    + J L hijkoſŷvivb\VMh`;h`;CJ h CJ h=tCJ hF.5CJhzh 9B*CJphh^h 9CJ h15CJ h7' 5CJ h0G5CJ h`;CJ hm_$CJ h0GCJhm_$hm_$^JaJ hLc5hF.hF.5 hF.CJ h."tCJ h$TCJh[1hLcCJ hLc5CJh[1hLc5CJ hLcCJhLh^CJ h {mCJ WZ  VWY <=?@L9˞Ҕh hTDCJhTDhTDCJh7ht0JCJhthtCJ htCJjhtCJU h5CJ hCJ hF.CJ h`;CJ\ h CJ h=tCJh`;h`;CJ h CJ:VW@Ls$IfgdgdF.gd`;^gd`; ^`gd=t`gd`;+9Zkd$$Ifl\%   V  t0'644 la^yt$If 9I]q$If 9I ./noz{~9:HIJK˼ˣ˙Ք{thth_htX h65CJhG0G0J5CJjhG0G5CJU hG0G5CJ hG0G>*CJ h6CJ h;$h6 h6\ hp\hk B*CJphh {mB*CJphh {mh {m>*B*CJphh {mhz[>*B*CJphhz[B*CJph hz[CJ hSpCJ h0GCJ h0G5CJh hCJ h5CJ! ./`[YSNN@ ^gdSpgdSp gdkd$$Ifl\%   V  t0'644 la^yt'>UmnKLAB^gd6 ^gd6  ^gd6gd6 gd6 gdz[ gdSp ^gdSpKLFcl]^ ./01IJ ¹ղ}u}}}o hz[CJhG0G0JCJ hG0GCJjhG0GCJUhG0G5CJ\h7 B*CJ\ph h7 CJ\h7 5CJ\ h`;CJ\h$a0JCJ\jh$aCJU\ h$aCJ\ h6CJ\hK(h6CJ\h65CJ\ h6CJhK(hG0G5CJ*BFcd01IJ $$ 1$^gd6`gd7 $ ^gd$a ^gd6$$ 1$^gd6 & F gd6  !!Q#R#j#k#$$,$-$%%%%()))**p+q+r+$$ ^gdk ^gd6 ^gd6 !P#Q#R#j#$$,$%%%%%%%&&>&?&\&]&'.(/(r(s(((((((((()沨梘~vrv~vl hk CJhCjhCUhC0JCJjhCCJUhGG0JCJjhGGCJU hGGCJh%!h65CJ h65CJ hC>*CJ h6>*CJ h6CJ\h65CJ\hCh6CJ hCCJ h6CJ hz[CJhhz[B*CJph&))`***r+++++X,Z,[,\,],_,`,b,c,e,f,h,,,,,,,,,,Žh+q0JmHnHu h 0Jjh 0JUh h-Njh-NUh6hhz>B*CJphhLhk CJ h*SCJh*Sh*SCJ hk CJhk hk 5CJr+++Z,[,\,^,_,a,b,d,e,g,h,i,j,k,l,m,n,,,,,,,,$a$gd*W gd^7tgdk ,,$a$gd*W21:p 9/ =!"#$% $$If^!vh#v #v #v #vV :V l t0'65 5 5 5V / a^yt$$If^!vh#v #v #v #vV :V l t0'65 5 5 5V / a^yt^ 2 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_HmH nH sH tH 8`8 k Normal_HmH sH tH D@D  Heading 1$@&CJmHsHtHH@H  Heading 2$@&5CJmHsHtH>@>  Heading 3$@& 5CJ\>@>  Heading 4$@& 6CJ]D@D  Heading 5$$@&a$ 5CJ\^@^  Heading 6$7$8$@&H$ 56>*B*CJ\]aJphB@B `; Heading 7 <@&CJaJDA`D Default Paragraph FontVi@V  Table Normal :V 44 la (k (No List 2B@2 Body TextCJ0U`0 Hyperlink>*B*4@4 Header  !4 @"4 Footer  !.)@1. Page NumberFV`AF FollowedHyperlink >*B* ph4>@R4 Title$a$5CJNP@bN Body Text 2 7$8$H$B*CJaJph`C@r` Body Text Indent7$8$H$^B*CJaJphTR@T Body Text Indent 2 ^CJH@H 2_ Balloon TextCJOJQJ^JaJ<o< 6Heading 2 Char5CJVoV 6Default 7$8$H$!B*CJ_HaJmH phsH tH 8o8  9Heading 1 CharCJjj 9 Table Grid7:V0J^@J m_$ Normal (Web)dd[$\$CJaJPK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3N)cbJ uV4(Tn 7_?m-ٛ{UBwznʜ"Z xJZp; {/<P;,)''KQk5qpN8KGbe Sd̛\17 pa>SR! 3K4'+rzQ TTIIvt]Kc⫲K#v5+|D~O@%\w_nN[L9KqgVhn R!y+Un;*&/HrT >>\ t=.Tġ S; Z~!P9giCڧ!# B,;X=ۻ,I2UWV9$lk=Aj;{AP79|s*Y;̠[MCۿhf]o{oY=1kyVV5E8Vk+֜\80X4D)!!?*|fv u"xA@T_q64)kڬuV7 t '%;i9s9x,ڎ-45xd8?ǘd/Y|t &LILJ`& -Gt/PK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!0C)theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] $T 68:=v 9K ), #&' 9B r+,,!"$%()  < 9H] .>\. r $XXXXXtXX)02=!8@0(  B S  ? _Hlt304291117 _Hlt304291118 _Hlt304292292 _Hlt304292319 _Hlt304292320 _Hlt304292439 _Hlt231804663 _Hlt231804664 _Hlt304293237 _Hlt304293238  AJJ $@@@@@@@@@ @  BKK $4H5H6H7H8H9H:H##$**$9*urn:schemas-microsoft-com:office:smarttagsplace=*urn:schemas-microsoft-com:office:smarttags PlaceName8*urn:schemas-microsoft-com:office:smarttagsCity9*urn:schemas-microsoft-com:office:smarttagsState   + 0   Y b a f = fm\c \$^$_$a$b$d$e$g$h$$$$$ = [$\$$$$jr}$%R%`Lo = `""X$X$Z$Z$[$\$\$^$_$_$a$b$d$e$g$h$n$v$$$$$$$$ = \$$$$zc 7Iq.jMzs='*~y'Χ')Χ'o24\a;g3Χ'M40d7@VJZ<*~q> ]}BH"fs$U~a(#[B_\2TCcO\eܚjPps*~hh^h`o(-^`OJPJQJ^Jo(- ^`OJQJo(o pp^p`OJQJo( @ @ ^@ `OJQJo( ^`OJQJo(o ^`OJQJo( ^`OJQJo( ^`OJQJo(o PP^P`OJQJo(h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHz^`zo(() hh^h`o(hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH. hh^h`o(hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH. hh^h`o(hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH. hh^h`o(hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.h ^`hH.h pp^p`hH.h @ L@ ^@ `LhH.h ^`hH.h ^`hH.h L^`LhH.h ^`hH.h PP^P`hH.h  L ^ `LhH.h^`.h^`.hpLp^p`L.h@ @ ^@ `.h^`.hL^`L.h^`.h^`.hPLP^P`L.z^`zo(()h hh^h`o(hH. ^`o(hH) ^`hH.  L ^ `LhH.   ^ `hH. xx^x`hH. HLH^H`LhH. ^`hH. ^`hH. L^`LhH.h^`5o(hH.h^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH ^`o(hH) ^`hH.  L ^ `LhH.   ^ `hH. xx^x`hH. HLH^H`LhH. ^`hH. ^`hH. L^`LhH.z^`zo(()='Z<jPpsq>zc Iq(#[0d7y'a;g3o2O\e)]}BTCcMzM4s$U|                 B        v0                          T        y                                  @5!YEn01RC9VdYLc,mE ^  7 7' 5mkB=2'r*|m+:-4X\5vGTD3fy$aXA z X,$m_$j9%K%o')C)jS)E*f^56"7$7J=7#8E8`;<@5<I@R%yR$TuOT'Y Zo[t[z[/O]o`99a#tb7Pf]g k9kckllP3m {mopSpwp[ qt."t^7tRv2CvsvxLy6z+{gc{M%}*)~bc=t1.uNk DGL2_"W`@8Az>btj1Rlc- ~<&B* :+qq8-<TLf8b1CfzC^]6Y d^~t*SjT"5 `b ~(* INX6_9WB ZlH;F XQ }#l8fU0uBPF.9L0itP]3VJw)g;zSZVNU)P# 9}^*Wo7xY1ErSSc\$^$ ACTIVEVTCASEVTCommandPendingVTCurMacroFlags$VTINIT VTypeCAPFlag$VTypeJoinDigitFlag$ VTypeLCFlag$VTypeNoSpaceFlag$VTypeSpaceFlag$ VTypeUCFlag$Syllabus - Fall 2000 MW.doc4NONENNNN1TRUEFALSEFALSETRUEFALSEFALSE@$@UnknownG* Times New Roman5Symbol3. * Arial5. *aTahoma?= * Courier New;WingdingsACambria Math"1h&&mmAmA!d4J$J$ 2QHP?~2!xx AUSTIN COMMUNITY COLLEGE Bill TuckerRGC CIT Lab MachineT             Oh+'0 ,8 X d p |AUSTIN COMMUNITY COLLEGE Bill Tucker Normal.dotmRGC CIT Lab Machine2Microsoft Office Word@@7]~@@m՜.+,D՜.+,D hp|  IBMAJ$ AUSTIN COMMUNITY COLLEGE Title 8@ _PID_HLINKSA*(; http://www.austincc.edu/google/6http://irt.austincc.edu/blackboard/StudentSupport.php56 http://acconline.austincc.edu/Z !http://www.austincc.edu/testctr//?http://www.austincc.edu/cit-http://www.austincc.edu/admrule/1.04.006.htm\.http://www.austincc.edu/cit/courses/scans.pdf  !"#$%&'()*,-./012456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\^_`abcdfghijkloRoot Entry F (qData +1Table3SWordDocument4TSummaryInformation(]DocumentSummaryInformation8eCompObjr  F Microsoft Word 97-2003 Document MSWordDocWord.Document.89q