Database Systems
CSC 355 (501 & 510)

Marcus Schaefer


Latest additions

uploaded week 10 trigger code to d2l

week 10 presentations are online

hw7 is online


Homeworks and Examples

Assignments will be available through this webpage. Written homeworks are due by the deadline. Late homeworks will not be accepted, but the lowest homework score will be dropped.

Homework

due

hw0 1/14 (midnight)
hw1 1/21
hw2 1/28
hw3 2/4
hw4 2/18
hw5 2/25
hw6 3/4
hw7 3/11

Questions and Answers

Schedule

Classes and office hours

The class meets MW 11:50-1:20 in CDM 224.
My office hours are MW 1:20-2:05 and W 4-5:30 (CDM 749, loop campus).


If you want to set up an appointment at another time, or simply ask a question, send email to mschaefer@cdm.depaul.edu.

Textbook

As textbook we will use Ullman and Widom's A First Course in Database Systems, Prentice-Hall, 3rd edition, 2007. As an optional text (as reference for SQL and PL/SQL) you can consider Murach's Oracle SQL and PL/SQL, by Joel Murach, 2008.

Syllabus

For general information, see the official class syllabus. The prerequisites for this course is a data structures course (CSC 301 or CSC 383 or CSC 393).


The following is a very rough schedule, and we might depart from it.

1

Intro to Database systems, Relational Model

2-4

SQL

5

Relational Design: Functional Dependencies and Normalization

6

Views & Indices

7

Constraints & Triggers

8-9

Database Programming

10

Advanced Topics: recursive SQL, ORL, semi-structured data, security

Grades and exams

Homework, quizzes: 40%, Midterm: 30%, Final/final project: 30%.

Midterm will take place 2/12/2014 (for in-class section). The final exam will be on 3/19/2014, 11:45-2:00pm (for in-class section).

Active participation in this class is expected, you are responsible for any material you missed.

I will use the following grading scheme:

Grade Percentage
A 95-100
A- 90-95
B+ 87-90
B 83-87
B- 80-83
C+ 77-80
C 73-77
C- 70-73
D+ 65-70
D 60-65
F <60

Throughout the quarter there will be extra credit problems; extra credit does not directly make up for points lost on homeworks or exams; instead it is added in with a weight to the final grade (i.e. not doing extra credit won't harm you, but doing it can move you up).

The midterm will take place during class. No make-up exams.

General Policies

Academic Honesty

The course adheres to the university Academic Integrity Policy, the following is an excerpt from the policy:

Cheating: Cheating is any action that violates university norms or instructor's guidelines for the preparation and submission of assignments. This includes but is not limited to unauthorized access to examination materials prior to the examination itself, use or possession of unauthorized materials during the examination or quiz; having someone take an examination in one's place-copying from another student; unauthorized assistance to another student; or acceptance of such assistance.

Plagiarism: Plagiarism is a major form of academic dishonesty involving the presentation of the work of another as one's own. Plagiarism includes but is not limited to the following:

Complicity: Complicity is any intentional attempt to facilitate any of the violations described above. This includes but is not limited to allowing another student to copy from a paper or test document; providing any kind of material—including one’s research, data, or writing—to another student if one believes it might be misrepresented to a teacher or university official; providing information about or answers to test questions.

A charge of cheating and/or plagiarism is always a serious matter.  If proven, it can result in an automatic F in the course and, in case of a repeated violation, possible expulsion.

For homework this means that while you can talk to other students about the class material, you should not talk about your homework solutions; you should not share your homework solutions, either in written or electronic form. Any work you submit with your name on it needs to have been done solely by yourself. If you do use someone else's work, you need to clearly mark this by placing quotations within quotation marks and citing any references you use. If you have questions on proper citation, you can visit DePaul's Writing Center.

Using materials prepared for other purposes (e.g., another course or work) needs the course instructor's prior permission.

Incomplete

An incomplete grade is given only for an exceptional reason such as a death in the family, a serious illness, etc. Any such reason must be documented. Any incomplete request must be made at least two weeks before the final, and approved by the Dean of CDM. Any consequences resulting from a poor grade for the course will not be considered as valid reasons for such a request.


Marcus Schaefer
Last updated: November 29th,  2013.