CS 4710: Introduction to Database Systems

Course Summary
This course is intended to cover the fundamental concept in database systems. The introduced concepts are: 1) conceptual, logic, and physical organization of data; 2) data manipulation languages; 3) indexing techniques; 4) transaction management. These concepts are exercised further by four exercises and a final project.


SCHEDULE OF CLASSES
- Introduction (C1, AR1, AR5)
- E-R Data Model (C2-3, AR3, AR4)
- Extended ER Data Model (C3-4)
- Relational Data Model (C5)
- SQL (C8)
- Relational Algebra and Calculus (C6, C8-9)
- Storage and Indexing (C13-14, AR6-7)
- Query Evaluation (C15, AR8,9)
- Transaction Management (C17-19)
- Project Demonstration



Grading:
Assignment: 20%
Project: 20%
Midterm Exam: 25%
Final Exam: 35%
Participation: 5%