CMPS 180 Database Systems - Winter 2006

• News and Announcements
• Class Description
• General Class Information
• Class Schedule
• Homework and Lab Schedule
• Evaluation
• Acdemic Dishonesty Policy
• Useful Links

News and Announcements

• March 14 - Lab 4 deadline is extended to tomorrow (Wednesday), late submission deadline is Thursday. Come to the lab tomorrow if you still have problems.
• March 8 - The review for final is on next Tuesday (2-3:45PM).
• Feb 28 - Lab 4 is released (due on March 14), start early, this lab is heavy.
• Feb 21 - Homework 4 is released (due one March 7) and Class note 9 has been posted.
• Feb 14 - Lab 3 is released (due on Feb 28).
• Feb 10 - Class note 7 and 8 have been posted. I've tried to resize the PDF files, but they are still quite large (15.4MB and 17.7MB), so it might take some time to download. Please do me a favor by sending smaller scanned PDF files (use a lower resolution or the FREE scan&email machine in E2 second floor, it requires your student copy card, but won't charge you).
• Feb 7 - Class note 6 has been posted. Homework 3 has TWO parts: hw3 in homework section and lab3 in lab section, please don't miss the lab part. Midterm will be on next Thursday and we will have a brief review next Tuesday.
• Jan 31 - Lab 1 is due and Lab 2 is released (due after two weeks).
• Jan 27 - Class note 5 (15MB) has been posted, it is a big file and takes a while to load.
• Jan 25 - Class note 4 has been posted.

Previous News and Announcements

Class Description

Introduction to the concepts, approaches, tools, and methodology of database design. Covers the entity-relationship model, the relational model, relational algebra, relational calculus, commercial languages (such as SQL and QBE), functional dependencies, normal forms, and design theory. Other topics may include knowledge-bases, constraint databases, and alternative database models.

General Class Information

Lecture Time and Location — Tue & Thur: 2-3:45pm @ BE165 (directions).
Lab and Discussion Sections — WF 9-11am@ BE105
Instructor — Professor Wang-Chiew Tan (wctan@cs.ucsc.edu) Office Hour (TuTh, 12.45 to 2pm@E2-343B)
Teaching Assistant — Guozheng Ge (ggz@ucsc.edu) Office Hour (Wednesday 11:30-1:30pm@E2 392)
Textbook — Database Management Systems (3rd Edition) by Ramakrishnan and Gehrke, McGraw Hill 2003
Newsgroup — Please register at SOE online class forum and post class-related information at cmps180, we abandoned UCSC newsgroup server is not easily accessible from off-campus.
Class Schedule in PDF

Class Schedule (Tentative)

Topic	Number of Lectures
Introduction and Basic Concepts	1
Entity-Relationship Model	1
The Relational Data Model	1
SQL: Queries, Constraints, Triggers	4
Relational Algebra and Relational Calculus	4-5
Schema Refinement and Normal Forms	4-5
Database Application Development	1
Deductive Databases and Datalog	1-2
Overview of Query Evaluation	1-2
Midterm	1

Class notes (accessible from on campus or via password)

• Class note 1 (Jan 11, 2006)
• Class note 2 (Jan 12, 2006)
• Class note 3 (Jan 17, 2006)
• Class note 4 (Jan 24, 2006)
• Class note 5 (Jan 26, 2006)
• Class note 6 (Feb 2, 2006)
• Class note 7 (Jan 31, 2006)
• Class note 8 (Feb 9, 2006)
• Class note 9 (Feb 23, 2006)

Homeworks and Lab Schedule

Click here to get to the homework section (accessible from on campus or via password)

Homework 1 is out (due on 1/19)

Homework 2 is released (due on 2/2)

Homework 3 is released

Homework 4 is released (due on 3/7)

Lab Assignments:

• Deadline for submissions: midnight on the due date
• Late deadline: 48 hours after deadline, 50% will be discounted for late penalty
• Submission format: use lab tools ONLY, e.g. UNIX submit command, unless otherwise required in lab instructions

• Prep Lab (Jan 9, 11): Introduction to Lab Policies and Tools (no submission)
• Lab 1: Introduction to Postgresql (due on Jan 31)
• Lab 2: SQL Programming (due on Feb 14)
• Lab 3: SQL Programming II (due one Feb 28)
• Lab 4: JDBC Programming (due on March 14)

Evaluation

Schedule of homeworks, labs, quizes, midterm and final plus percentage of each item toward you final class score.

Items	Percentage
Two in-class Quizes (1/2 hour each) Quiz 1: Jan 26 (Thu), 2-2.30pm Quiz 2: Mar 2 (Thu), 2-2.30pm	10%
Midterm: Feb 16 (Thu), 2-3.30pm	30%
Final Exam: Mar 20 (Mon), 4-7pm	30%
Homework	15%
Lab Assignments	15%

The dates for the examinations and quizzes are fixed. Requests for changes in the schedule will NOT be accommodated.

Academic Dishonesty Policy

No form of academic dishonesty will be tolerated. You are encouraged to read the campus' policies regarding 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.  

Useful Links

• Companion Website for the Textbook
• Practical Postgresql by John Worsley and Joshua Drake, edited by Andrew Brookins and Michael Holloway.
• Safari Tech Books Online (accessible from UCSC campus or use a Library Proxy when off-campus) to find DB, Postgresql, JDBC, and Java programming resources.
• Philip Greenspun's "SQL for Web Nerds"