Lectures: Monday, Wednesday, Friday, 9:30-10:40 AM, Porter Acad 144

Lab Sections:

Monday and Wednesday, 5:00 - 7:00 PM, Soc Sci 1 123

Tuesday and Thursday, 2:00 - 4:00 PM, Soc Sci 1 123

Instructor:

Neoklis Polyzotis

E-mail: alkis@cs.ucsc.edu

Office: E2 353

Phone: x9-1304

Office Hours: Monday 2:00 - 4:00PM, or by appointment

Teaching Assistant:

Yali Wang

E-mail: ylwang@soe.ucsc.edu

Office: BE 314

Office Hours: Tuesday 11:00AM-12:00PM

Textbook:

Database Management Systems (3rd Edition), R. Ramakrishnan and J. Gehrke, McGraw-Hill.

The course will cover chapters 1-5, 16, and 19, plus selected topics from chapters 8-10, 12, 24, and 27 (as time allows).

Syllabus

Topic	Lectures
Introduction	1
Relational Model	2
Relational Algebra/Calculus	2
SQL	2
Views and Authorization	1
Integrity Constraints and Triggers	1
Functional Dependencies and Database Design	2
ER Modeling	1
Transaction Management	2
Recursion in SQL	2
Object Relational Systems	1
XML + XPath + XQuery	2
Data Warehousing and Data Mining	1

Grading

Homework Assignments:	15%
Lab Assignments:	20%
Midterm Examination:	30%
Final Examination:	35%

Exam Schedule

Quiz 1: Wednesday Oct 12, 9:30-10:40AM , Porter Acad 144

Quiz 2: Friday Nov 4, 9:30-10:40AM, Porter Acad 144

Final: Monday Dec 5, 8:00-11:00AM, Porter Acad 144

 

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.