Previous year question paper for DBMS (BCA 4th)

SECTION A

An overview of DBMS: Concept of File Processing Systems and database systems, Database

Administrator and his responsibilities. Physical and Logical data independence.

Three level Architecture of Database System: the external level, conceptual level and the

internal level.

SECTION B

Introduction to Data Models: Entity Relationship Model, Hierarchical, Network and Relational

Model. Comparison of Network, Hierarchical and Relational Model.

SECTION C

Relational data Model: Relational database, relational algebra and calculus, SQL dependencies,

functional dependency, multi-valued dependency and join, normalization.

SECTION D

Database protection: Recovery, Concurrency Management, Database Security, Integrity and

Control, Disaster Management

Distributed databases: Structure of a distributed database, design of distributed databases