CSC 480: Database and File Systems, Spring 2011

Overview

Text:

Edward Sciore, "Database Design and Implementation," John Wiley & Sons, October 2008

Course Description:

(from the Catalog) This course provides an external and an internal view of relational database management systems (DBMSs). The external view consists of database design and implementation. The database query and manipulation languages SQL and QBE will be studied to the degree that students will be able to become proficient in these languages on their own. The internal view involves characteristics of secondary storage devices, methods of organizing information, various file organization and accessing techniques and other topics related to database engine implementation. Programming assignments complement topics discussed in class, including the building of a few key components of a database engine.

Grading:

The grade for this course will be based on the following:

• 10%: Quizzes -- most classes will start with a short quiz, to encourage you to keep up with the reading; to avoid penalizing those who might miss a day or two, the bottom two quiz grades will be dropped
• 20%: Programming projects (Likely 3 or 4) -- working in pairs OK
• 20%: Homework assignments
• 20%: Midterm exam (Thursday, March 17)
• 30%: Final exam (Wednesday, May 18, 1-4 pm)

Policy Statements:

• You are expected to attend all class sessions. However, I expect you to take your own education seriously, so I do not keep formal attendance records. If you miss a class, you are responsible for catching up with the material that was covered and any announcements that were made.
• An important part of this course will be classroom dialogues on system design issues, so it is essential that you come to class each day prepared to discuss the assigned readings.
• Homework assignments and programming projects are due by the start of class on the assigned date. Late submissions will be accepted until the next class time at a penalty of half the grade. Extensions will be considered only by prior arrangement.
• Programming projects will be graded on style and efficiency as well as correct operation. To develop as a programmer, you are strongly encouraged to do more than the minimum assigned amount of work; the best way to learn good style and common idioms is to read and write lots of code.
• Cheating, plagiarism, submission of the work of others, etc., violates the DePauw policy on academic integrity and may result in penalties ranging from a lowered grade to course failure or expulsion. The policy and discussion of each student's obligations and rights are in the Student Handbook.
• With respect to this course, no collaboration is permitted on exams or quizzes. You may discuss homework problems and programming assignments with anyone you want (in fact, you are encouraged to do so), but you should not copy another student's work nor permit your work to be copied. The key idea is that you should understand all of the work you turn in, and you should be able to replicate it on your own. If you do not feel that you can replicate the work independently, then it is not fair (to yourself or to others) to submit it as your own work. If at any time you are uncertain what constitutes "appropriate" collaboration, it is your responsibility to clarify it with me.
• During class time, the computer at your seat should be used for note-taking, classroom interaction, and in-class exercises. You are not permitted to read e-mail, browse the web, play games, etc. while class is in session.

Calendar:

Week	Tuesday	Thursday
1	Feb. 1	3
2	Feb. 8	10
3	Feb. 15	17
4	Feb. 22	24
5	Mar. 1	3
6	Mar. 8	10: No Class
7	Mar. 15	17: Midterm
Spring Break
8	Mar. 29	31
9	Apr. 5	7
10	Apr. 12	14
11	Apr. 19	21
12	Apr. 26	28
13	May 3	5
14	May 10	12
Final Exam: Wednesday, May 18, 1 pm

DePauw University, Computer Science Department, Spring 2011
Maintained by Brian Howard (bhoward@depauw.edu). Last updated