Introduction to Database Management -- Spring 2017

CS 464 / 564 


Announcements Syllabus Homework Project Slides Useful Links


Syllabus

Email Address for the Instructors and TAs:  cs.464.564.teachers@gmail.com


Instructor: Prof. Abdullah Mueen
Office: Travelstead Hall, B01A
Office Hours: Monday 1:00PM-3:00PM, Tuesday 10:30AM-12:00PM. other times by appointment (Knock if you see the door closed. I am inside).
Office Phone: 505-277-1914

TA: Haleh Falakshahi <hfalakshahi@cs.unm.edu>

Office Hours: Monday 2:30 PM – 4:00 PM    and  Wednesday 11:30 AM – 1:00 PM

Office Location: Center for Advanced Research Computing CARC Office: 1000 D

1601 Central Ave. NE

Albuquerque, NM 87106

hfalakshahi@cs.unm.edu





Lecture:
Tuesday, Thursday 2:00-3:15 PM, Centennial Engineering Center B146A

Textbook: Database Systems, The Complete Book (2nd Edition), Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom, Prentice Hall 2009. In addition, I will use this book as a reference for exercises and exams.

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

Week of Topic Reading
1/16 Introduction; Relational Model; E/R Model Chs 1,2,4
1/23 E/R Model; Functional Dependencies Chs 4, 3
1/30 Functional Dependencies, Normalization Ch 3
2/6 Relational Algebra Chs 2, 5
2/13 SQL & Transactions Chs 6, 2, 8
2/20 SQL in a Webserver Chs 9
2/27 Constraints and Triggers + Exam Chs 7, 8
3/6 More on SQL Ch 7
3/13 Spring Break - No Class n/a
3/20 Data Storage and Representation Ch 13
3/27 Index Structures Ch 14
4/03 Query Execution + Exam Ch 15
4/10 Query Compiler Ch 16
4/17 Coping with Failures Ch 17
4/24 Concurrency Control Ch 18
5/01 Project Presentations + Exam 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 homework / 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 roughly 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%. 
CS 464 and 564 sections will be graded separately.


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

Homework

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


Project

Click Here for the details.

Back to beginning


Slide

All slides are in Learn. Midterm 1 is on first eight slides. Note that SQL is not included in Exam 1.

Midterm 1 : Mar 7, 2017
Midterm 2 : April 11, 2017
Final : May 4, 2017.
   
      In addition, the final exam will include materials from the following slides.

Back to beginning

Useful Links


Announcements Syllabus Homework Project Slides Useful Links