M30

RDBMS , DBMS & SQL Programming
Year / Semester: 
3rd Semester
Objective: 

-

Credits: 
4

MH 43 – RELATIONAL DATABASE MANAGEMENT SYSTEM
(RDBMS - Oracle )

Introduction to RDMS and Oracle
Approaches to data management
Database management- An Evolution
Introduction to DBMS
Database models
The rules( Code’s Rules)
Database Design
i) Data Modeling
ii) Entity Relationship Diagram
iii) Normalization
Relational Database Management System( RDBMS)
Features of Oracle
Introduction to SQL
i) Introduction to SQL
j) Querying database tables
k) Aggregate Functions
l) Grouping the Result of Query
m) ROLLUP operation, CUBE operation
n) Querying Multiple Tables
o) Collating Information
1 Equi Joins
2 Cartesian Joins
3 Outer Joins
4 Self Joins
Set Operator
1 Union
2 Intersect
3 Minus
Nested Queries
Functions
1 Column Functions
2 Arithmetic Function
3 Character Functions
4 Data Functions
5 General Functions
6 Group Functions
Data Manipulation
1 Data Definition Language (DDL)
2 Creating Tables
3 Creating a Tables with data from another table
4 Inserting values into table
5 Updating Columns of a table
6 Deleting Rows from table
7 Dropping a Column
8 Introduction to Views
9 Dropping of VIEW
10 Database Security and Privileges
11 GRANT and REVOKE Command
12 Sequences
13 COMMIT and ROLLBACK
PLSQL-I
1 Introduction to PL/ SQL
2 The Advantage of LP/SQL
3 Fundamentals of PL/SQL
4 PL/SQL Data Types
5 Variables a Constants
6 Scope and Visibility of a Variables
7 Assignments and Expressions
8 Operator Precedence
9 Built – in Functions
10 Conditional and Iterative Control
11 SQL within PL/SQL
PL/SQL II
1 Cursor Management in PL/ SQL
2 Cursor Manipulation
3 Implicit Cursor Attributes
o Exception Handling in PL/ SQL predefined Exceptions User Defined Exceptions
4 Advanced Pl/ SQL
5 Subprograms in PL/SQL
6 Procedure
7 Functions
8 Stored packages
Database Triggers
Introduction to SQLJ, Integrators
Introduction to SQLJ
1 SQLJ Iterates
Calling stored procedure and functions
Implementing object Technique
What is Object Technology?
2 What is an Object?
3 Basic Object Oriented Programming (OOP)

MH 45 - DBMS AND SQL PROGRAMMING

Introduction
An overview of database management system, database system Vs file system, Database system concepts and architecture, data models schema and instances, data independence and database language and interfaces, Data definitions language, DML, Overall Database Structure.
Data Modeling using the Entity Relationship Model
ER model concepts, notation for ER diagram, mapping constraints, keys, Concepts of Super Key, candidate key, primary key, Generalization, aggregation, reduction of an ER diagrams to tables, extended ER model, relationships of higher degree.
Relational data Model and Language
Relational data model concepts, integrity constraints: entity integrity, referential integrity, Keys constraints, Domain constraints, relational algebra, relational calculus, tuple and domain calculus,
Introduction to SQL
Characteristics of SQL.
Advantage of SQL.
SQL data types and literals.
Types of SQL commands.
Query by Example (QBE)
Introduction, SELECT Queries in QBE, Make-Table Query, DELETE Query, UPDATE Query, APPEND Query, Conclusion, Exercise
SQL operators and their procedure.
Tables, views and indexes.
Queries and sub queries.
Aggregate functions. Insert,
update and delete operations.
Joins, Unions,
Intersection, Minus,
Cursors in SQL

Suggested Readings: 

-