MSCS 207

Instructor:

Dr. Raymond Macatangga

Email: rsmacatangga@gmail.com

Prelim:

• The Context of Database Management
• Database Analysis
• Introduction to SQL

Midterm:

• Report no. 1: Advanced SQL (Jan. 11)
• Report no. 2: Database Application Development (Jan. 18)
• Report no. 3: Data Warehousing (Jan. 25)
• Report no. 4: Data Quality and Integration (Feb. 1)
• Report no. 5: Data and Database Administration (Feb. 8)

Finals:

• Report no. 6: Distributed Databases (Feb. 15)
• Report no. 7: Object-Oriented Data Modeling (Feb. 22)
• Report no. 8: Data Modeling Tools and Notation (Mar 1)
• Report no. 9: Using Relational Databases to Provide Object Persistence (Mar 8)
• Report no. 10: Advanced Normal Norms(Mar 15)

Final Exam: March 22, 2014

The course covers data models and their underlying mathematical foundations, database manipulation and query languages. Special topics include object-oriented, spatial, temporal and multimedia databases, as well as recent advances on database indexing methods, concurrency control, crash recovery, database security and distributed databases.

WHAT TO DO NEXT:

1. Perform basic content editing (e.g. Syllabus, Meet the Professor, Handouts, Assignments).
2. Choose a theme or customize your background under Site Settings.
3. Change your status to OPEN under Site Settings.
4. Announce the URL to your students and have them register (your course directory will be created automatically).