• Lecture slides on Data Warehousing.
• Chapters to be covered at the final exam: 1, 2, 3, 4 (except 4.3.1), 5, 16, 17.1-4, 18, 19.1-6, 21 (except 21.5), 25 (except 25.4-6) plus the lecture on view materialization (slides above)
• Project 2 has been graded. Contact the TA for marks.
• No class on March 16.
• Chapters to be covered at the midterm: 1, 2, 3, 4 (except 4.3.1), 5. The exam is closed books. Partial solutions.
• E-mail policy
• Lecture Notes
• The Project
  • Project Assignment 1: Due Jan 26 Solutions
  • Project Assignment 2: Due March 2
  • Project Assignment 3: Due April 6
• Homework Assignments
  • HW1 due Jan 28 : 2.6, 3.16, 3.8 (2, 4, 5, 6) Solutions
  • HW2 due Feb 11: 4.5 (DRC only), 5.4, 5.8 (h-o) Solutions
  • HW3 due March 11: 19.2; 19.8 (1) d,e; 19.24 Solutions
  • HW4 due April 5: 17.2 (5,6,7,8,12); 17.4 S2 (1 and 2 only); 17.6; 18.4; 18.8, 21.4, 25.9 Solutions
• Exams
  • Midterm: Feb 25
  • Final: 13 Apr 2010 2PM CLH E

• For the textbook
  • On-line support materials by Raghu Ramakrishnan
    Includes:
    • General lecture notes related with the book.
    • Answers to the odd-numbered exercises in the book.
• DB2: Getting-started instructions (These notes are specific for us!)
• SQL
  • IBM: SQL, Getting Started (for DB2)
  • IBM: SQL Reference
• DB2: Lots more DB2 documentation
  • IBM DB2 Universal Database: Online Information
    Hosted locally here at York.

Description (from the academic calendar)

The purpose of this course is to introduce the fundamental concepts of database management, including aspects of data models, database languages, and database design. At the end of this course, a student will be able to understand and apply the fundamental concepts required for the use and design of database management systems.

Course Objectives

Students will become proficient at modeling databases at a conceptual and physical level of design. Students will be able to develop database schemas that enforce data integrity. Students will also become knowledgeable in the creation, altering, and manipulation of tables, indexes, and views using relational algebra and SQL.

Specific topics to be covered include:

• Relational Model
• Relational Algebra and Calculus
• The SQL Query Language
• Conceptual Design and the ER Model
• Transaction Management, Concurrency Control, and Recovery

This corresponds to the following chapters from the textbook: 1, 2, 3, 4, 5, 16, 17, 18, 19, and possibly 6 and 21.

Required Textbook / Reading

Database Management Systems.

Third Edition, 2003.

Raghu Ramakrishnan and Johannes Gehrke

WCB/McGraw Hill.

ISBN: 0-07-232206-3

URL: http://www.cs.wisc.edu/~dbbook

Useful Books / Reading

Understanding the New SQL: A Complete Guide

First Edition, 1993.

Jim Melton and Alan R. Simon.

Morgan Kaufmann Publishers.

ISBN: 1-55860-245-3

Using the New DB2: IBM's Object-Relational Database System

First Edition, 1996.

Don Chamberlin

Morgan Kaufmann Publishers.

ISBN: 1-55860-373-5

The grading policy is a standard one. The instructor will grade the exams. The TA will grade the projects. Projects and homeworks late no more than 48 hours will receive half of the credit. After 48 hour delay, no assignments will be accepted.

York University's rules for academic honesty and plagiarism are always remain in effect. Discussion is fine on the projects. However, collaboration is not. The work must be your own. Exams, of course, must be done on your own.

If you miss a midterm for good reason (e.g., illness with a medical document), your Final Exam grade will count for both the final exam and the missed exam.