CS 2255 DATABASE MANAGEMENT SYSTEMS Lecture Notes Common to CSE & IT Departments - by R.Anirudhan

CS 2255 DATABASE MANAGEMENT SYSTEMS Lecture Notes Common to CSE & IT Departments


CS2255 Lecture Notes 

Syllabus :


UNIT I INTRODUCTION
Purpose of Database System -– Views of data – Data Models – Database Languages ––
Database System Architecture – Database users and Administrator – Entity–
Relationship model (E-R model ) – E-R Diagrams -- Introduction to relational databases

UNIT II RELATIONAL MODEL
The relational Model – The catalog- Types– Keys - Relational Algebra – Domain
Relational Calculus – Tuple Relational Calculus - Fundamental operations – Additional
Operations- SQL fundamentals - Integrity – Triggers - Security – Advanced SQL
features –Embedded SQL– Dynamic SQL- Missing Information– Views – Introduction
to Distributed Databases and Client/Server Databases

UNIT III DATABASE DESIGN
Functional Dependencies – Non-loss Decomposition – Functional Dependencies – First,
Second, Third Normal Forms, Dependency Preservation – Boyce/Codd Normal Form-
Multi-valued Dependencies and Fourth Normal Form – Join Dependencies and Fifth
Normal Form

UNIT IV TRANSACTIONS
Transaction Concepts - Transaction Recovery – ACID Properties – System Recovery –
Media Recovery – Two Phase Commit - Save Points – SQL Facilities for recovery –
Concurrency – Need for Concurrency – Locking Protocols – Two Phase Locking –
Intent Locking – Deadlock- Serializability – Recovery Isolation Levels – SQL Facilities
for Concurrency.

UNIT V IMPLEMENTATION TECHNIQUES
Overview of Physical Storage Media – Magnetic Disks – RAID – Tertiary storage – File
Organization – Organization of Records in Files – Indexing and Hashing –Ordered
Indices – B+ tree Index Files – B tree Index Files – Static Hashing – Dynamic Hashing –
Query Processing Overview – Catalog Information for Cost Estimation – Selection
Operation – Sorting – Join Operation – Database Tuning.





download Database Management Systems Lecture Notes-1

download Database Management Systems Lecture Notes-2

download Database Management Systems Lecture Notes-3

download Database Management Systems Lecture Notes-4








To Get alert, like us in facebook or subscribe us and To find what you need very easy Click G+
Previous
Next Post »