198: 336; Spring 2005

Principles of Information and Database Management

Sections 01 and 02

Web Site Contents


  • Lecture:
    Mondays 6:10-9:00pm, SEC 209
    Matthew Stone
    Office hours: Tuesday 4-6pm, Core 328.

  • Recitations: Section 01: Wednesday 6:35-7:30, ARC 108
    Section 02: Wednesday 7:40-8:35, ARC 108
    Recitations will be given jointly by Vladislav Shkapenyuk and Yangzhe Xiao
    Contact Info:
    Email - vshkap at paul.rutgers.edu
    Office Hours: Monday 1-3pm, Hill 353

    Email - yxiao at paul.rutgers.edu
    Office Hours: Tuesday 7-9pm, Hill 412

  • Text: Raghu Ramakrishnan and Johannes Gehrke Database Management Systems, 3th edition, McGraw-Hill, September 2003. This book comes with the author's companion web site and the publisher's companion web site

  • Syllabus: conceptual modeling; relational data and SQL; structured data and XML; querying, retrieving, and mining data; developing data-intensive applications.

  • Note: Sections 1 and 2 will be comparable in goals, topics and workload to Section 3. But Sections 1 and 2 will have their own schedule and exams.


  • May 6
    Practice for the exam - initial suggestions - look at the following questions in the textbook:
    • Chapter 1, 1.7 (data manipulation = language for ask and tell) and 1.9.1-4.
    • Chapter 2, 2.7 (although any actual exam question would be much shorter)
    • Chapter 3, 3.5, 3.7, 3.10, 3.17 (same caveat for 3.17 as 2.7)
    • Chapter 4, 4.2, 4.3.1-4 (relational algebra only)
    • Chapter 5, 5.7 (but just SQL queries, not assertions/constraints)
    • Chapter 7, 7.6 (same caveat as 2.7; also, on the exam, you would only be asked what information needs to be stored with a page, what is the SQL query with ?'s, and how do you fill in the ?'s - no JSP code!)
    • Chapter 16, 16.3
    • Chapter 26, 26.2, 26.8
    • Chapter 27, 27.7.1 & 2 (but XML schema instead of DTD, and on an exam you can expect a reminder about syntax)
    An answer key for all the odd questions in the textbook is on the textbook web materials page.

  • May 2
    Reminder: project due today, send info to mdstone at cs.rutgers.edu.

  • Apr 27
    Lecture Monday May 2 will also include a final review.
    Reminder: project due Monday, details in class notes for 4/25, send info to mdstone at cs.rutgers.edu.
    Reminder: Yangzhe Xiao has a number of further project resources on his web page
    Reminder: Recitation today is a project clinic in Hill 250.

  • Apr 19

  • Apr 15
    Reminder, as announced in class, project part 2 deadline extended till Wednesday Apr 20.

  • Apr 11
    More project notes and discussion, in lecture.

  • Apr 5
    Update; resources for the project:

  • Mar 24
    Update, including project description notes.

  • Mar 11
    Update: Some sample midterm problems.

  • Mar 7
    No office hours for MS March 8.
    (I'm not back from Mar 7 travel; email for an appointment after Wed.)

  • Mar 1
    Revised schedule.
    Second homework, due Mar 9.
    Oracle accounts available: see http://www.cs.rutgers.edu/~robtuck/oracle/student/. (Thanks Rob Tuck!)

  • Feb 26
    Quick update about the homework, question 2.
    Here's a local copy of the word sketch.

  • Feb 25
    Quick update about the homework, question 2. It asks you to provide a set of definitions. Each definition is just a descriptive English phrase that describes a sense of the word. Each definition should have one well-chosen example sentence for it (you don't need more example sentences; but if it helps you, you can add extra example contexts from the sketch heading). Use the word sketch to find the example sentences and to make sure that you cover all the ways the word is used. You can do a good job in a page of typed text.

  • Feb 23

  • Feb 15
    Homework, due Feb 28

  • Feb 8

  • Feb 1

  • Jan 26
    First lecture notes posted.

  • Jan 17
    Initial revision of this web page.
    The first meeting will be Monday, January 24.
    Recitations will not meet Wednesday, January 19.

Requirements and Grading:

  • The course will have a midterm exam and a final exam (together worth about 55%). All exams will be closed-book exams: no books, no notes, and no calculators will be allowed. The final will be cumulative (meaning that it will cover everything taught in the course).
    Rutgers University Policy on Academic Integrity

  • The course will have a series of short homeworks.
  • In addition, the course will have an extended team project, where you use a DBMS (Oracle/MySQL) to power a web interface (in XML/html).

Lecture Schedule, Events, Notes