CSC 452 Database Programming

Chonghua Zhang

Office: CDM 615
Winter 2022-2023
Class number: 28445
Section number: 810
OLASY NCHOP Online Campus
Course homepage: D2L


Programming in a relational database environment using procedural languages. Topics covered in the course include procedural extension of query languages, collections/records composite data types, cursors, runtime error handling, procedures, functions, triggers, packages, and dynamic SQL.


There is no required textbook to buy for this course.


Oracle Database PL/SQL Language Reference. 12c Release 2 (12.2). January 2019.

It is available online for free download. The PDF file is also provided on the course web page.

Each week, class notes (in MS word format) will be provided.


Grading Breakdown

Homework:                     40%
Midterm Exam:               30%
Final exam:                     30%

Grading Scale

A:    93 - 100;  A-: 90-92 ;;

B+:  87 - 89 ;   B: 83 - 86 ; B-: 80 - 82 ;

C+:  77 - 79 ;   C: 73 - 76 ; C-: 70 - 72 ;

D+:  67 - 69 ;   D: 63 - 66 ; D-: 60 - 62 ;

F:     0  - 59       


       (CSC453-Database Technologies or  CSC451-Database Design or

        CSC455-Databases for Large Scale Processing)

       (CSC401-Introduction to Programming or IT 411)

See syllabus on D2L

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 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

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