Previous year question paper for RDMS (Diploma Information Technology 4th)

THEORY

1. Introduction (03 hrs)

Database Systems,Database and its purpose, Characteristics of the

database approach, Advantages and disadvantages of database systems,

Classification of DBMS Users, Actors on the scene, Database

Administrators, Database Designers, System Analysts.

2. Database System Concepts and Architecture (05 hrs)

Schemes and Subschemes, Instances, keys, Redundancy, DBMS

Architecture, The External level, The conceptual level, The internal level,

Mappings.

Data Independence, Logical data Independence, Physical data

Independence.

Database Languages and Interfaces, DBMS Language, DBMS Interfaces.

3. Data Modelling using E.R. Model (Entity Relationship Model) (04 hrs)

Data Models Classification : Object and Record based model, semantic data

models. Entities and Attributes. Entity types and Entity sets. Key attribute

and domain of attributes. Association and Relationship among entities

4. Relational Model (06 hrs)

Relational Model Concepts: Domain, Attributes, Tuples and Relations.

Relationalconstraints and relational database schemes, Domain constraints,

Key constraints and constraints on Null, Relational databases and relational

database schemes, Entity integrity, referential integrity and foreign key.

5. Dependencies and Normalization (08 hrs)

Functional Dependencies, Trivial and Non-trivial dependenciesClosure of a

set of dependencies and attributes

Normalization

Non-loss decomposition, First, Second and Third normal forms, Boyce/Codd

normal form.

6. Structure Query Language(SQL) and PL/SQL (12 hrs)

Data Definition Language(DDL), Data Manipulation Language(DML),

Create, Drop, Alter, Insertion commands, Select command with WHERE

clause using conditional and Boolean operator, group by Clause Like

operator, Grouping Data joins, sub queries union, Intersect, Minus Clause.

Sorting and updating the Data. PL/SQL Introduction, PL/SQL block structure

variables, SQL statements in PL/SQL, PL/SQL Control Structures.

7. Query Processing and Transaction Processing 10 hrs.)

General strategies for query processing, Equivalence expressions,

Selection & join operation. Concept of transaction, States of transactions,

Concurrent Executions, Serializability Recoverability, Transaction Definition

in SQL. Lock based protocols : share & exclusive models, Protocols.

Deadlock handling, Deadlock prevention, detection & recovery