Previous year question paper for IDBMS (BBA 4th)

Introduction: definition of data, uses & need of data in organizations.

Basic Concepts: Entities & their attributes, advantages & disadvantages of DBMS.

Data Models: The hierarchical model, the network model & the relational model.

Relational Databases: Relations, tupples, domains & keys, normalization – The first &

second normal form of databases.

SQL: SQL Database creation & manipulation views & queries.

Data Protection: Recovery, concurrency, security & integrity.

Access: A relational database tool in MS-Office. Parts of access window, toolbars and

icons. Creating a new table and new database; saving databases, creating views. Use of

query, forms and reports.