STUDY - Database Management Systems
Database Systems, View of Data Models, Database Languages, DBMS Architecture, Database Users and Data
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, Relational Calculus.
STUDY - Introduction to SQL:
SQL data types and literals, Types of SQL commands, SQL operators, Tables, views and
indexes, Queries and sub queries, Aggregate functions, Cursors in SQL.
Relational Database Design: Functional and multi-valued Dependencies, Desirable Properties of
Decomposition, Normalization up to 5 NF.
Concept and Design of Object Oriented Database.
STUDY - Selected Database Issues:
Security, Transaction Management, Basic Algorithms to Query Processing and Query
Optimization, Concurrency Control, Recovery Techniques.