CS 542 (Fall 2001) Database Management Systems

1
CS 542 (Fall 2001) Database Management Systems

• Instructor Wang-Chien Lee
• Email wlee_at_wpi.edu or wlee_at_ieee.org
• http//www.wpi.edu/wlee/cs542w/f01

2
Course Information

• Goal
• Introduction to the theory and design of database
  management systems (DBMSs).
• Who should attend?
• Students interested in database systems, database
  application development, and database research
  itself
• Scope
• Including
• Internals of database management systems
• Fundamental concepts in database theory
• Database application design and development.
• Meetings
• Tuesdays 600 pm - 850 pm at WPI Waltham, Room
  501.
• Office Hours
• After the classes

3
Textbook

• Raghu Ramakrishnan and Johannes Gehrke DATABASE
  MANAGEMENT SYSTEMS McGraw-Hill Publisher, Second
  Edition Pub date 2000, ISBN 0-07-232206-3
• The book is available in the WPI bookstore.
• Book site
• http//www.cs.wisc.edu/dbbook/

4
Optional Readings

• Understanding the New SQL A Complete Guide J.
  Melton and A. R. Simon, Morgan-Kaufmann, 1993.
• A Guide to the SQL Standard (third edition) C. J.
  Date and H. Darwen, Addison-Wesley, 1994.
• Database System Implementation, by Hector
  Garcia-Molina, Jeff Ullman and Jennifer Widom,
  (Prentice-Hall, 2000) used by CS 4432
• A First Course in Database Systems, by Ullman and
  Widom, (Prentice-Hall, 1999) used by CS 4431
• Fundamentals of Database Systems R. Elmasri, and
  S. Navathe, Benjamin Cummings, any edition.
• Database System Concepts, 2nd Edition H.F. Korth,
  and A. Silberschatz, McGraw-Hill, any edition.
• A First Course in Database Systems, J. Widom and
  J. D. Ullman, Prentice-Hall, 1997.
• Principles of Data and Knowledge Base Systems,
  Volume 1, J.D. Ullman, Computer Science Press,
  1989.

5
Grading Policy

• Final grades computed based on 100 points
• 25 points Assignments (and maybe Quizzes)
• 35 points Exams (Midterm 15pts, Final 20pts)
• 10 points Research Presentation
• 30 points Group Project (Report, Presentation,
  and Demonstration)

6
Project Grading

• the difficulty of the project you have chosen
• solution approach, design and implementation
• the oral project presentation
• the written documentation of your project in the
  form of a report
• successful completion of your intended (even if
  later modified) project goals
• the demonstration of your system (including
  successful example runs)
• the understanding of each team member of his or
  her part of the project, as well as of the
  overall group product.

7
Cheating and Late Policy

• NO CHEATING!
• All work is to be done on an individual basis.
• No violation of the WPI's guidelines for academic
  integrity.
• Late Penalty
• Turned in within the first 24 hours after the due
  date subtracting 20 of the total achievable
  points of that deliverable
• Between 24 to 48 hours late reduction of 50 of
  the total achievable points.
• Certain deliverables may not have ANY LATE day,
  as announced.

8
Schedule Important Dates

• 9/4 Organization meeting
• 9/18 Project Intent due
• 10/2 Written Project Proposal due
• 10/23 Midterm Exam
• 10/30 Project Status Report (in class)
• 11/6 No class
• 11/20 Thanksgiving Week
• WE HAVE CLASS!
• 12/4 Final Exam
• 12/11 In class project demo final project
  report due.