Introduction Database Concepts:
Introduction, Characteristics of databases
Users of Database system
DBMS system architecture
File system v/s Database system
Structured Query Language (SQL)
Overview of SQL
Data Definition Commands, Data Manipulation commands, Data
Control commands, Transaction Control Commands.
Set and string operations, aggregate function - group by, having.
Views in SQL, joins , Nested and complex queries, Integrity
constraints :- key constraints, Domain Constraints, Referential
integrity , check constraints
Transactions Management and Concurrency
Transaction concept, Transaction states, ACID properties
Concurrent Executions, Serializability – Conflict and View,
Concurrency Control: Lock-based, Timestamp-based protocols.
Recovery System: Failure Classification, Log based recovery,
ARIES, Checkpoint, Shadow paging.
Relational Model and relational Algebra
Introduction to the Relational Model, relational schema and
concept of keys.
Mapping the ER and EER Model to the Relational Model
Relational Algebra – unary and set operations, Relational
Entity–Relationship Data Model
Weak entity sets,
Strong entity sets
Entity-Relationship (EER) Model
Pitfalls in Relational-Database designs , Concept of normalization
Function Dependencies , First Normal Form, 2nd , 3rd , BCNF,
multi valued dependencies , 4NF