Introduction to Database Management

CS 464 / 564

Announcements Syllabus Homework Project Slides Useful Links

Announcements (most recent on top)

Back to beginning


Instructor: Prof. Lydia Tapia
Office: 349E
Office Hours: M 9:30-10:30, W 2:00-3:00, F 2:00-3:00; other times by appointment
Office Phone: 505-277-0858

TA: Wayne Just
Office: 301A
Office Hours: Tuesday 1:30-3:30; Friday 10:00-11:00am; other times by appointment

Course URL:

Lecture: Monday, Wednesday, Friday 1:00-1:50 PM, MECH-208

Textbook: Database Systems, The Complete Book (2nd Edition), Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom, Prentice Hall 2009.

Course Content and Tentative Schedule: The course will cover the following topics.

Week of Topic Reading
1/14 Introduction; E/R Model Chs 1, 4
1/21 E/R Model; Relational Model Chs 4, 2
1/28 Functional Dependencies, Normalization Ch 3
2/04 Relational Algebra Chs 2, 5
2/11 SQL & Transactions Chs 6, 2, 8
2/18 SQL in a Webserver Chs 9
2/25 Constraints and Triggers Chs 7, 8
3/4 Data Storage Ch 13
3/11 Spring Break - No Class n/a
3/18 Data Representation Ch 13
3/25 Index Structures Ch 14
4/1 Query Execution Ch 15
4/8 Query Compiler Ch 16
4/15 Coping with Failures Ch 17
4/22 Concurrency Control Ch 18
4/29-5/3 Project Presentations n/a

Assignments and Grading: All assignments will be announced in class and posted on the course web page. If you miss class for any reason, it is your responsibility to find out what assignments you missed.

Your grade will be based on four components:
No late assignments will be accepted. There will be no make-up exams except for university-excused absences. Please discuss unusual circumstances in advance with the instructor.

Course grades will be assigned according to this scale:
A for 90% or above of the total points,
B for 80 to 89%,
C for 70 to 79%,
D for 60 to 69%,
and F for less than 60%.

Academic Integrity: For everyone's benefit, students should uphold the guidelines in the University of New Mexico Student Code of Conduct.

For the assignments in this class, discussion of concepts with others is encouraged, but all assignments must be done on your own, unless otherwise instructed. If you use any source other than the text, reference it/him/her, whether it be a person, a book, a solution set, a web page or whatever. You MUST write up the solutions in your own words. Copying is strictly forbidden.

Americans with Disabilities Act (ADA) Policy Statement: The Americans with Disabilities Act (ADA) is a federal antidiscrimination statute that provides comprehensive civil rights protection for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the Department of Student Affairs, Accessibility Resource Center in Mesa Vista Hall, Rm. 2021.

Back to beginning


NOTES: Page numbers below are given for the paper copy of the text book. If you use the electronic edition, the page numbers might be different. However, the Exercise numbers will be the same. The Exercises follow a standard numbering format, e.g., 4.1.2 is in Chapter 4, Section 1, and is Question number 2. Back to beginning


Details are available for 464 students here.

Details are available for 564 students here.

Back to beginning


Midterm 1 Midterm 2 After Midterm 2 Back to beginning

Useful Links

Announcements Syllabus Homework Project Slides Useful Links