Database Management Systems CS 542 --- Fall 2008

1. Database Management SystemsCS 542 --- Fall 2008 Instructor: Murali Mani Email: mmani@cs.wpi.edu http://www.cs.wpi.edu/~cs542/f08 Murali Mani -- CS542

2. Contact and Communication • Mailing list of all students + instructor cs542-all@cs.wpi.edu Murali Mani -- CS542

3. Course Information • Goal • Introduction to the theory and design of database management systems (DBMSs). • Who should attend? • Interested in database systems, database application development, and database research • Scope • Database application design and development. • Fundamental concepts in database theory • Internals of database management systems • Meetings • Thursday: 6:00 pm - 8:50 pm at FL-311 • Office Hours : After class, and M 9:30 – 10:30 am Murali Mani -- CS542

4. Textbook • Raghu Ramakrishnan and Johannes Gehrke DATABASE MANAGEMENT SYSTEMS McGraw-Hill Publisher, Third Edition • The book is available in WPI bookstore. • Book site • http://www.cs.wisc.edu/~dbbook/ • Useful on-line solutions to some problems. Murali Mani -- CS542

5. Course Material • http://www.cs.wpi.edu/~cs542/f08 + lecture overheads + homework assignment + project due dates Murali Mani -- CS542

6. 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 Systems: The Complete Book by Hector Garcia-Molina, Jeff Ullman and Jennifer Widom, (Prentice-Hall) • 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. • Principles of Data and Knowledge Base Systems, Volume 1, J.D. Ullman, Computer Science Press, Murali Mani -- CS542

7. Grading Policy • Final grades based on 100 points: • 30 points: Assignments (and maybe Quizzes) • 40 points: Exams (Final: 40pts) • 30 points: Course Project (Report, Presentation, and Demonstration) Murali Mani -- CS542

8. 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 • successful completion of your intended (even if later modified) project goals • the demonstration of your system (including successful example runs) • If done as a team, the understanding of each team member of his or her part of the project Murali Mani -- CS542

9. Cheating and Late Policy • NO CHEATING! • All work is to be done on an individual basis; unless otherwise indicated. • No violation of the WPI's guidelines for academic integrity. • Late Assignments • Late assignments will be graded, but no credit will be given • If unavoidable situations, let the instructor know WELL IN ADVANCE Murali Mani -- CS542

10. Schedule – Important Dates • Sep 4: Organization meeting • Sep 18: Project Intent due • Oct 16: Project Phase I (Design) Due • Nov 6: Project Phase II (Operations) Due • Dec 11: Project Phase III (Interface) Due along with in class demo, presentation • Dec 18: Final Exam Murali Mani -- CS542