Course Contents

Preliminaries: Database system concepts and architecture. (2 Lectures)

Semantic Data Model: Entity-Relationship (ER) model, Enhanced Entity-Relationship (EER) model.(4 Lectures)

Relational Model and Languages: Relational data model, Relational database constraints, Relational database design by ER- and EER-to-relational mapping, Relational algebra and Relational calculus. (9 Lectures)

SQL: Schema definition, Constraints, Queries, Views. (5 Lectures)

Database Design Theory: Functional dependencies, Normalization. (5 Lectures)

Algorithms for Query Processing and Query Optimization (5 Lectures)

Database File Organization: Disk storage, File structures, Hashing techniques, Indexing structures. (3 Lectures)

Database Transaction Processing: Transaction concepts and theory, Concurrency control protocols, Database recovery protocols. (6 Lectures)

Advanced Databases: Distributed databases, Object-oriented databases, Multimedia databases, Handling unstructured data, Big data, NoSQL databases. (3 Lectures)

Laboratory

Exercises in SQL covering: Data definition, Data manipulation, Data retrieval, Transaction control

Exercises in PL/SQL covering procedures, functions, loops, triggers

NoSQL data organization and query optimization.

Text Book

R. ELMASRI, S.B. NAVATHE (2017), Fundamentals of Database Systems, Pearson Education, 7th Edition.

Reference Books

1. R. RAMAKRISHNAN, J. GEHRKE (2014), Database Management Systems, McGraw-Hill, 3rd Edition.

2. H.G. MOLINA, J. ULLMAN, J. WIDOM (2014), Database Systems: The Complete Book, Pearson, 2nd Edition.

3. P. RAJ, A. RAMAN, D. NAGARAJ, S. DUGGIRALA (2015), High-Performance Big-Data Analytics: Computing Systems and Approaches, Springer, 1st Edition.

4. N. SABHARWAL, S. GUPTA EDWARD (2014), Big Data NoSQL: Architecting MongoDB, CreateSpace Independent Publishing Platform, 1st Edition.

5. K. BANKER, P. BAKKUM, S. VERCH, D. GARRETT, T. HAWKINS (2016), MongoDB in Action, Manning Publications, 2nd Edition.

6. G. HARRISON (2015), Next Generation Databases: NoSQL and Big Data, Apress, 1st Edition.