Database Management Systems :: Course Content & online available resources

Course Content

Introduction: Database Systems, View of Data Models, Database Languages, DBMS Architecture, Database Users and Data Independence.

ER Modeling: relation types, role and Structural Constraints, Extended ER Modeling Features, Design of an ER Database Schema, Reduction of ER Schema to Tables.

Relational Model: Relational Model Concepts, Relational Algebra.

Introduction to SQL: SQL data types and literals, Types of SQL commands, SQL operators, Tables, views and indexes, Queries and sub queries, Aggregate functions.

Relational Database Design: Functional and multi-valued Dependencies, Desirable Properties of Decomposition, Normalization up to 3 NF and BCNF.

Selected Database Issues: Security, Transaction Management, Introduction to Query Processing and Query Optimization, Concurrency Control, and Recovery Techniques.

Reference Texts and E-Resources

Fundamentals of Database Systems 6th Edition - Ramez Elmasri & Navathe

Database System Concepts 6th edition - Silberschatz & Korth

An Introduction to Database Systems, By C.J.Date, Addison Wesley

Database Management Systems, By R. Ramakrishnan, McGraw-Hill

Elmasri and Navathe Slides

Silberschatz, Korth and Sudarshan Slides

Lecture Slides (Extended and Modified version of Elmasri and Navathe):
ch1-korth, ENCh01, ENCh02, ENCh03, ENCh04a, ENCh05, ENCh07, ENCh23, SQL-I, SQL-II

Lab Assignments