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



Assignments: 2 assignments + 1 final project
Exams:
-Entrance exam for deciding the grading policy
- Two closed-book exams

Grading Policy

Policy one for those who pass the Entrance Exam
Projects 75%
Midterm 1: 20%
Participation 5%

Policy two for those who fail
Projects 75%
Midterm 1: 20%
Participation 5%
Deduction: -100% (-3% for every late record)