Files and Databases

- 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.

Objectives

Familiarity with database technologies, query processing techniques, management and data integration, transaction management and error recovery

Prerequisites

- Data Structures - Discrete Mathematics

Syllabus

- 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