• I am getting lots of requests for grade breakdown. I wll not respond to these requests: there are over 70 students in class and responding to each request is simply not feasible. You are welcome to see me when I am back in my office in June.
• My last extended office hours will be on Monday, April 10, 3-5PM.
• The final exam is open books/notes. However, the materials you may use must be in hardcopy (no use of electronic devices during the exam) and is restricted to (1) you notes (2) textbook (3) slide printouts.
• Sections of the textbook to be covered on the final exam: 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.
• Midterm Solutions

• Grades for project 1 (not updated!) and 2 are on ePost. Note that these will not be updated on ePost if your grade is modified.
• The second part of the Project is available. The TA will have extended office hours to answer questions on the project on Tuesday, March 28 and Thursday, March 30, 2-4PM.
• The first part of the Project is available. All questions related to the project should be directed to the TA (Nasim Razavi).
• Slides
• Homework Assignments (The TA responsible for recording your homework submissions is Forouq Khonsari: fkhonsari7@gmail.com)

  All homework assignments are from the textbook unless specified otherwise. Homeworks should be brought to class in hardcopy on the day they are due. No late homeworks will be accepted.

  • HW1 due Feb 2: 2.4.1, 2.4.3, 4.1.3, 4.1.4 Solutions (accessible only from York machines)
  • HW2 due Feb 28: 3.3.1 (c, d, e, f), 3.5.2, 6.2.2, 6.3.1, 6.4.6 Solutions
  • HW3 due Apr 4: 7.1.1, 7.2.3, 7.5.2, 10.1.2, 18.2.4, 19.1.4 Solutions

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, 6, 7, 17, 18 and possibly 5 and 10.

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. Homeworks will not be graded; you get credit for simply submitting the asnwers to homework questions. Projects and homeworks late no more than 24 hours will receive half of the credit. After 24 hour delay, no assignments will be accepted.

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.