Database Technologies
CSC 449 (203)

Marcus Schaefer

Latest additions

Homeworks and Examples

Assignments will be available through this webpage. Written homeworks are due at the beginning of class. If you hand in the homework late 20% will be taken off the score for each day.

Questions and Answers

• To find out when and where to find lab tutors, check the  tutor page.
• I have collected some links that might be of help to you on a links page.
• You can download the company database (Elmasri/Navathe): DDL part, DML part

Schedule

Classes and office hours

The class meets Th 5:45-9:00 (Lewis 1001).

My office hours are MTh 4:00-5:30.

During that time you can find me in the CS&T building, room 749.

If you want to set up an appointment at another time, or simply ask a question,

send email to mschaefer@cdm.depaul.edu.

Syllabus

For general information (literature, course summary), see the class syllabus.

Grades and exams

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

The midterm will take place during class in sixth week (2/14). It will be open book (closed notes).
You should know the material we covered up to how to do (outer) joins in oracle. The midterm 
will not cover aggregate functions, or grouping.

General Policies

Academic Honesty

• The course adheres to the university guideline on Academic Integrity Policy (http://www.depaul.edu/~handbook/code17.html):
  • 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 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 acknowledgment that it is someone else's. 
    • Copying of any source in whole or part with only minor changes in wording or syntax, even with acknowledgment. 
    • 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 acknowledgment.
• 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 possible expulsion.
• The use of others' web/publication content (text, graphics, codes) is regarded as plagiarism without giving credit (see the above description of plagiarism). 
• When you directly quote someone's work, you must put it in quotation marks. Without such quotations and reference, it is regarded as an act of plagiarism (see the above description of plagiarism).
• Using materials that the student prepared for other purposes (e.g., another course or for his/her work) needs the course instructor's prior permission.

Server Use

• Concerning the web site use, CTI adheres to the World Wide Web Policy (http://www.depaul.edu/policy.html) set by the university.
• The use of the servers is solely for educational purposes.  
  • The attempt to sell merchandises through the server is strictly prohibited.
  • The content of web pages students post on the server must not be indecent, defamatory and/or inflammatory.
  • When posting a prototype commercial web site for a course, students must indicate at least in the home page and the check-out pages that the site is a non-commercial in nature.
  • Along this line, students must indicate in their prototype web site that the viewers are not to enter their real personal information especially their credit card numbers.
  • The use of someone else's firm name, trademark, brand name, web content and/or web components (e.g., graphics, HTML code, scripts) is prohibited.
• It is students' responsibility to keep backups of their work on the server.
• The student does not use excessive amount of server resources (i.e., disk space, server CPU time).

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 the School of Computer Science, Telecommunications and Information Systems. Any consequences resulting from a poor grade for the course will not be considered as valid reasons for such a request.