INSTRUCTORS: Sally Tilstra & Roger Morris
e-ADDRESS: sally.tilstra@southeasttech.com or roger.morris@southeasttech.com
PHONE: (605)367-5561

OFFICE:  Technology Center - Room 202

TEXT(S): Morrison, Joline and Morrison, Mike, Guide to Oracle9i, Course Technology Inc.,  ISBN 0-619-15959-6

SOFTWARE: SQL*Plus, PL/SQL, Oracle Developer Suite, Oracle 9i  (Windows XP)

COURSE DESCRIPTION: This course introduces the student to the use of Oracle for database and application development.  Using SQL, the student shall learn to create tables, insert and modify data, and create queries.  Using SQL*Plus & Oracle Developer Suite, the student shall learn to write program units using PL/SQL and to create forms and reports.  3 running databases are used throughout the semester.

COURSE OBJECTIVES FOR THE STUDENT:

1.      To gain expertise with creating and maintaining relational database tables using SQL;

2.      To understand the PL/SQL procedural programming language and how it is used with SQL commands;

3.      To gain expertise developing a database application using the Oracle Developer DBMS development tools;

4.      To learn critical-thinking techniques for solving unstructured problems by identifying and analyzing an information systems problem and designing a working database system to solve this problem;

5.      To learn problem-solving skills for solving programming problems.

METHODS OF INSTRUCTION:

• Lecture, with the use of visual aids (LED projector) and PowerPoint Presentations
• Demonstration of software functionality.
• Individual laboratory and written assignments.

COURSE REQUIREMENTS:
Schedule:  2 hours lecture per week      Lab Time:  2 hours instructor-supervised lab per week

Attendance:   Attendance is strongly encouraged and the student should not miss more than 3 classes during the term. 

 Prerequisites:  DB Management/Design or industry experience using SQL & RDMS (instructor consent required)

 Test Makeups and Retakes:  If a student is absent on the day of an exam, the student will need to take the exam within 1 week of the exam date.  Test retakes may be considered by the instructor, and arranged on an individual basis.  Test retakes are averaged with the original exam score.

 Late Assignments:  Students shall demonstrate responsibility and commitment to learning by submitting all assignments on or before the designated due date and by attending all scheduled classes.  Up to 10% of the points may be deducted from late assignments.  Some late assignments may not be accepted, as decided by the instructor.

Unethical Behavior: 

Cheating or plagiarism may result in at the very least a zero for that work for all parties involved.  Documentation of suspected cheating shall include the names of the individuals involved and samples of the assignments will be photocopied and kept on file. Repeated cheating will be reported to STI administration for follow-up actions. Examples of cheating are, (but not limited to):

   *using email or the network to pass files with answers or code to another student, this is much more than  

     'just working together'

   *cutting and pasting code or answers written by someone else into a document then passing it off as your  

     own work

   *taking code from libraries or folders with or without permission of another

   *retrieving code printouts from the waste basket and using it as your own

   *downloading code from another student                     

   *extensive collaboration – if in doubt, check with the instructor

   *submitting the same document that students ‘worked together on’ without instructor permission or

     recommendation

Computer privileges may be modified or discontinued if they are abused.  Images, computer use or behavior that are inappropriate in the professional business environment should not be evident while the student is in the classroom. If observed by the instructor, the student will be reminded of the policy and asked to correct the behavior or image.  Students may be asked to leave the classroom if the behavior or images recur.  See STI Student Handbook for current policies.

ASSESSMENT OF STUDENT LEARNING:

Exams (40% of grade) Exams will be given after major topics.  Test questions may consist of coding, multiple choice, true/false, fill-in-the-blank, logic questions, definitions, short answer, completion, and matching.

Quizzes (20% of grade) Quizzes are usually announced one class period in advance and may vary from 5 to 20 questions which may be in any format.  Quizzes may only be made up prior to the next class period.  Once quizzes are returned to students, they may not be made up.

End of Chapter Case Project Assignments (30% of grade) The student shall submit printouts of the end of chapter case project assignments in class on the due date or by e-mail with a date stamp of 5:00 PM on the due date.

Chapter Review Question & Written Assignments (10% of grade)  Review questions or exercises, written reports, worksheets