Textbook(s):
(i)
Loney,
Kevin. Oracle Database 10g The Complete Reference.
ISBN 0-07-225351-7.
(ii) PowerPoint lecture slides are available via the web at http://www.cs.iupui.edu/~droberts/n311 .
(iii) Lectures in streaming media format are available via the web at http://www.cs.iupui.edu/~droberts/n311 .
(iv) Other links are also posted on the course web site http://www.cs.iupui.edu/~droberts/n311.
(v) The Loney textbook does not serve as an Oracle language reference. Google "Oracle Language Reference" to find internet references such as the http://tahiti.oracle.com.
Prerequisites:
N211 or equivalent. Prior procedural programming experienced is required. This requirement is typically met by CSCI 230 or N305 or a prior experience in a procedural programming language such as C, Visual Basic, Java, C++ or C#. Student must understand selection and repetition structures, boolean expressions and procedures and functions with input and output parameters.
Assignments
and Grading Policy:
Projects: 40% (All projects are weighted by the number of points assigned)
Midterm: 20%
Final: 20%
Final Project: 20%. For DE sections, this is an individual project, or optionally a group of 2 or 3 members.
All
Grades will be posted on IUPUI ONCOURSE.
Final Grade Scale:
| A | >= 90% |
| B | >= 80% |
| C | >= 70% |
| D | >= 60% |
| F | < 60% |
This is a minimum grade guarantee. You are guaranteed that if you achieve these percentages, that the grade listed will be the lowest grade you receive. It is possible, based on the overall performance in the class, that you may receive a higher grade at the discretion of the instructor. Plus and minus grades may also be assigned at the discretion of the instructor.
TO PASS THE COURSE, IT IS NECESSARY TO OBTAIN A PASSING GRADE (>= 60% POINTS) IN TWO CATEGORIES: TESTS (COMBINED), PROJECTS AND FINAL PROJECT (COMBINED).
Assignments will have to be submitted via
OnCourse by uploading to the
provided Drop Boxes by 11:55 PM on its due date.
Streaming Lecture
The course delivers lecture content through streaming media. Installing the free RealPlayer from http://www.real.com is required. You are encouraged to adapt your lecture experience to your learning style. If you need to lookup a topic from your textbook, just stop the lecture. If you didn't understand a topic, just backup and listen again. If you already know the subject, just fast forward. For OC sections, interactive questions and feedback occurs at the beginning of every lecture. For DE sections, interactive questions and feedback occurs either via email, Oncourse discussion forums, or the DE help session. Note that DE students are always invited the the OC lectures and labs as space permits.
Active Learning Modules
The OC sections of this course require participation in Active Learning Modules (ALMs). The ALMs may take the form of individual or group activities. Often ALMs require presentations, demonstrations, or other forms of public speaking. An encouraging atmosphere shall be maintained at all times.
Class Attendance
For On-Campus sections the use of ALMs effectively require attendance in order to earn the Class Participation portion of your grade. Various forms of attendance may be taken to verify participation. Further, preliminary research shows that increased participation improves learning. For Distributed Education sections, warmup exercises are used to measure participation. Credit for completing a warmup is given if the student passes the warmup (100%). The warmups can be repeated as often as necessary before the due date to get a passing grade.
Cooperation-Plagiarism Policy
Students are encouraged to discuss the concepts and
principles amongst themselves. Such discussions help in understanding the
material and/or different aspects of the topics taught in the class.
Students may also assist in debugging each others code.
It is unethical to directly transfer any portion of
individual work products, either by printed or electronic means, between
students. Student cooperation should not result in identical or near identical
answers/code/documentation.
ALL
THE MATERIAL SUBMITTED FOR GRADING MUST BE YOUR OWN EFFORT. If this policy is violated then the following steps may be
taken: (1) rejection of submitted material with an opportunity for
resubmission for a reduced grade, (2) reduction of points by dividing by the
number of students involved in an incident, (3) assignment of a grade of ZERO
for all students involved in an incident, (4) assignment of a grade of F for the
course, and (5) initiation of official action against all students involved in
an incident.
Internet use warning: The Computer Science department is particularly sensitive to dishonesty leveraging the internet. Presenting information obtained from the internet as your own is just as severe presenting information obtained from another student as your own. It is extremely important to cite works from the internet that are the basis for your own work. Your internet research should not result in work products that are in identical or near identical to the original. Posting any part of the course including homework, exams, or projects is forbidden. Submitting any part of the course to code-for-hire or other support web sites is forbidden. Accessing any online chat, user forum, IRC, or any other interactive discussions during online testing is prohibited.
Subscribe n311 mailing list to receive information:
-
We have set up a mailing list for this class. All students are required to subscribe to the list by sending an email to majordomo@cs.iupui.edu with one line body: subscribe n311
- During the semester, critical announcements will be sent to the n311 mailing list. Hence, everyone must subscribe to the mailing list.
- Everyone should check their email, oncourse, and the course web site regularly.
Setup mail notification in OnCourse:
-
OnCourse mail is the primary mechanism for communicating among students in the class and with the instructor.
-
Everyone should check their OnCourse mail regularly. Setup a mail notification on the InTouch tab to notify your regular email account nightly of unread OnCourse mail.
-
Email communication with the instructor and graders shall be accepted only from OnCourse.
-
Questions, concerns, discussions and answers regarding the materials covered in this class should ONLY be discussed in OnCourse.
Project and Assignment
submittals:
-
All projects and assignments are to be uploaded to an OnCourse Drop Box. In the new Oncourse, you are responsible for setting up the dropbox folders under your account.
-
Upload assignments to its OnCourse Drop Box by 11:55 PM on its due date.
-
Everyone should check their OnCourse mail regularly. Students are responsible for information posted there. If critical information is posted in Oncourse that you must read today, an announcement to check OnCourse will be sent to the mailing list.
-
Deadline extensions for assignments shall not be granted unless prior arrangements are made with the graders before the due day. Last minute extensions are typically not granted.
-
All files uploaded to be drop box must include a comment header block that includes the project name and student name. Also display the user name.
-- Name: Dale Roberts
-- Project 4
SET ECHO ON
SET SERVEROUTPUT ON
SPOOL c:\temp\project4.txt
SELECT USER FROM DUAL; -
Besides sql files, script outputs are also turned in with a txt extention. Make sure you use the SQLPLUS SPOOL COMMAND, not the spool windows dialog in SQLPLUSW. Do not turn in screen shots unless specifically told to do so.
First time
to log on CS Linux system –
firebird.cs.iupui.edu:
-
The hostname of Firebird is:
firebird.cs.iupui.edu.
- Your user id and initial password on Firebird are emailed to your IUPUI email account.
-
Firebird only accepts secured connections through SSH. You must install PuTTY before connecting to firebird and to transfer files. FTP does not work. PuTTY is available through IUWare.
- Remote development should be conducted using firebird.
- Passwords and home directory are shared between laboratory workstations and firebird. Use your firebird password to login to laboratory workstations.
Connecting to Oracle running on Firebird
host: firebird.cs.iupui.edu
port: 1521
OID: cs10gorc
Domain: cs10gorc.cs.iupui.edu (it may have a different name like service)
In classroom laptop use
policy:
-
Since the introduction of the wireless LAN on the IUPUI campus, it has become common place for students to use laptops during the class. Use of a laptop in support of class activities, such as taking notes or viewing slides, is permitted. Disruptive activities are not permitted.