• Final Exam will cover chapters: 1, 2, 3, 4 (except 4.3.1), 5, 16, 17.1-4, 18, 19.1-6, 21 (except 21.5).
• Homework Assignments
  • HW1 due July 19 at 11:30AM: 2.6, 3.16, 3.8 (2, 4, 5, 6), 4.4
  • HW2 due July 26: 5.2, 5.8, (h-o), 19.8, 19.16
  • HW3 due July 30 (in hard copy) or August 2 (by email to the TA): 21.2 (5-11), 17.2 (6,8,10,12), 18.4, 18.8
• The Project
  • Project Assignment : Due August 1

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://highered.mcgraw-hill.com/sites/0072465638/student_view0/

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 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 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 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.