·
Lecture: MWF, 2:30-3:20pm; Room:
Hollister B14
·
Instructor: Marcos Vaz Salles
o
Office
hours: Mondays, 1:15pm to 2:15pm Upson 4105A or by appointment.
·
TAs: Di Wu, Scott Rogoff, Sudip
Roy, Tao Zou, and Vivek Radhakrishnan. You can reach the TAs by sending email
to cs4320-staff-l “at” lists “dot” cs “dot”
cornell “dot” edu
o
Office
hours: Wednesdays, 1:15pm-2:15pm (Sudip & Di Wu); Thursdays, 1:30pm-2:30pm
(Scott & (Vivek | Tao)), in Upson 328B.
o
Newsgroup: The newsgroup for this
course is cornell.class.cs4320.
You will find instructions on how to set up access to newsgroups here.
·
Course Management System. The homework assignments,
grades, course schedule, and lecture notes are available via CMS.
·
Textbook: Raghu Ramakrishnan and
Johannes Gehrke. Database Management
Systems. Third edition, 2002.
Course
Description
CS4320 gives an
introduction to relational database systems. Topics covered include the
relational model, SQL, transactions, database design, and concepts and
algorithms for building database management systems. Students are encouraged to
concurrently enroll in CS4321 (Practicum in Database Systems) as well. The textbook is required,
but the contents of the book do not constitute the syllabus for the course -
the classroom lectures define the course content, and the textbook is a
reference. You may find a tentative
schedule for the course here.
Prerequisites
CS4320 will assume knowledge
of material covered in CS2110 (Object-Oriented Programming and Data Structures)
and CS3110 (Data Structures and Functional Programming).
Grading
The grades for CS4320 will be
determined based on four homework assignments (50%) and two exams (50%).
Four
Homework assignments
(50% of your grade, 12.5% each). Details about the homework assignments can be
found in CMS.
Exams
(49% of your grade)
Course
Evaluation (1%
of your grade). Cornell is deeply committed to continuous improvement of
teaching quality. As a consequence, we assign 1% of the grade to filling out
the course evaluations at semester end. CourseEval opens to students November
29 and closes December 8, 6pm.
Late submissions
policy
All homework
assignments have to be submitted via CMS in electronic format. You may submit
scanned PDF files of your homework assignments, but there is a limit on upload
size and it is your responsibility to make sure in time that the upload of
scanned files succeeds. If there is a problem, submitting via email or on
paper is not an option. We suggest
composing the homework assignments using a text editor or latex and creating a PDF
file for submission.
The assignments
have strict deadlines that are at 11:59pm on the day indicated in the deadline.
If you submit the assignment up to 24 hours late, there will be a 15% penalty. If
you submit your assignment between 24 and 48 hours late, there will be a 30%
penalty. This may sound strict, but we want to be fair and have the same rules
for everyone. We will try to provide the best help possible to make you succeed
with the assignments, but you will have to grant sufficient time to finish your
homework assignments and submit them before the deadline.
Academic
Integrity
Students at Cornell are expected to follow a strict Code of Academic Integrity,
which is taken very seriously in the Department
of Computer Science and in CS432. If you are taking CS4320 or CS4321,
please print and sign the Academic
Integrity Form. You can hand your signed form to us in class.
Job interviews
Many students who
take CS4320/1 also have job interviews in the fall. Please make sure not to
schedule any interviews such that you cannot attend the exams. We cannot move
exams because of interviews and we also cannot provide makeup exam. Makeup
exams can only be scheduled for serious medical reasons, not because of job
interviews. We know that some companies behave inflexibly regarding
interview dates (notably, Microsoft), but in this case you will have to state
firmly that it is a Cornell rule that exams have priority (which is true). It
is important not to tell recruiters that there is a possibility of moving the
exam, because it is not true and they will take your word on it. Please keep in
mind that traveling takes time: you should not schedule interviews a day before
or after an exam, particularly if the interview is on the West Coast.