C. U. SHAH UNIVERSITY, WADHWAN CITY.
Faculty of: Computer Science
Course: Bachelor of Computer Applications
Semester: IV
Subject Code: CAM209-2C
Subject Name: RDBMS using Oracle
Teaching
hours/ Evaluation Scheme/ Semester
Week
Sr. Subject Credit Credit Theory Pract
Subject Name
No Code hours Points ical
categor ThTu Pr Continuous Intern End
y End
and al Semester
Semester Total
Comprehensive Assessm Exams
Exams
evaluation ent
Mar Activity Marks Durati Mark Durati MarkDuration
ks on s on s
RDBMS 10 Assignment
Major- -
2 CAM209-2C using 3 2 5 4 10 MCQ 50 2 Hrs. 25 1 Hrs. -- 100
IX -- -
Oracle 05 Attendance
AIM:
The objective of Advanced Database Management System course is to train students in becoming proficient
Development. Pre-requisites: All Advanced Database Management System class attendees must be fluent in
Database concept. The course can be customized to any level of programming and relational database
familiarity.
COURSE CONTENTS
Unit I Introduction to RDBMS (5 Lectures)
Introduction to DBMS and RDBMS.
DBMS Vs. RDBMS
E-R Diagrams in RDBMS
Normalizations.
Unit II Basics of SQL (10 Lectures)
Data types in SQL.
DDL, DML, DCL, TCL Commands.
Constraint in SQL.
Clauses in SQL (WHERE, GROUP BY with HAVING, ORDER BY)
Database Object VIEW, INDEX.
Unit III Introduction to PL/SQL (10 Lectures)
PL/SQL block structure.
Variables, conditions and looping structure in PL/SQL.
Cursor (Implicit and Explicit) with cursor attributes.
%type and %rowtype attributes.
Page 1 of 2
Unit IV Advanced PL/SQL (10 Lectures)
Creating and using Procedure and Functions.
Creating Triggers and executing triggers.
Creating Package and executing package
Creating objects like PL/SQL Tables, Nested Table, Varray.
Exception handling
Unit V Oracle Database Structure (05 Lectures)
Instance architecture (DB Processes, Memory structure, data files)
Control files, redo log files, Tablespace.
Import and export in oracle.
Rollback segment.
Unit VI Concurrency control and locking (05 Lectures)
Introduction to Lock, deadlock, types of lock, locking issues.
Arrangement of lectures duration and practical session as per defined credit numbers:
Units Lecture Duration Calculation of Total Credit
(In Hrs.) Credits Lecture Calculation
(In Numbers) Duration
Theory+ Theory+
Theory Practical Theory Practical
Practical Practical
Unit – 1 05 00 10
Unit – 2 10 05 15
Unit – 3 10 10 11
3 2 4
Unit – 4 10 05 11
Unit – 5 05 05 20
Unit – 6 05 05 08
TOTAL 45 30 3 2 75 4
Evaluation:
Theory Marks Practical Marks Total Marks
75 25 100
Reference Books
RDBMS Using Oracle – Bharat & Co. [ISBN No. : 978-93-81786-38-3]
SQL, PL/SQL The programming - [Link] Oracle Ivan Bayross - BPB [ISBN No. : 81-7656-964-X]
Using Oracle 8i - Page, Hughes - QUE & PHI Publications
Oracle 8i The Complete Reference - George Koch, Kevin Loney - Oracle Press and Tata MacGraw-Hill
Mastering SQL – Martin Gruber [ISBN No. : 0-7821-2538-7]
Teach Yourself PL/SQL in 21 Days – Jonathan Gennick, Tom Luers [ISBN No. :0-672-31798-2]
NPTEL COURSE ([Link]
Database Management System
By Prof. Partha Pratim Das, Prof. Samiran Chattopadhyay | IIT Kharagpur
[Link]
Page 2 of 2