{\rtf1\ansi\deff1\adeflang1025
{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman{\*\falt Thorndale};}{\f1\froman\fprq2\fcharset0 Times New Roman;}{\f2\fswiss\fprq2\fcharset0 Arial;}{\f3\fnil\fprq2\fcharset0 HG Mincho Light J;}{\f4\fnil\fprq2\fcharset0 Arial Unicode MS;}}
{\colortbl;\red0\green0\blue0;\red128\green128\blue128;}
{\stylesheet{\s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\snext1 Default;}
{\s2\sa120\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\sbasedon1\snext2 Text body;}
{\s3\sb240\sa120\keepn\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f2\fs28\lang1033\sbasedon1\snext2 Heading;}
{\s4\sb240\sa60\keepn\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f2\fs28\lang1033\b\sbasedon1\snext1{\*\soutlvl0} Heading 1;}
{\s5\sb240\sa60\keepn\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f2\fs24\lang1033\i\b\sbasedon1\snext1{\*\soutlvl1} Heading 2;}
{\s6\sb240\sa60\keepn\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f2\fs24\lang1033\sbasedon1\snext1{\*\soutlvl2} Heading 3;}
{\s7\sb240\sa60\keepn\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f2\fs24\lang1033\b\sbasedon1\snext1{\*\soutlvl3} Heading 4;}
{\s8\sb240\sa60\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f2\fs22\lang1033\sbasedon1\snext1{\*\soutlvl4} Heading 5;}
{\s9\sb240\sa60\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs22\lang1033\i\sbasedon1\snext1{\*\soutlvl5} Heading 6;}
{\s10\li360\ri0\fi-360\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\sbasedon1\snext10 List;}
{\s11\li720\ri0\fi-360\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\sbasedon1\snext11 List 2;}
{\s12\li1080\ri0\fi-360\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\sbasedon1\snext12 List 3;}
{\s13\cf1{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\sbasedon1\snext13 Header;}
{\s14\cf1{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\sbasedon1\snext14 Footer;}
{\s15\sb240\sa60\cf1\qc{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f2\fs32\lang1033\b\sbasedon1\snext16 Title;}
{\s16\sa60\cf1\qc{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f2\fs24\lang1033\sbasedon1\snext2 Subtitle;}
{\s17\li360\ri0\fi1\sa120\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\sbasedon1\snext17 WW-List Continue;}
{\s18\li360\ri0\fi1\sa120\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\sbasedon1\snext18 WW-Body Text 2;}
{\s19\li360\ri0\fi1\sa120\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\sbasedon18\snext19 WW-Body Text 3;}
{\s20\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\sbasedon1\snext20 Normal;}
{\*\cs22\cf1\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs24\lang1033\sbasedon24 Footnote Characters;}
{\*\cs23\cf1\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs24\lang1033 Page Number;}
{\*\cs24\cf1\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs24\lang1033 WW-Absatz-Standardschriftart;}
{\*\cs25\cf1\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs24\lang1033 WW-Absatz-Standardschriftart1;}
{\*\cs26\cf1\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs24\lang1033\sbasedon25 WW-Footnote Symbol;}
{\*\cs27\cf1\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs24\lang1033 WW-Default Paragraph Font;}
{\*\cs28\cf1\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs24\lang1033 WW-Page Number;}
{\*\cs29\cf1\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs24\lang1033\sbasedon27 WW-Page Number1;}
{\*\cs30\cf1\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs24\lang1033\b\sbasedon27 WW-Strong;}
}
{\info{\title 180sql syllabus - s03}{\creatim\yr2002\mo1\dy29\hr22\min26}{\operator Sharon Tuttle}{\revtim\yr2003\mo2\dy24\hr8\min39}{\printim\yr2003\mo1\dy20\hr15\min27}{\comment StarWriter}{\vern6410}}\deftab720
{\*\pgdsctbl
{\pgdsc0\pgdscuse195\pgwsxn12240\pghsxn15840\marglsxn1440\margrsxn1440\margtsxn720\margbsxn720\headery0{\*\headeryb283\headerxl0\headerxr0\headeryh0}{\header \pard\plain \s13\cf1{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640\ltrch\loch\fs20{\ltrch\loch\f1{\fs18 CIS 315 - Course Syllabus\tab \tab p. }{\field{\*\fldinst \\page\\* ARABIC}{\fldrslt 2}}}
\par \pard\plain \s13\cf1{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640\ltrch\loch\fs18 {\ltrch\loch\f1 Spring 2003}
\par }
\pgdscnxt0 Default;}}
\paperh15840\paperw12240\margl1440\margr1440\margt720\margb720\sectd\sbknone\pgwsxn12240\pghsxn15840\marglsxn1440\margrsxn1440\margtsxn1439\margbsxn720\headery720{\header \pard\plain \s13\cf1{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640\ltrch\loch\fs20{\ltrch\loch\f1{\fs18 CIS 315 - Course Syllabus\tab \tab p. }{\field{\*\fldinst \\page\\* ARABIC}{\fldrslt 2}}}
\par \pard\plain \s13\cf1{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640\ltrch\loch\fs18 {\ltrch\loch\f1 Spring 2003}
\par }
\ftnbj\ftnstart1\ftnrstcont\ftnnar\aenddoc\aftnrstcont\aftnstart1\aftnnrlc
\pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\qc{\*\tlswg8236}\tx6300\ltrch\loch\b {\ltrch\loch\f1 HUMBOLDT STATE UNIVERSITY}
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\qc\ltrch\loch\b {\ltrch\loch\f1 Spring 2003 - CIS 180 L - Section 3 - Intro to SQL}
\par 
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\ltrch\loch\f1{\b Class Meetings: }{\b0 Monday, Friday\tab \tab 10:00 - 11:50 am\tab NHW 244}}
\par {\ltrch\loch\f1{\b Instructor:}\tab Sharon Tuttle, Ph.D.\tab \tab \tab \tab {\b Office: \tab }237E NHW}
\par {\ltrch\loch\f1{\b E-Mail: \tab st10@humboldt.edu\tab \tab \tab \tab Phone:\tab }826-3381 (Office/Message)}
\par {\ltrch\loch\f1{\b Web Page:}\tab follow link from {\b http://www.humboldt.edu/~st10};}
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\ltrch\loch\fs20 {\ltrch\loch\f1 \tab \tab note the link from the course web page to the Blackboard site for this course, also. }
\par {\ltrch\loch\f1 \tab \tab (you can also reach your Blackboard account via {\b http://blackboard.humboldt.edu})}
\par \pard\plain \s13\cf1{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\ltrch\loch\f1{\b Office Hours:\tab }{\fs20 Tu, Th\tab \tab \tab 2:00 -   \tab 4:00 pm,   or by appointment.}}
\par \pard\plain \s13\cf1{\*\tlswg8236}\tqc\tx4320{\*\tlswg8236}\tqr\tx8640{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\ltrch\loch\fs20 {\ltrch\loch\f1 \tab \tab (note: if for some reason I cannot be at office hours, I will try to post a note on my office door.)}
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\ltrch\loch\b 
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\ltrch\loch\f1{\b Required text}:\tab }
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\ul {\ltrch\loch\f1 Introduction to SQL{\ulnone , 3rd edition, Rick van der Lans, Addison Wesley, 2000.}}
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\ul\ltrch\loch\b 
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\ltrch\loch\b {\ltrch\loch\f1 Course description:}
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\*\tlswg8236}\tx1260 {\ltrch\loch\f1 An introduction to SQL (Structured Query Language), the industry standard for asking questions about data that works in most kinds of databases. Learn how to create, modify, and ask questions about your database data using Oracle's implementation of this s
tandard language.}
\par 
\par {\ltrch\loch\f1{\b Prerequisites:} familiarity with the use of databases is recommended.}
\par 
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\*\tlswg8236}\tx1260\ltrch\loch\b {\ltrch\loch\f1 Grading breakdown:}
\par {\ltrch\loch\f1 \tab {\b0 Homeworks (9)\tab 90%\tab \tab \tab \tab \tab }Grading scale:}
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\*\tlswg8236}\tx1260 {\ltrch\loch\f1 \tab Other\tab \tab 10%\tab \tab \tab \tab \tab         A: >93       A-: 90-92}
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\*\tlswg8236}\tx1260\ltrch\loch\b {\ltrch\loch\f1 \tab \tab \tab \tab \tab \tab \tab \tab \tab {\b0 B+: 87-89    B: 83-86     B-: 80-82}}
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\*\tlswg8236}\tx1260 {\ltrch\loch\f1 \tab \tab \tab \tab \tab \tab \tab \tab \tab C+: 77-79    C: 73-76     C-: 70-72}
\par {\ltrch\loch\f1 \tab \tab \tab \tab \tab \tab \tab \tab \tab         D+: 67-69  D: 60-66}
\par {\ltrch\loch\f1 \tab \tab \tab \tab \tab \tab \tab \tab \tab \tab       F: <60}
\par {\ltrch\loch\f1 \tab \tab \tab \tab \tab \tab \tab \tab \tab (note that {\b CR} is thus >=70)}
\par 
\par {\ltrch\loch\f1 This course will have no formal exams --- grades will be mostly determined by the 9 homeworks (typically one given each session, due by the beginning of the next session). "Other" may be small unscheduled quizzes or in-class activities; all of these, toget
her, will comprise the remaining 10% of the course grade. Homeworks will be graded based on whether you have attempted each question or not.}
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\*\tlswg8236}\tx1260\ltrch\loch\b 
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033 {\ltrch\loch\f1 If you would like me to e-mail your grades to you during the course of the semester, you must give me permission in writing on the form given out on the first class meeting.}
\par 
\par {\ltrch\loch\f1 In the typical class session, (although this is subject to change, based on how the course actually goes), I plan to discuss the topics du jour for the first hour, and then you will have an opportunity to practice those topics during the second hour. }
\par 
\par {\ltrch\loch\f1 Note that we will be using the student Oracle database on redwood for this course, and you will be expected to use this for your homeworks and class activities. Fortunately, you can reach it from anywhere that you have Internet access, by using the telnet 
program. }
\par 
\par {\ltrch\loch\f1 Assignments cannot be accepted late; turn in whatever you have done by the due date and time. Note that if you have turned something in before that deadline, you are welcome to turn in additional improved versions up until the deadline.}
\par 
\par {\ltrch\loch\f1 (TENTATIVE course schedule begins on the next page)}
\par 
\par 
\par \page\pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033 {\ltrch\loch\f1 TENTATIVE COURSE SCHEDULE (subject to change!):}
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033 
\par {\ltrch\loch\f1 February 24th:\tab intro to SQL*Plus, simple projection using SQL select statement (ref: ch. 9, 9.1-9.3)}
\par {\ltrch\loch\f1 February 28th:\tab simple selection using SQL select statement (ref: ch. 8, 8.1-8.7, part of Ch. 11)}
\par 
\par {\ltrch\loch\f1 March 3rd:\tab joins using SQL select statement (ref: ch. 7)}
\par {\ltrch\loch\f1 March 7th:\tab creating tables in SQL, inserting rows into tables (ref: parts of ch. 16, ch. 15, 15.1)}
\par 
\par {\ltrch\loch\f1 March 10th:\tab sub-selects/nested selects within SQL select statements (ref: ch. 13)}
\par {\ltrch\loch\f1 March 14th:\tab modifying and deleting data within tables (ref: ch. 15, 15.3-15.4)}
\par 
\par {\ltrch\loch\f1 March 17-March 21: {\b Spring Break -- no class}}
\par 
\par {\ltrch\loch\f1 March 24th:\tab SQL aggregate functions, SQL select group-by and having clauses (ref: ch. 9, 9.5-9.9, }
\par {\ltrch\loch\f1    \tab \tab parts of ch. 10)}
\par {\ltrch\loch\f1 March 28th:\tab set operations in SQL select statement, intro to SQL views and sequences  (ref: parts of ch. 12, \tab \tab ch. 20)}
\par 
\par {\ltrch\loch\f1 March 31st: \tab {\b Cesar Chavez Holiday -- no class}}
\par {\ltrch\loch\f1 April 4th:\tab simple reports in SQL*Plus (ref: parts of ch. 5){\*\bkmkstart DDE_LINK2}{\*\bkmkend DDE_LINK2}}
\par 
\par 
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033\ltrch\loch\fs12 
\par \pard\plain \s1\cf1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\aspalpha\rtlch\af4\afs24\lang255\ltrch\dbch\af3\afs24\langfe255\loch\f1\fs20\lang1033{\*\tlswg8236}\tx1260 
\par }