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

  1. Home
  2. hptsb
  3. diploma
  4. it
  5. 4th
  6. rdms
Watch More

Relational Database Management System

Previous year question paper with solutions for Relational Database Management System from 2012 to 2013

Our website provides solved previous year question paper for Relational Database Management System from 2012 to 2013. Doing preparation from the previous year question paper helps you to get good marks in exams. From our RDMS question paper bank, students can download solved previous year question paper. The solutions to these previous year question paper are very easy to understand.

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

Mark Favorite
2013
Download
2012
Download
Related Subjects
CN VP
Tags
rdms