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)