Course description:
- Introduction to DBMS architectures and file organization.
- Presentation of data models and methodologies for the design of (relational) data bases.
- Relational model: structures, algebra, calculus, database normalization theory.
- Operational topics: query optimization, recovery, concurrent access, security, semantic file and system structure, indexing and hashing query optimization, recovery, concurrency control, security, semantic integrity.

Course content:
- Entity-Relationship Model
- Relational Model
- Query Languages, SQL
- Integrity Constraints
- Database Design
- File Structures and Storage
- Indexing
- Query Processing
- Transactions
- Concurrency Control
- Recovery
- Database Systems Architecture
- Object-Oriented Databases

Keywords:
entity-relationship modeling, relational databases, query languages (relational algebra, relational calculus, SQL), database design, normal forms, integrity constraints, transaction management, physical database design

Last modified: Wednesday, 22 April 2015, 12:16 PM