RDBMS (PGDCA 1st)

SECTION-A

An Overview of DBMS and DB Systems Architecture : Introduction to Database Management

systems, Data Models, Database System Architecture, Relational Database Management systems,

Candidate Key and Primary Key in a Relation, Foreign Keys, Relational Operators, Set Operations

on Relations, Attribute domains and their Implementation. The Normalization Process :

Introduction, first Normal Form, Partial Dependencies, Second Normal Form, data Anomalies in

2NF Relations, Transitive Dependencies, Third Normal Form. (10)

SECTION-B

The Entity Relationship Model: The Entity Relationship Model, Entities and Attributes,

Relationships, One-One Relationships, Many-to-one Relationships, Normalizing the Model, Table

instance charts. Interactive SQL : SQL commands , Data Definition Language Commands, Data

Manipulation Language Commands, insertion of data into the tables, Viewing of data into the

tables, Deletion operations, updating the contents of the table, modifying the structure of the

table, renaming table, destroying tables, Data Constraints, Type of Data Constraint, Column Level

Constraint, Table Level Constraint. (12)

SECTION-C

Viewing The Data : Computations on Table Data, Arithmetic Operators, Logical Operators,

Comparison Operators, Range Searching, Pattern Searching, ORACLE FUNCTIONS, Number

Functions, Group Functions, Scalar Functions, Data Conversion Functions, Manipulating Dates in

SQl , Character Functions, Sub queries and Joins : Joins, Equi Joins, Non Equi Joins, Self Joins,

Outer Joins, Sub Queries, Correlated Queries, Using Set Operators:- Union , Intersect, Minus. (10)

SECTION-D

Views and Indexes : Definition and Advantages Views, Creating and Altering Views, Using Views,

Indexed Views, Partitioned views, Definition and Advantages of Indexes, Composite Index and

Unique Indexes, Accessing Data With and without Indexes, Creating Indexes and Statistics.

Introduction to PL/SQL : Advantage of PL/SQL, The Generic PL/SQL Block, The Declaration

Section, The Begin Section, The End Section, The Character set, Literals, PL/SQL Data types,

Variables, Constants, Logical Comparison, Conditional Control in PL/SQL, Iterative Control. (12)