COP 4540 Database Management [Spring 2007]

Announcements

The homepage is always under construction. Check the course description and syllabus below to decide if this course suits you.

[May. 1, 2007: 2:40PM]:  You can find your final grade here. Please let me know if you have any questions as soon as possible.

[3/27/2007: 9:10pm]:   The due dates for the project have been extended for one week.

[3/19/2007: 12:10pm]   Midterm Exam Statistics: high/low/median=79/53/31.5.

[3/13/2007: 9:10pm]   HW 4 Statistics: high/low/median=18/16/10.5.

[3/12/2007: 1:24pm]  Solutions for HW5 are posted online.

[3/6/2007: 9:10pm]   Midterm Exam is scheduled on March 15th and we will have a review session on March 13th.

[3/5/2007: 9:10pm]   HW 3 Statistics: high/low/median=30/7/27

[3/2/2007: 1:40pm]  The course project is posted on line.  Please check the assignment page.

[3/2/2007: 1:24pm]  Solutions for HW3 and HW4 are posted online.

[3/1/2007: 9:10pm]  Answers  for Quiz 3 are posted online.

[2/15/2007: 9:10pm]  Quiz 3 Statistics: high/low/median=9.5/3/7.

[2/13/2007: 6:10pm]  HW1 Statistics: high/low/median=20/15/18.

[2/13/2007: 6:10pm]  HW 2 Statistics: high/low/median=20/10/16.

[1/25/2007: 6:10pm]  Quiz 2 Statistics: high/low/median=10/1.5/7.

[1/23/2007: 6:10pm]  Quiz 1 Statistics: high/low/median=8/1/6.

Instructor

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

Office: ECS 318
Email: taoli AT cs.fiu.edu
Office Hours: Tuesday and Thursday 5:00pm-6:00pm or by appointment

TA

          Wei Peng

          Office: ECS 268 & ECS 251
          Email: wpeng002 AT cs.fiu.edu
          Office Hours: Tuesday and Thursday 4:00pm-5:00pm or by appointment

Meeting Time and Location

Tuesday and Thursday 7:50pm-9:05pm, ECS 145

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.

Course Material (will be linked when available)

Tentative Course Topics (Subject to revision)

Topic Textbook
DBMS Introduction Ch. 1
DBMS Design, ER-Model Ch. 2
Relational Model Ch. 3
Relational Algebra & Calculus Ch. 4, except 4.3.1, 4.4
SQL Ch. 5, sections 5.1-5.7
File Organizations and Storage Ch. 8; Ch. 9
Indexing Techniques Ch. 10; Ch. 11
Transaction Management Ch. 16
Concurrency & Crash Recovery Ch. 17; Ch. 18
Database Design: Normalization Ch. 19, except 19.8
Latest Trends in Database Selected parts in Ch. 25 (Data Warehousing); Ch. 26 (Data Mining); Ch. 27 (XML Data) and Ch. 28 (Spatial Indexing)

Tentative Course Schedule (Subject to revision)

TUESDAYS THURSDAYS
Jan 9 - Course Introduction
Jan 11 - DBMS Intro (Ch. 1)
Jan 16 - DBMS Intro and Database Design (Ch.1 and Ch. 2)
 Jan 18 - DBMS Intro and Database Design (Ch.1 and Ch. 2)
Jan 23 - Database Design (Ch. 2) Jan 25 - Database Design II (Ch. 2)
Jan 30 -Relational Model (Ch. 3) Feb 1 - ER to Relational Model (Ch. 3)
Feb 6 - Relational Algebra (Ch. 4)
Feb 8 - Relational Algebra II (Ch. 4)
Feb 13 - Relational Calculus (Ch. 4)
Feb 15 - SQL I (Ch. 5)
Feb 20 - SQL II (Ch. 5)
 Feb 22 - Normal Forms I (Ch. 19)
Feb 27 - Normal Forms II (Ch. 19)
 Mar 1 - Normal Forms III (Ch. 19)
March 6 - Normal Forms
Mar 8 -  NO CLASS (Exam Preparation)
Mar 13 - Exam Review
Mar 15 - Midterm Exam
Mar 20 - SPRING BREAK
Mar 22 - SPRING BREAK
Mar 27 - Feedback on Midterm Exam
 Mar 29 - Review on the Project
Apr 3 - Overview of Storage and Indexing (Ch. 8/9)
 Apr 5 - Overview of Storage and Indexing II (Ch. 8/9)
Apr 10 - Data Storage (Ch. 9)
Apr 12 - Tree Index (Ch. 10)
Apr 17 - Hash Indexing (Ch. 11)
Apr 19 - Transaction Management (Ch. 16)

Prerequisites

COP3338. 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 30%
Assignments 35%

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

Code of Academic Integrity:

University Policies:

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

©2007 Tao Li. All rights reserved. last Updated: