Professor: Nagarajan Prabakar (naa-ga-raa-jan pra-baa-kar)
	Phone: 305-348-2033
	E-mail: prabakar@cis.fiu.edu
	Office: CASE-382/Remote
	Office Hours: Remote (Aug 24 - Dec 10) Tue: 4:00-4:45pm,6:30-7:30pm Thu: 4:00-6:00pm or   by appointment

Catalog Description: Design and management of enterprise systems; concurrency techniques; distributed, object-oriented, spatial, and multimedia databases; database integration; data warehousing and data mining; OLAP; XML interchange.

Prerequisite: COP-4703 or COP-4710

Textbook: Fundamentals of Database Systems, 7th Edition
                  Elmasri and Navathe
                  Pearson (ISBN: 0-13-397077-9)

Detailed Syllabus (pdf file)

Course Outcomes:

• Be exposed to enterprise database system
• Master query optimization
• Master concurrency techniques
• Be exposed to object-oriented databases
• Be familiar with spatial databases and multimedia databases
• Be familiar with data mining and XML
• Be exposed to OLAP

Course Modules:

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

Grading:

5% class (zoom/poll) participation

20% quizzes

25% assignments

25% midterm exam (Oct 13th)

25% final exam (Dec 8th)

Quizzes & exams will require the use of Honorlock and/or Respondus LockDown Browser tools

I will use the following relative grading scheme.

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 assignmnet, 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.