DBMS (B-TECH Computer Science Engineering 4th)

SECTION A: Introduction, Client Server Arch., E-R Diagram and Keys

Overview of database Management System; Various views of data, data Models, Introduction

to Database Languages. Advantages of DBMS over file processing systems, Responsibility of

Database Administrator,

Introduction to Client/Server architecture, Three levels architecture of Database Systems, ER

Diagram (Entity Relationship), mapping Constraints, Keys, Reduction of E-R diagram into

tables.

Section B: File Organization and Relational Model and Calculus:

 Sequential Files, index sequential files, direct files, Hashing, B-trees Index files.

Relational Model, Relational Algebra & various operations, Relational and Tuple calculus.

Section C; Introduction to Query Languages :

QLB , QBE, Structured query language – with special reference of (SQL of ORACLE),

integrity constraints, functional dependencies & NORMALISATION – (up to 4th Normal

forms), BCNF (Boyce – code normal forms)

SECTION D:

Introduction to Distributed Data processing, parallel Databases, data mining & data

warehousing, network model & hierarchical model, Introduction to transaction, properties of

transaction and life cycle of transaction, Introduction to Concurrency control and Recovery

systems., need of concurrency control and recovery system, problems in concurrent

transactions