Lectures: Tuesday and Thursday, 2:00-3:45 PM, Engineering 2 #192

Lab Sections:

Monday and Wednesday, 9:00-11:00AM, JBE 105

Tuesday and Wednesday, 5:00-7:00PM, JBE 105

Instructor:

Neoklis Polyzotis

E-mail: alkis@cs.ucsc.edu

Office: E2#353

Phone: x9-1304

Office Hours: Tuesday, 9:00 - 11:00 AM, or by appointment.

Teaching Assistant:

Doxa Chatzopoulou

E-mail: gloha@soe.ucsc.edu

Office: BE 314A

Office Hours: TBA

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

Topic	Lectures
Introduction	1
E-R Model	1
Relational Model	1
Relational Algebra/Calculus	1-3
SQL	1-2
Transaction Management	1
Functional Dependencies	1-2
Data Storage and Buffering	1
Indexing	1-2
Query Evaluation	1
Logical Query Languages	1
Alternative Data Models	1-2

Grading

Homework Assignments:	15%
Lab Assignments:	20%
Midterm Examinations:	30%
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

Thursday, 3/8 - Instructor away

Exam Schedule

Midterm: Thursday Feb 7, 2:00-3:45PM, Engineering 2 #192

Final: Tuesday March 18, 4:00 - 7:00PM, Engineering 2 #192

 

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.

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.