Transcript Introduction to Database Systems

Database Management Systems
CS 542 --- Fall 2009
Instructor: Murali Mani
Email: [email protected]
http://www.cs.wpi.edu/~cs542/f09
4/11/2016
Murali Mani -- CS542
1
Contact and Communication

Mailing list of all students + instructor
[email protected]
4/11/2016
Murali Mani -- CS542
2
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
– Tuesday: 6:00 pm - 8:50 pm at FL-320
– Office Hours : After class + M 10:00 – 11:00 am
4/11/2016
Murali Mani -- CS542
3
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.
4/11/2016
Murali Mani -- CS542
4
Course Material

http://www.cs.wpi.edu/~cs542/f09
+ lecture overheads
+ homework assignment
+ project due dates
4/11/2016
Murali Mani -- CS542
5
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,
4/11/2016
Murali Mani -- CS542
6
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)
4/11/2016
Murali Mani -- CS542
7
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
4/11/2016
Murali Mani -- CS542
8
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
4/11/2016
Murali Mani -- CS542
9
Schedule – Important Dates
Sep 8: Organization meeting
 Sep 22: Project Intent due
 Oct 20: Project Phase I (Design) Due
 Nov 10: Project Phase II (Operations)
Due
 Dec 8: Project Phase III (Interface) Due
along with in class demo, presentation
 Dec 15: Final Exam

4/11/2016
Murali Mani -- CS542
10