BPUT DBMS Notes

hii sir, I am B.tech CS student of BPU university I wants to get the Notes / Study Material of the Database Management subject ?

[Kiran Chandar]

Biju Patnaik University of Technology, Rourkela was created by an act of the Odisha state legislature in November 2002.This is the state technical university of Odisha


As you asking for the Study material of the Database Management subject of B.tech CS second year of BPU university the study Material is as follow :



UNIT I INTRODUCTION AND CONCEPTUAL MODELING: Introduction to File and Database systems- Database system structure – Data Models – Introduction to Network and Hierarchical Models – ER model – Relational Model – Relational Algebra and Calculus.

UNIT II RELATIONAL MODEL: SQL – Data definition- Queries in SQL- Updates- Views – Integrity and Security – Relational Database design – Functional dependencies and Normalization for Relational Databases (up to BCNF).

UNIT III DATA STORAGE AND QUERY PROCESSING: Record storage and Primary file organization- Secondary storage Devices- Operations on Files- Heap File- Sorted Files- Hashing Techniques – Index Structure for files –Different types of Indexes- B-Tree - B+Tree – Query Processing.

UNIT IV TRANSACTION MANAGEMENT: Transaction Processing – Introduction- Need for Concurrency control- Desirable properties of Transaction- Schedule and Recoverability- Serializability and Schedules – Concurrency Control – Types of Locks- Two Phases locking- Deadlock- Time stamp based concurrency control – Recovery Techniques – Concepts- Immediate Update- Deferred Update - Shadow Paging.

UNIT V CURRENT TRENDS: Object Oriented Databases – Need for Complex Data types- OO data Model- Nested relations- Complex Types- Inheritance Reference Types - Distributed databases- Homogenous and Heterogenous- Distributed data Storage – XML – Structure of XML- Data- XML Document- Schema- Querying and Transformation. – Data Mining and Data Warehousing.



BPU DBMS notes







here I am attracting the file in which you may found the notes of the Database Management system the file is given below :

for more details you may contact to the BPU university the contact details are as follow :

Contact details :

Biju Patnaik University of Technology
Address: Chhend Main Rd, Chhend, Rourkela, Odisha 769004
Phone: 0661 248 2556