Lecture Notes || SNS Courseware

Lecture Notes

UNIT 1:

Database Management system - Three-schema architecture of DBMS

Entity –Relationship Model

Components of DBMS

E/R diagram notations, Examples

Relationships, relationship types

Purpose of Database System

UNIT 2:

Intermediate SQL

SQL fundamentals- Introduction

Relational Algebra

Relational Data Model - keys, referential integrity and foreign keys

Advanced SQL features

Oracle:Database Design and Querying Tools; SQL Variations and Extensions

UNIT 3:

Dependencies and Normal forms

minimal covers-Non- loss decomposition

UNIT 4:

Schedules – Serializability

Concurrency Control – Need for Concurrency

Deadlock – Transaction Recovery

Save Points

SQL Facilities for Concurrency and Recovery