CSE-3421M
Introduction to Database Systems
York University
Winter 2014
Class Homepage
Instructor: Parke Godfrey
Office: #2050 LAS
Office Hours: We 3–5pm
& by appointment / availability
Ph#: 416-736-2100 x66671
e-mail: godfrey@cse.yorku.ca
T.A.: Jason Yan Chen
Office: #2057 LAS
Office Hours: Tu 7–8:30pm
e-mail: ychen@cse.yorku.ca
Term: Winter 2014
Time: Tu & Th 5:30–7:00pm
Place: Ross S205
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.cse.yorku.ca/course/3421/

Welcome to the course Introduction to Database Systems, CSE-3421 for winter term 2014. 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 accumulating on ePost.

  • The final exam for the course will be 14:00—17:00 Saturday 19 April 2014 in TEL 0016.

  • Project #4, The Apt APP, is up and running.

    Due by 11:59pm Sunday 6 April 2014.

  • Project #3, SQL Jeopardy is up and running.

    Due by 11:59pm Friday 4 April 2014.

  • Test #2 on Thursday 13 March 2014 (during lecture time in the usual room).

  • Project #2, Creating a Database, is up and running.

    Due by 11:59pm Tuesday 11 March 2014.

 
  Materials
Syllabus
Syllabus
Lecture Notes

  1. Introduction
    • Databases: Asking the Computer Questions. PDF
  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.