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