ClassInfo

CSC 452 Database Programming

Hani Abu-Salem

Summer II 2022-2023
Class number: 45756
Section number: 510
-
OLASY NCH00 Online Campus
Course homepage: D2L

Summary

Programming in a large-scale relational database environment using procedural languages. Topics covered in the course include procedural extension of query languages, runtime error handling, subprograms (procedures and functions), packages, database triggers, dynamic query language. Optional topics include transaction management, reliability, and security.



Texts

Required text:

Book1: 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.

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/lnpls/database-pl-sql-language-reference.pdf

Book2: ORACLE10gTM Programming: A Primer, Raj Sunderraman, 2007, Addison-Wesley.

 

Each week, detailed lecture notes/PPTs will be provided.



Grading

Assignments and Grading      

1. 40% - Homework Assignments.

2. 30% - Midterm Exam Monday 8/01/2022 (Online D2L 6:00pm-9:00pm)

3. 30% - Final Exam Thursday 8/18/2022 (Online D2L 6:00pm-9:00pm).

Letter Grades

 

A

90-100

C

70-76

A-

88-89

C-

68-69

B+

86-87

D+

66-67

B

80-85

D

63-65

B-

78-79

D-

60-62

C+

76-77

F

0-59

 



Prerequisites

       Prerequisites for CSC 452 students      

  One of: CSC453-Database Technologies, CSC451-Database Design, or CSC455-Databases for Large Scale

  Processing and one of: CSC401-Introduction to Programming or IT411-Scripting for Interactive Systems

       Prerequisites for CSC 352 students      

  (IT 240 or CSC 355) and (CSC 212 or CSC 242 or CSC 243 or CSC 300 or CSC 309).

 

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