COP 4751: Advanced Database Management; Section U01B

Professor Nagarajan Prabakar
Office Hours: Mon/Wed/Fri: 4:00pm – 4:45pm, 7:30pm – 8:30pm, or by appointment

Catalog Description

Design & management of enterprise systems; query optimization, transaction processing; concurrency techniques; web queries; XML interchanges; data warehousing, datamining; OLAP; NOSQL and bigdata.


This course has a prerequisite: COP4703 or COP4710

Detailed Syllabus (pdf file)

Course Outcomes

Course Modules

  1. Foundations of database systems
  2. Query processing and query optimization
  3. Transaction processing
  4. Concurrency control
  5. Internet database and web queries
  6. XML database and XQueries
  7. Data mining and data warehouse
  8. Information retrieval and bigdata


Fundamentals of Database Systems
Elmasri and Navathe
Addison Wesley; 7th Edition; 2016
ISBN-10: 0-13-397077-9
ISBN-13: 9780133970777


25% assignments

20% quizzes (in-person)

25% midterm exam (in-person: Fri, July 9th 5:00pm-7:00pm)

25% final exam (in-person: Fri, July 30th 5:00pm-7:00pm)

5% class (poll) participation

Grading Scale after Curve
Letter Range% Letter Range% Letter Range%
A 95 or above B 80 - 84 C 65 - 69
A- 90 - 94 B- 75 - 79 D 50 - 64
B+ 85 - 89 C+ 70 - 74 F 49 or less

Other Issues

I expect you to maintain a high level of academic integrity in this course.
Please read FIU's Code of Academic Integrity.
You are allowed to consult other books in solving assignment problems, or to discuss the problems with other students, but you must do the assignments on your own.

For each assignment, you must upload the soft copy of the assignment through Canvas before the deadline and submit a printed copy of the assignment along with the signed originality declaration, in class on the due date.

I will grant incomplete only in extreme circumstances, such as medical emergencies with proper documentation.

I expect you to attend class regularly and promptly, and to participate in discussions. Feel free to ask questions -- if something is unclear to you, it is probably unclear to others as well.


John C. Comfort Lab (CASE-241)

PC workstations

For additional course information, please visit FIU Canvas Support

Discussion Forums

Keep in mind that your discussion forum postings will be seen by other members of the course. Care should be taken when determining what to post.

Important Information

Before starting this course, please review the following pages:

*The professor reserves the right to change or modify the syllabus at any time during the semester.