Database Technologies
CSC 453 (901 & 910)

Marcus Schaefer


Latest additions

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

hw1 4/4
hw2 4/11
hw3 4/18
hw4 4/25
hw5 5/9
hw6 5/16
hw7 5/23
 

Questions and Answers

Schedule

Classes and office hours

The class meets Th 5:45-9:00pm in CDM 228.
My office hours are MW 10:55-11:40 and Th 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 Garcia-Molina, Ullman and Widom's Database Systems. The Complete Book, Prentice-Hall, 2nd edition, 2008.

Syllabus

For general information, see the official class syllabus. The prerequisites for this course is the data structures course CSC 403.


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

1-3 Relational Databases and SQL
3-5 Database Design and Normalization
6 Midterm
6-8 Database Programming
8-9 Storage, Views, and Indexes
10 Advanced Topic

Grades and exams

Homework: 40%, Midterm: 30%, Final: 30%.

Midterm will take place 5/3/2018 in lab CDM 819 (for in-class section). The final exam will be on 6/7/2018 in a lab, CDM 819, at 5:45pm (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 cannot talk about your homework solutions; you cannot 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, and you need to be able to fully explain it. 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. Note that this may lead to reduced credit, however, since you are expected to do the work by yourself.

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: March 13th, 2018.