ClassInfo

CSC 452 Database Programming

Fall 2016-2017
Class number: 32446
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 Language Fundamentals, Programs with Cursors and Exception Handling, Advanced PL/SQL Programming Techniques, Oracle Collections and Bulk Operations.
Week 6: Midterm Exam.
Weeks 7-8: Stored Procedures, Functions, Packages, JDBC, Advanced Programming Skills.
Weeks 9-10: Triggers, Autonomous Transactions, Dynamic SQL, Advanced Topics in Database Programming (SQL Injection, Database Security and Privacy), 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
Analyze and design strategies for a variety of practical problems in business
Display proficiency in coding PL/SQL programs
Develop efficient PL/SQL programs to identify and handle exceptions
Enhance performance using collection datatypes and bulk operations
Create procedures, functions, packages, and triggers to solve business challenges and enforce business rules
Invoke dynamic SQL to build run-time SQL statements
Wrap Codes for Security Purposes



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 and to explore some ideas more thoughtfully and deeply. Some problems will be challenging and will integrate/extend what we have learned in the classroom.
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 examination 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. Some questions need advanced knowledge and skills. 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

(CSC 451 or CSC 453 or CSC 455) and (CSC 401 or IT 411)


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