Introduction to Database Management Systems
CSE-3421
Syllabus



Semester: July 9-26, 2012
Course/Sect#: CSE-3421
Time: Monday-Thursday 11:30-14:30
Location: ACE 007
Course website: http://www.cse.yorku.ca/~jarek/courses/3421/S12
Instructor: Jarek Gryz
Office: 2049 CSB
Office Hours: Monday-Thursday 11AM
and by appointment
Ph#: 416-736-2100 x70150
e-mail: jarek@cs.yorku.ca
T.A.: Nikolay Yakovets
Office: CSB 2013
Office Hours: Tuesday, July 31 2:30-4 PM Thursday, August 2 2:30-4PM
Ph#: N/A
e-mail: hush@cse.yorku.ca

Course Materials (to accumulate over the semester)
  • Final Exam will cover chapters: 1, 2, 3, 4 (except 4.3), 5, 16, 17.1-4, 18, 19.1-6, 21 (except 21.5), and the first 23 pages of these slides.
    The Course

    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:

    This corresponds to the following chapters from the textbook: 1, 2, 3, 4, 5, 16, 17, 18, 19, and possibly 6 and 21.


    Books / Reading

    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

    Grading Criteria / Course Requirements

    Percentage When
    Test 1 15% July 16
    Test 2 15% July 23
    Final Exam 40% July 26
    Project 20% August 3
    Homeworks 10% July 16, 23, and 26.

    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.


    Useful On-line Information
  • For the textbook
  • DB2: Getting-started instructions (These notes are specific for us!)
  • SQL
  • DB2: Lots more DB2 documentation
    Jarek Gryz