Index of class resources

Handouts — homework problem sets, homework solutions, other helpful handouts
General Class Information — class and section times, instructor and TA information
Academic Dishonesty Policy — UCSC and class policies prohibiting cheating

• Course Objectives
• Prerequisite: CMPS 101 is required
• Course Outline, Schedule, and Lecture Notes
• Homework Assignments and Projects
• Grading

Lecture times:

Tuesday and Thursday, 2:00 to 3:45 p.m., Natural Science Annex 101

Associated Lab:

The project will be done on a computer running Linux and PostgreSQL. You will connect to this computer using SSH from another computer. There will be scheduled hours in a lab when the TA or grader will be available to answer questions. However, you may use that lab or another one on campus when they are not otherwise reserved.

Instructor:

Name: Arthur M. Keller (ark@soe.ucsc.edu)

Phone: +1(831)459-1485

Office: Baskin Engineering 359B

Instructor Office Hours:

Tuesdays 4:30-5:30 and by appointment

Teaching Assistant:

Name: Ye Bao (yebao@cse.ucsc.edu)

Office Hours:

Monday: 9 a.m. - 12 n., 5 - 7 p.m., Crown 201

Wednesday: 10 a.m. - 12 n., 5 - 7 p.m., Crown 201

Friday: 10 a.m. - 1 p.m., Baskin Engineering 352

Grader:

Name: Thomas Belote (tbelote@cats.ucsc.edu)

Office Hours:

Before April 18:

Tuesday and Thursday: 10 a.m. - 12:30 p.m., Crown Study Room

After April 21:

Tuesday and Thursday: 6. - 8:30 p.m., Crown 201

Class Newsgroup:

NEWSGROUP ucsc.class.cmps180 - for announcements, general discussion, and help

Textbook:

Required, one of these:

• Database Systems: The Complete Book, by Garcia-Molina, Ullman, and Widom (first edition), Prentice Hall, 0-13-031995-3, 2002.
• A First Course in Database Systems, by Ullman and Widom (second edition), Prentice-Hall, 0-13-035300-0, 2002.
• Note: You may download the first two chapters if you are uncertain about taking the course. You may download Chapter 1 in Postscript or PDF and Chapter 2 in Postscript or PDF. Unless otherwise specified, all reading assignments will be from this textbook. Errata can be found here.

Recommended: Students may find it helpful to have one of these books as a reference for the SQL language.

• A Guide to the SQL Standard: A User's Guide to the Standard Database Language SQL, (fourth edition), by C.J. Date and Hugh Darwen, Addison-Wesley, 2000.

• SQL: 1999 - Understanding Relational Language Components, (first edition), by Melton and Simon, Morgan Kaufmann.

Students may find it helpful to have a PostgreSQL reference manual.

• PostgreSQL: Introduction and Concepts, by Bruce Momjian, Addison-Wesley, 2001. This book is also available from the web, although many people prefer the convenience of a printed and bound copy.

Occasionally, especially when working problem sets or writing programs (but never on exams!), it may be necessary to ask someone for help. You are permitted to do so, provided you meet the following two conditions.

1. You acknowledge the help on the work you hand in.

2. You understand the work that you hand in, so that you could explain the reasoning behind the parts of the work done for you by another.

Any other assistance by another person constitutes academic dishonesty and will be treated as such.

We shall not deduct credit for small amounts of acknowledged assistance. Even working as a team on one of several problems in a problem set may not hurt your grade, as long as all members of the group acknowledge their collaboration. Such shared interest can be beneficial to all concerned. We do reserve the right to give less than full credit in circumstances where it appears that there has been large-scale division of labor, and you are not getting as much learning out of the assignment as you should. However, as long as you acknowledge your sources, you cannot get into academic dishonesty trouble.

If you have any questions about what this policy means, please discuss the matter with the instructor now.

Any confirmed academic dishonesty including but not limited to copying papers or cheating on exams, will constitute a failure of the ethics standards of this class and will result in a no-pass or failing grade. You are encouraged to read campus policies regarding academic integrity.

We shall ask everyone to acknowledge that they have read the above material on the class signup sheet.