I U P U I

CSCI N311 Advanced Database Programming, Oracle (3 Cr.)

Spring 2009

 

Course Description:

Focus on the concepts and skills required for database programming and client server development. Concepts will apply to any modern distributed database management system. Emphasis on developing Oracle SQLPlus scripts, PL/SQL server side programming, and Oracle database architecture. Students with programming experience in ODBC compliant languages will be able to practice connecting such languages to an Oracle database. Lecture and laboratory.

 

CSCI N311 and IUPUI Principles of Undergraduate Learning

The following Principles of Undergraduate Learning are reflected in CSCI N311:

 

Course Information:

Lecture:

Section 24735, Distributed Ed (DE)

Lecture instructor: Dale Roberts, Department of Computer and Information Science, IUPUI

Email: Student correspondence via Oncourse, otherwise droberts@cs.iupui.edu

Phone Numbers:

     (317) 431-4997 (cell) (recommended)

     (317) 278-9045 (office)

     (317) 274-9727 (CSCI office)

     (317) 274-9742 (fax)

Office hours (appointment highly recommended):

     TR 3:30P - 4:30P

Office location: SL-275

Laboratory:

DE Help Session (attendance optional), M - 7:00P-8:45P, SL-247

 

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.  Late assignments will not be accepted unless prior arrangements are made with the grader.  All the assignments must work on Firebird (under Linux Operating System and Oracle installed there).

 

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:

 

Setup mail notification in OnCourse:

 

Project and Assignment submittals:

 

First time to log on CS Linux system firebird.cs.iupui.edu:

  1. The hostname of Firebird is: firebird.cs.iupui.edu.
  2. Your user id and initial password on Firebird are emailed to your IUPUI email account.
  3. 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.

  4. Remote development should be conducted using firebird.
  5. 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:

 

Academic Calendar
Spring 2009 (4092)

 September 2008
Mon Sep. 22 Course Offerings available on-line
Mon Sep. 29 Registration Guide Available Online
 October 2008
Wed Oct. 8 Priority Registration Appointments available on-line via OneStart for students enrolled in Fall 2008. Students not currently enrolled will register during open registration beginning November 1.
Mon Oct. 20 Priority Registration (by appointment only) - on-line via OneStart
Continues through October 31, 2008
Mon Oct. 20 Drop/Add - on-line via OneStart through the student center. Course deleted from record, no grades assigned. Continues through January 19, 2009
 November 2008

Sat

Nov. 1 Open Registration (no appointment required) - on-line via OneStart.
Continues through January 19, 2009
 January 2009
Sat Jan. 10 Weekend College Classes begin
Mon Jan. 12 Weekday Classes begin
Mon Jan. 12 Late Registration Fee is assessed
Wed Jan. 14 Last day to Waitlist Classes (by 5:00pm)
Mon Jan. 19 Registration and Drop/Add on-line via OneStart through the student center, ends
Mon Jan. 19 100% refund period ends
Mon Jan. 19 Martin Luther King Jr. Holiday (no classes - academic and administrative offices closed)
Tue Jan. 20 Enrollment Certifications - official document for verification of academic record information becomes available
Tue Jan. 20 A transaction fee assessed in addition to course fees for each added course
Tue Jan. 20 Extra fee for audit option. Continues through January 31
Tue Jan. 20 Added Courses require form with the instructor and academic advisor signatures. Submitted in person only at Office of the Registrar, Campus Center 250 or via the eAdd link on the self service page. If submitting in person, pick up the form from your advisor or school. Continues through March 6, 2009
Tue Jan. 20 Withdrawal with automatic grade of W. Advisor signature is required. Submitted in person at Office of the Registrar, Campus Center 250 or via the eDrop link on the self service page. If submitting in person, pick up the form from your advisor or school. Continues through March 6, 2009
Sat Jan. 24 75% refund period ends (at  noon)
Sat Jan. 31 50% refund period ends (at noon)
Sat Jan. 31 Audit Option deadline ends (at noon). Extra fee for audit option after January 19.
Sat Jan. 31 Pass/Fail Option deadline.
 February 2009
Sat Feb. 7 25% refund period ends (at noon)
 March 2009
Fri Mar. 6 Last day to withdraw with automatic grade of W. Advisor signature is required. Submitted in person at Office of the Registrar, Campus Center 250, or via eDrop link on the self service page. If submitting in person, pick up the form from your advisor or school.
Sat Mar. 7 Withdrawal with grade of W or F. Advisor and instructor signatures required. Submitted in person only at Office of the Registrar, Campus Center 250. Pick up the form from your advisor or school. Continues through 5:00 pm, April 3
Wed Mar. 11 Mid-Term
Mon Mar. 16 Spring Break. Continues through Sunday, March 22
Mon Mar. 23 Priority Registration using OneStart for Fall/Summer 2009 for students enrolled in Spring 2009. Continues through April 3.
 April 2009
Fri Apr. 3 Last day to withdraw with grade of W or F. Advisor and instructor signatures required.  Submitted in person only at Office of the Registrar, Campus Center 250. Pick up the form from your advisor or school.
 May 2009
Fri May 1 Final Examinations - Common Departmental
Sat May 2 Final Examinations - Common Departmental
Sat May 2 Final Examinations - Weekend College
Sun May 3 Final Examinations - Weekend College
Sun May 3 Final Examinations - Common Departmental
Mon May 4 Classes End (Weekday)
Tue May 5 Final Examinations- Weekday Classes
Wed May 6 Final Examinations - Weekday Classes
Thu May 7 Final Examinations - Weekday Classes
Fri May 8 Final Examinations - Weekday Classes / Common Departmental
Sat May 9 Final Examinations - Common Departmental
Sun May 10 Commencement
Mon May 11 Faculty deadline for submitting Spring 2009 grades
Wed May 13 Grades available in OneStart
Wed May 13 Transcripts with Spring grades available

 

Last Revised: 01/11/2009 07:33 PM