CMPS180 :: Database Systems (Winter 2007)

http://www.soe.ucsc.edu/classes/cmps180/Winter07

Lectures: Monday, Wednesday, Friday, 12:30-1:40 PM, Soc Sci 2 075
Lab Sections:
Monday and Wednesday, 4:00-6:00PM, BE 105
Tuesday and Thursday, 9:30-11:30AM, BE 105
Instructor:
Neoklis Polyzotis
E-mail: alkis@cs.ucsc.edu
Office: E2#353
Phone: x9-1304
Office Hours: Monday and Wednesday, 2:30 - 4:00 PM, or by appointment.
Teaching Assistant:
Chong Sun
E-mail: sunchong@soe.ucsc.edu
Office: BE 314A
Office Hours: Tuesday, 2:00-3:30PM
On-line Forum: CMPS 180

Textbook:
Database Systems: The Complete Book, Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom.

The course will cover mostly chapters 1-10, plus selected topics from the remaining chapters (as time permits).

Syllabus
TopicLectures
Introduction1
E-R Model1
Relational Model1
Relational Algebra/Calculus1-3
SQL1-2
Transaction Management1
Functional Dependencies1-2
Data Storage and Buffering1
Indexing1-2
Query Evaluation1
Logical Query Languages1
Alternative Data Models1-2

Grading
Homework Assignments:15%
Lab Assignments:20%
Midterm Examinations:30%(15% each)
Final Examination:35%
Most homework assignments will use the Gradiance on-line homework system. Each student will need a unique code in order to gain access to the homeworks. The Bookstore carries a copy of the textbook that includes an access code. The alternative is to purchase an access code separately from the textbook. Please contact the instructor if you have any questions on this matter.

Holidays/No Class
Monday, 1/8 - Instructor away
Monday, 1/15 - Holiday
Monday, 2/19 - Holiday
Exam Schedule
Midterm 1: Wednesday Jan 31, 12:30 - 1:20 PM, Soc Sci 2 075
Midterm 2: Friday Feb 23, 12:30 - 1:20 PM, Soc Sci 2 075
Final: Monday March 19, 12:00 - 3:00 PM, Soc Sci 2 075
 
Note: The exam dates are fixed and cannot be changed.

Academic Dishonesty Policy

No form of academic dishonesty will be tolerated. You are encouraged to read the campus' policies regarding academic integrity (http://www.ucsc.edu/academics/academic_integrity).

You are allowed to ask for help when working on homework and lab assignments, provided that you acknowledge, on the work that you turn in, the help that you received. Points will be deducted if it appears that labor has been divided among multiple students; otherwise, there will be no penalty for small amounts of acknowledged assistance.

If you have any questions about these rules, please discuss them with the instructor immediately.