• Please send Project 3 directly to the TA: baoxchen@cse.yorku.ca

• All lectures given by Professor Godfrey during the strike have been recorded and are available here. They contain the same material that was covered in our section.
• April 2: Review Session.
• March 26: Crash Recovery. Examples.
• March 19: Concurrency. Examples.
• March 12: Constraints, triggers. Authorization. Example of authorization graph.
• March 5: Discussion of the midterm, Examples of constraints.

• The final exam has been rescheduled to April 23 at 7PM.
• The due date for Project 3 has been extended to Sunday, April 22.
• The final exam is 2 hours long, all multiple choice. No cheat sheets!
• The TA who will grade project 3, Bao Xin Chen, will hold office hours on Wednesday and Friday, April 11 and 13, 4-5PM this week.
• The TA who graded project 1B and 2, Wenxiao Fu, will hold office hours on Wednesday and Friday, April 11 and 13, 3-5PM this week.
• Another review session will take place on Firday, April 13, 1:30-3PM in 217 Bergeron.
• Sections of the textbook to be covered on the final exam: 1, 2, 3.1-3.5, 4.1-4.6, 5.1, 6, 7, 10.1, 18.1-18.4, 19.1-19.2. You are also responsible for the material covered in class and on slides.
• Grades (corrected) for Project 2 are on ePost. All questions related to the project should be directed to the TA, Wenxiao Fu.
• The TA who graded project 1B, Wenxiao Fu, will hold office hours on Tuesday and Thursday 4-6PM next week.
• Project 3 has been posted.
• My office hours are canceled on March 27.
• Note that picket lines shut down at 3:30PM.
• Grades (out of 10 points) for Project 1 part B are on ePost. All questions related to the project should be directed to the TA.
• Grades (out of 30 points) for midterm test are on ePost.
• EECS 3421N will run normally during the strike. Visit this page regularly in the coming days for more information.
• Project 2 has been posted.
• The deadline for the second part of Project 1 has been extended until Friday, Feb 16.
• Grades (out of 10 points) for Project 1 part A are on ePost. All questions related to the project should be directed to the TA.
• The midterm test on Feb 26 will cover sections 1, 2, 3.1-3.5, 4.1-4.6, 5.1 from the textbook. The test is 2 hours long (no class after the test).
• The second part of Project 1 has been posted.
• I have to postpone office hours on Thursday, Feb 1 until 1:30PM. Apologies for the late notice.
• The first part of Project 1 has been posted.
• Sections of the textbook covered so far: 1, 2 (except 2.4), 3.1-3.5, 4.1-4.6

• Slides
• Sections of the textbook to be covered in class (subject to change): 1, 2, 3.1-3.5, 4.1-4.6, 6, 7, 8, 10.1, 10.6-7, 18.1-18.4, 19.1-19.2.
• The textbook we use for many exercises done in class:

  Database Management Systems.

  Third Edition, 2003.

  Raghu Ramakrishnan and Johannes Gehrke

  WCB/McGraw Hill.

  ISBN: 0-07-232206-3

  URL: http://highered.mcgraw-hill.com/sites/0072465638/student_view0/

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
• Conceptual Design and the ER Model
• Normalization
• Relational Algebra
• SQL Query Language
• Transaction Management, Concurrency Control, and Recovery

Learning Outcomes for the course:

• Model databases proficiently at conceptual and logical levels of design. Use entity relationships (ER) models and ER diagrams with extension.
• Develop relational database schemas which respect and enforce data integrity represented in ER models.
• Implement a relational database schema using structured query language (SQL): create and manipulate tables, indexes, and views
• Create and use complex queries in SQL
• Write database application programs with an understanding of transaction management, concurrency control, and crash recovery.

Required Textbook / Reading

Database Systems: The Complete Book

H. Garcia-Molina, J.D. Ullman, & J. Widom

2nd edition, 2009

Pearson / Prentice Hall

ISBN: 0-13-187325-3

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.

York University's rules for academic honesty and plagiarism 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 test for good reason (e.g., illness with a medical document), your Final Exam grade will count for both the final exam and the missed test.

Policy on e-mail from students on course materials, and questions

• I will not answer these e-mails in general.

  My time is spent more productively for the class's sake in different ways. For pertinent questions on the materials that students send me by e-mail, or for questions that many people seem to be having, I will try to address them in class.

• If you have a burning question I have not addressed, come see me during my office hours, or make an appointment if you need to.

  Many students do this already, and it is a good use of my time and theirs. I can usually answer a question a student asks in person in about a tenth the time than by an e-mail exchange. This is because writing it out takes much longer. Also, 80% of the questions people send me, I have no idea what they are asking. We would have to go back and forth by e-mail several times before I get to the bottom of it.

• For personal requests, such as "I cannot make the test", and so forth, e-mail is fine and I will attempt to answer you directly. However, I will NEVER answer emails sent from non-York accounts. I will NEVER answer emails which are not signed.

  So I do not mind students sending questions by e-mail. By all means, continue. Just do not necessarily expect a direct reply. I do read them, and mostly I try to address the issues and questions people have raised. If your question or issue remains after some time, let me know. For anyone who believes that I am purposely ignoring them, my apologies.

Policy on project/test regrading or reappraisal

• DB2: Getting-started instructions (These notes are specific for us!)
• DB2: Getting-started instructions (version prepared by our tech staff)
• 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.