Assignments will be available through this webpage. Written homework is due at the beginning of class. If you hand in the homework late 10% will be taken off the score for each day. I will not accept homework later than one week after its due-date.
|
|
The class meets MW 3:10-4:40 in CDM 222.
My office hours are MW 2:15-3:00 (CDM 749, loop campus) and TuTh 10:20-11:05
(STDCTR 332, Lincoln Park campus, phone: 773-325-3731).
If you want to set up an appointment at another time, or
simply ask a question, send email to mschaefer@cdm.depaul.edu.
As textbook we will use Ullman and Widom's A First Course in Database Systems, Prentice-Hall, 3rd edition, 2007.
For general information, see the official class syllabus. The prerequisites for this course are data structures (CSC 383 or CSC 393) and Operating Systems (CSC 373).
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 |
Homework, quizzes: 40%, Midterm: 30%, Final/final project: 30%.
Midterm will be in-class, on Monday, 5/2.
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.
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:
- The direct copying of any source, such as written and verbal material, computer files, audio disks, video programs or musical scores, whether published or unpublished, in whole or part, without proper acknowledgement that it is someone else's.
- Copying of any source in whole or part without proper acknowledgement.
- Submitting as one's own work a report, examination paper, computer file, lab report or other assignment that has been prepared by someone else. This includes research papers purchased from any other person or agency.
- The paraphrasing of another's work or ideas without proper acknowledgement.
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.
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.