CS 542 Fall 2001 Database Management Systems Instructor

CS 542 (Fall 2001) Database Management Systems Instructor: Wang-Chien Lee Email: wlee@wpi. edu or wlee@ieee. org http: //www. wpi. edu/~wlee/cs 542 w/f 01 CS 542: Database Management Systems 1

Course Information v Goal – Introduction to theory and design of database management systems (DBMSs). v Who should attend? – Students interested in database systems, database application development, and database research itself v Scope – Including: § Internals of database management systems § Fundamental concepts in database theory § Database application design and development. v Meetings – Tuesdays 6: 00 pm - 8: 50 pm at WPI Waltham, Room 501. v Office Hours – After the classes CS 542: Database Management Systems 2

Textbook v Raghu Ramakrishnan and Johannes Gehrke DATABASE MANAGEMENT SYSTEMS Mc. Graw-Hill Publisher, Second Edition Pub date: 2000, ISBN: 0 -07 -232206 -3 The book is available in the WPI bookstore. v Book site v – http: //www. cs. wisc. edu/~dbbook/ CS 542: Database Management Systems 3

Optional Readings v v v v 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, 2 nd Edition H. F. Korth, and A. Silberschatz, Mc. Graw-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. CS 542: Database Management Systems 4

Grading Policy v Final grades computed based on 100 points: – 25 points: Assignments (and maybe Quizzes) – 35 points: Exams (Midterm: 15 pts, Final: 20 pts) – 10 points: Research Presentation – 30 points: Group Project (Report, Presentation, and Demonstration) CS 542: Database Management Systems 5

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

Cheating and Late Policy v NO CHEATING! – All work is to be done on an individual basis. – No violation of the WPI's guidelines for academic integrity. v 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. CS 542: Database Management Systems 7

Schedule – Important Dates 9/4: Organization meeting v 9/18: Project Intent due v 10/2: Written Project Proposal due v 10/23: Midterm Exam v 10/30: Project Status Report (in class) v 11/6: No class v 11/20: Thanksgiving Week – WE HAVE CLASS! v 12/4: Final Exam v 12/11: In class project demo; final project report due. v CS 542: Database Management Systems 8