CS 410 Database Systems

Course Syllabus - Fall 2009

Course Instructor	Dr. Chengcui Zhang Email: zhang@cis.uab.edu Web: http://www.cis.uab.edu/zhang Office: CH 127 Phone: (205)-934-8606 Office Hours: Tuesday 10am-12noon or by appointments.
Teaching Assistants	Song Gao gaos@cis.uab.edu (Office hours: TBA)
Course Session	M/W 04:00 PM - 05:15 PM Room CH 430
Course Homepage	http://www.cis.uab.edu/cs410/fall2009/
Prerequisite	CS 303 Algorithms and Data Structures
Description	Overview of database management; data independence; Relational Algebra; normal forms; the three levels of database system architecture; SQL language; security and integrity.
Objectives	To introduce the student to the relational database model, the SQL data manipulation language, DBMS architecture and utilities, database design, and issues of security and integrity.
Textbook	A First Course in Database Systems. 3rd edition. Jeffrey D. Ullman and Jennifer Widom. Prentice Hall. URL: http://www-db.stanford.edu/~ullman/fcdb.html OR Database Systems: The Complete Book (DS:CB), by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom. 2nd edition. Prentice Hall. URL: http://infolab.stanford.edu/~ullman/dscb.html
Grading Policy	Mid-term Exam 20% each Homework 30% overall Class Participation 10% overall Project & demo 20% Final Exam 20% (A: ≥ 90, B: (<90 & ≥80), C: (<80 & ≥70), D: (<70 & ≥65), F: (<65) All tests, lab exams and final exam are mandatory.
Late Submission	1. All assignments are due at the beginning of class on the due date. Any assignment turned in after this deadline is considered late. Late assignments will lose 10% for every 24-hour period, up to a maximum of 50% (weekends and holidays count as one 24-hour period). 2. All assignments must be turned in even if they are late. Failure to submit any assignments will result in a grade of F.
Class Conduct	1. Students are expected to conduct themselves in a professional manner. 2. Laptops will be allowed only for the purpose of the class. 3. During a lecture, students may NOT log into a machine and do work that is not directly related to the topic of the current lecture. 4. Students must turn their cell phones/pagers OFF during the class.
Class Attendance	1. Attendance is mandatory for the lecture portion of this course. If you know you will be absent for a legitimate reason, let the instructor know. If you are sick, bring a doctors excuse or a written university excuse to resolve the absences. An absence has to be resolved as soon as possible - otherwise it will be treated as an unexcused absence. Students will receive a penalty of two percentage points on the final grade for each unexcused absence beyond the third absence (excused or unexcused). 2. Students auditing this course are expected to attend the lectures. Auditing students with more than three unexcused absences will receive a failing grade. 3. There will be NO make-ups for the mid-term exam. If you miss the mid-term exam for a legitimate reason, your final exam grade will replace that test grade. If the absence is unexcused, you will be assigned 0 for the test. A student anticipating an excused absence for the final exam should make arrangements in advance to take the exam at another time.

Academic Honesty	Students who plagiarize a computer program (or parts of a program), get others to write a program (or parts of a program), or are found cheating on a quiz/exam, will be reported for academic dishonesty. Anyone who is caught cheating will receive a 0 on a given test or assignment. If a second offense occurs, the student will receive an F in the class. This includes both the provider of the information as well as the receiver of the information. Any student who violates the university's academic honesty policy will be reported for academic discipline. All university and department policies related to students are included here by implication.
Add/Drop Policy	1. A student can add the course through Aug. 25, 2009 2. A student can drop the course without paying full tuition by Aug. 25, 2009. 3. A student can withdraw with a W by Oct. 14th, 2009. 4. For more details about add/drop policies check with Registration/Academic Records.
E-mail	*Every student will be required to use his/her official email address (that is, blazerid@uab.edu).* New students must login and configure their email addresses. For more details on obtaining a blazerid and configuring email, please see: http://www.uab.edu/blazerid. All email communications will be made using this address. Additional instructions or announcements will be sent by e-mail, so check your mail often - at least twice a day (once in the morning and once at night). Also, check the course webpage for up-to-date information and announcements. The instructor will check email frequently; e-mail is often the best way to contact the instructor.
To Apply for a CIS Account	http://www.cis.uab.edu/cisweb/it/accountApplication.php
PostgreSQL Quickstart Guide	https://www.cis.uab.edu/postgresql_quickstart

Tentative Schedule for Lectures
Updated Aug. 19^th, 2009

Date	Topics	Comments
Aug 19 Aug 24 Aug 26	Chapter 1 - Introduction Chapter 4 - The E-R Data Model
Aug 31 Sep 2	Chapter 4 - The E-R Data Model (continued)
Sep 7 Sep 9 Sep 14 Sep 16 Sep 21	Labor Day Holiday Finish Chapter 4 (Lecture2, Lecture3) Lab Session* Chapter 2 - The Relational Data Model	Assign Homework 2 Assign Homework 3 Part I, Part II
Sep 23 Sep 28 Sep 30 Oct 5 Oct 7 Oct 12 Oct 14	Chapter 2 and 3- The Relational Data Model (Lecture4, Lecture5, Lecture6) Chapter 5: Relational Algebra (Lecture7) Class review Midterm Exam	Term Project Assign Homework 4 Homework 4
Oct 19 Oct 21	Chapter 5: Relational Algebra (Lecture8) Chapter 6: SQL (Lecture9, Lecture10)
Oct 26 Oct 28
Nov 2 Nov 4 Nov 9 Nov 11 Nov 16	Chapter 7 Constraints and Triggers (Lecture11)	Homework 5
Nov 18 Nov 23 Nov 25 Nov 30 Dec 2 Dec 3 Dec 4	Chapter 8 - System Aspects of SQL (Lecture12) NO Class Class Review & Project Demo(last day of class) Project Demo Weather day	Thanksgiving Holidays
Dec 7 4:15pm-6:45pm	Final exam	(comprehensive)