EECS-3421A
Introduction to Database Systems
York University
Fall 2015
Class Homepage
Instructor: Parke Godfrey
Office: #2050 LAS
Office Hours: We 3–5pm
& by appointment / availability
Ph#: 416-736-2100 x66671
e-mail: godfrey@yorku.ca
T.A.: To be announced...
Office:  
Office Hours:  
e-mail:  
Term: Fall 2015
Time: Mo & We 1:00–2:30pm
Place: CB 115
Textbook: Raghu Ramakrishnan & Johannes Gehrke
Database Management Systems
Third Edition, 2003
WCB/McGraw Hill.
ISBN: 0-07-246563-8
URL: http://www.cs.wisc.edu/~dbbook
Class URL: http://www.eecs.yorku.ca/course/3421/

Welcome to the course Introduction to Database Systems, EECS-3421 for fall term 2015. Materials, instructions, and notices for the course will accumulate here over the semester.

 
  Class Bulletin Board

Class notices will accumulate here over the term. Be certain to check here regularly.

Also, be certain to refresh this page via your browser when you visit to ensure that you are not looking at an old, cached copy. Otherwise, you can miss the latest message.

Marks will accumulate on ePost.

  • Project #4, The Apt App, is up and running. (It is essentially like an 11th query from Project #3.)
    Due by 11:59pm Monday 7 December 2015. (Accepted up to a couple of days after without penalty.)

  • Project #3, SQL Jeopardy, is up and running.
    Due by 11:59pm Friday 4 December 2015.

  • Test #2 coming up on Wednesday 18 November!

  • Due date for Project #2 moved to the 11th.

    Test #2 moved to Wednesday 18 November (from Wednesday 11 November, as in the original schedule).

  • Project #2, Voilà: Creating a Database, is posted.

    Due by 11:59pm Wednesday 11 November 2015. Due by 11:59pm Wednesday 4 November 2015.

  • Project #1, Scheming a Schema: The Howling , is posted.

    Due before class Wednesday 14 October 2015.

  • Welcome to the class!

 
  Materials
Syllabus
Syllabus
Lecture Notes

  1. Introduction
    • ...
  2. Design
    1. E-R Modeling
      1. Chapter 2 textbook slides: 1-per (PDF)
      2. E-R guidelines & example: 1-per (PDF), 4-per (PDF)
      3. E-R bookstore example: 1-per (PDF), 4-per (PDF)
    2. The Relational Model
    3. Normalization
      1. Chapter 19 textbook slides: PDF (1 per), PDF (6 per)
      2. Formal definition chart of the normal forms: PDF
  3. Queries
    1. The Relational Algebra & Calculus
      1. Chapter 4 Textbook Slides / Part A (Relational Algebra): PDF (1 per), PDF (6 per)
      2. Chapter 4 Textbook Slides / Part B (Relational Calculus): PDF (1 per), PDF (6 per)
    2. SQL
  4. Applications
    1. Codd's Twelve Commandments: PDF (1 per)
    2. Application Programming
      1. Chapter 6 Textbook Slides (modified): PDF (1 per), PDF (2 per), PDF (6 per)
      2. JDBC, a practical guide: PDF (1 per), PDF (2 per)
      3. IBM DB2's SQL/PL, a brief example: PDF (1 per), PDF (2 per)
    3. Internet Applications & Multi-tier Systems
    4. Transaction Management
      1. System Overview:
        PDF (1 per), PDF (4 per)
      2. ACID & Transaction Management (for Chapter 16):
        PDF (1 per), PDF (4 per)

Resources

 
  Projects, Tests, etc.