ClassInfo

CSC 352 Database Programming

Fall 2016-2017
Class number: 32442
Section number: 701
M 5:45PM - 9:00PM
LEWIS 01108 Loop Campus
Course homepage: https://d2l.depaul.edu

Summary

This course focuses on programming in relational database environment using Oracle PL/SQL. This is a programming oriented course and homework assignments will incorporate Oracle SQL and PL/SQL.

Approximate Weekly Schedule

Week 1: Introduction, Review of Basic Oracle SQL Features.
Weeks 2-5: PL/SQL Programming Language Fundamentals, Programs with Cursors and Exception Handling.
Week 6: Midterm Exam.
Weeks 7-8: Stored Procedures, Functions, and Packages.
Weeks 9-10: Triggers, Autonomous Transactions, Course Review.
Week 11: Project.


Learning Outcomes

Upon successful completion of this course, students will be able to
Understand how to process PL/SQL programs in SQL Developer
Use primitive data types, selection statements, conditions, and loops to write PL/SQL programs
Manage data retrieval with cursors
Develop PL/SQL programs to catch exceptions
Create procedures, function, package, and triggers to solve practical problems
Use some of the Oracle supplied PL/SQL packages to generate screen outputs



Texts

There is no required text book for this course. I will post very detailed lecture notes on the course website (D2L). In most cases, the lecture notes should suffice.


Grading

Your grade in this course will be based on the following components:

Class attendance: 8%
Homework: 36%
Midterm Exam: 30%
Project: 26%

Class Attendance
Note that class attendance is required for this course and constitutes 8% of you grade.

Classroom Students
You are allowed one unexcused absence without penalty. After one absence, your attendance grade will be penalized unless you have a legitimate excuse for missing class. Students who are more than 30 minutes late for class will be considered to have an unexcused absence. We will regularly circulate an attendance sheet, which you should sign. Signing for others is considered academic dishonesty.

Online Students
You are expected to view weekly recorded lecture online every week. You are required to submit a 70-150 word summary of what was covered in the lecture before the next lecture begins to prove that you have viewed the lecture on time. You lecture summary should only contain the topics that were covered in the lecture. You will simply receive a grade of zero if your lecture summary has the topics that we have not introduced in the lecture. Do not just copy the topics from the lecture handouts without watching the recordings.

Homework
There will be six (6) homework assignments. Their purpose is to give you individual out of class practice on the skills we are learning. All programming problems are designed based on material covered in class.
All homework assignments will carry equal weight. The lowest homework grade will not be dropped.

Late Homework Policy
Unless prior arrangements are made, homework turned in late but within 24 hours of the due time will be graded at 75% credit, homework turned in between 24 and 48 hours will be graded at 50% credit, and homework turned in later than 48 hours will not be accepted.

Midterm Exam
A take-home midterm exam will be given in the middle of the quarter. There are no makeup exams in this course. Late midterm exams will not be accepted.

Project
The project will require knowledge of the material covered in the course. Late final projects will not be accepted.

Grades will be assigned based on the following scale:

A: 93 - 100 A-: 90 - 92
B+: 88 - 89 B: 83 - 87 B-: 80 - 82
C+: 78 - 79 C: 73 - 77 C-: 70 - 72
D+: 68 - 69 D: 63 - 67 D-: 60 - 62
F: 0 - 59


Prerequisites

IT240 and (CSC 212 or CSC 242 or CSC 243 or CSC 262 or CSC 224 or
CSC 300 or CSC 309).


This course is designed for students who have basic experience with SQL. You should already understood basic SQL statements for storing, retrieving, and manipulating data in a relational database.

Previous experience in at least one high-level programming language is expected; this is not an introductory programming course. In particular, you should already have written programs using branching (e.g., "IF-ELSE"), looping (e.g., "WHILE"), functions (or procedures), and arrays.


Email Communication

I will reply to email messages within one business day after the day I receive and read them; therefore questions that are only received by me on an assignment's due date (or late the night before) are not guaranteed replies before the assignment is due.

Please plan accordingly and begin the assignments early enough to ask questions and receive answers. Also, please do not email me your programs unless I specifically request it. If you are having problems, you should instead send me a detailed description of exactly where and how your program does not perform as desired. I will suggest approaches and guide you in locating and solving your problems, but I will not debug your programs for you.

As we are all inundated with spam these days, please begin the subject line of each email message with "CSC 352" or "CSC 452" so that I can easily identify course-related messages, and sign your name at the end of your email so that I know with whom I am corresponding.


School policies:

Changes to Syllabus

This syllabus is subject to change as necessary during the quarter. If a change occurs, it will be thoroughly addressed during class, posted under Announcements in D2L and sent via email.

Online Course Evaluations

Evaluations are a way for students to provide valuable feedback regarding their instructor and the course. Detailed feedback will enable the instructor to continuously tailor teaching methods and course content to meet the learning goals of the course and the academic needs of the students. They are a requirement of the course and are key to continue to provide you with the highest quality of teaching. The evaluations are anonymous; the instructor and administration do not track who entered what responses. A program is used to check if the student completed the evaluations, but the evaluation is completely separate from the student’s identity. Since 100% participation is our goal, students are sent periodic reminders over three weeks. Students do not receive reminders once they complete the evaluation. Students complete the evaluation online in CampusConnect.

Academic Integrity and Plagiarism

This course will be subject to the university's academic integrity policy. More information can be found at http://academicintegrity.depaul.edu/ If you have any questions be sure to consult with your professor.

All students are expected to abide by the University's Academic Integrity Policy which prohibits cheating and other misconduct in student coursework. Publicly sharing or posting online any prior or current materials from this course (including exam questions or answers), is considered to be providing unauthorized assistance prohibited by the policy. Both students who share/post and students who access or use such materials are considered to be cheating under the Policy and will be subject to sanctions for violations of Academic Integrity.

Academic Policies

All students are required to manage their class schedules each term in accordance with the deadlines for enrolling and withdrawing as indicated in the University Academic Calendar. Information on enrollment, withdrawal, grading and incompletes can be found at http://www.cdm.depaul.edu/Current%20Students/Pages/PoliciesandProcedures.aspx.

Students with Disabilities

Students who feel they may need an accommodation based on the impact of a disability should contact the instructor privately to discuss their specific needs. All discussions will remain confidential.
To ensure that you receive the most appropriate accommodation based on your needs, contact the instructor as early as possible in the quarter (preferably within the first week of class), and make sure that you have contacted the Center for Students with Disabilities (CSD) at:
Lewis Center 1420, 25 East Jackson Blvd.
Phone number: (312)362-8002
Fax: (312)362-6544
TTY: (773)325.7296