Instructor

Dr. Tao Li, Associate Professor
School of Computer Science and Engineering
Florida International University

Office: ECS 318
Email: taoli AT cs.fiu.edu
Office Hours: Thursday 2:30pm-4:30pm or by appointment

TA

           TBA

Meeting Time and Location

Monday and Tuesday: 18:25pm-19:40pm, GL166

Course Description

This course is intended to give students a solid background in database management systems, particularly relational database management systems. Such systems will be examined from two perspectives: that of a database system user, and that of a database system implementor. First, we will look at the basic structure and capabilities of a database system, and we will examine the process of designing a database and using a database system. Second, we will look inside a database system to see how it is implemented. In addition, if time permits, we will look at some latest trends in database systems such as OLAP, XML databases, Spatial Databases, and Data Mining.

This is a graduate level course that introduces the principles of database management systems. After the students successfully finish this course, they should have a better understanding on different aspects of a database management system. They should also be familiar with relational model, SQL, storage and indexing, query evaluation, transaction management, and some selected topics.

Course Material (will be linked when available)

• Lecture Notes and Assignments

Tentative Course Topics (Subject to revision)

• Database Design
• Relational Model
• Relational Algebra and Calculus
• SQL
• Indexing and Storage
• Transaction Processing
• Query Evaluation and Optimization
• XML
• Data Warehouse
• Spatial Data Management

Prerequisites

COP4540. Basically students are expected to have a computer science/systems background that includes basic data structures and to be comfortable programming in C/C++. Students will be expected to learn to use computing tools independently.

Format and Grading

The course assignments include homeworks and implementation projects. The homeworks are mainly used to test conceptual knowledge and to help you in the exams, while the projects will focus on practical skills and what it takes to implement a DBMS. Class attendance is mandatory. In addition, occasional quizzes will be given in class. Final grades will be calculated as follows.

Quizzes and Class Participation	10%
Midterm Exam	25%
Final Exam	25%
Assignments	40%

Policies on Assignments and Exams

All project deliverables and assignments should be submitted before midnight on the due date. The only excuse for missing an exam is verifiable cases of illness and emergencies and religious holidays. Please check the dates for exams and inform me at the earliest of any conflict due to the above-mentioned reasons.

Textbooks and References

Textbook

• Raghu Ramakrishnan and Johannes Gehrke. Database Management Systems. Third Edition, McGraw Hill, 2003. ISBN: 0-07-246563-8. Links to Textbook Homepage .

References

• Ramez Elmasri and Shamkant B. Navathe Fundamentals of Database Systems. Fourth Edition, Addison-Wesley, 2004. ISBN 0-321-12226-7.
• Abraham Silberschatz, Henry F. Korth and S. Sudarshan. Database System Concepts . Fourth Edition. McGraw Hill, 2004. ISBN 0-07-255481-9.

Other Resources

• http://dev.mysql.com/doc/mysql/en/index.html
• Database Jobs

Code of Academic Integrity:

http://www.fiu.edu/~oabp/misconductweb/2codeofacainteg.htm

University Policies:

For academic misconduct, sexual harassment, religious holydays, and information on services for students with disabilities, see :

• http://www.fiu.edu/provost/polman/sec2/sec2web2-44.htm
• http://www.fiu.edu/~eop/EOPSexH.pdf
• http://www.fiu.edu/~provost/polman/sec19web.html