Week
|
Topics
|
Teaching and Learning Methods and Techniques
|
Study Materials
|
1. Week
|
Introduction
|
Lecture Brainstorming
|
Homework
|
2. Week
|
Databases and Database Users, Database System Concepts and Architecture (Partially), The Relational Data Model and Relational Database Constraints
|
Lecture Brainstorming
|
Homework
|
3. Week
|
Basic Structured Query Language (SQL)
|
Lecture Brainstorming
|
Homework
|
4. Week
|
More SQL: Complex Queries, Triggers, Views, and Schema Modification
|
Lecture Brainstorming
|
Homework
|
5. Week
|
The Relational Algebra
|
Lecture Brainstorming
|
Homework
|
6. Week
|
Data Modeling Using the Entity-Relationship (ER) Model
|
Lecture Brainstorming
|
Homework
|
7. Week
|
The Enhanced Entity-Relationship (EER) Model
|
Lecture Brainstorming
|
Homework
|
8. Week
|
Relational Database Design by ER- and EER-to-Relational Mapping
|
Lecture Brainstorming
|
Homework
|
9. Week
|
Functional Dependencies and Normalization for Relational Databases
|
Lecture Brainstorming
|
Homework
|
10. Week
|
Functional Dependencies and Normalization for Relational Databases
|
Lecture Brainstorming
|
Homework
|
11. Week
|
Introduction to Transaction Processing Concepts and Theory
|
Lecture Brainstorming
|
Homework
|
12. Week
|
Concurrency Control Techniques
|
Lecture Brainstorming
|
Homework
|
13. Week
|
Database Recovery Techniques
|
Lecture Brainstorming
|
Homework
|
14. Week
|
Review of the course
|
Lecture Brainstorming
|
Homework
|