VEER NARMAD SOUTH GUJARAT UNIVERSITY, SURAT
Post Graduate Diploma in Computer Application
(2nd SEMESTER) SYLLABUS
Effective From: July – 2009
PAPER NO.: 203
Paper Title : RELATIONAL DATA BASE MANAGEMENT SYSTEM
1. Relational Database Design
1.1. Structure of Relational Database
1.2. Database Manager
1.3. Database Administrator
1.4. Pitfalls in Relational Database Design
1.5. Functional Dependencies
1.6. First, Second & Third Normal Form, BCNF
2. R.D.B.M.S. package & its tools
2.1. SQL Commands: SELECT, CREATE TABLE, INSERT, UPDATE, DELETE, ALTER TABLE, DROP TABLE, CREATE SEQUENCE, ALTER SEQUENCE, DROP SEQUENCE, CREATE INDEX, ALTER INDEX, DROP INDEX, ROLLBACK, COMMIT, SAVEPOINT, TRUNCATE, CREATE VIEW, DROP VIEW
2.2. Built-in Functions & Group Functions
2.3. PL/SQL: Data types in PL/SQL, user-defined RECORD data type, Control statements (IF, LOOP, WHILE, FOR), Cursor, Passing Parameter to Cursor, Implicit Cursor, Exception Handling, Stored & Local Procedures & Functions, Packages, Triggers
Reference Books:
1. Database System Concepts - Henry F. Korth & Abraham Silberschatz - McGraw-Hill
2. SQL & PL/SQL Programming Language of Oracle – IVAN BAYROSS -
3. An Introduction to Database Systems - C.J.Date - Narosa
4. Introduction to Data Base System - Bipin C. Desai - Galgotia Pub.
5. Principles of Database systems - J. Ullman - Galgotia Pub.
6. Fundamentals of Database Systems – Elmasri Navathe, Addison Wesley
7. Introduction to Database Management - Navin Prakash – TMH
8. Oracle PL/SQL Programming – Feuerstein & Pribyl, O’Reilly, Shroff Publishers & Distributors Pvt. Ltd.
9. Manual of RDBMS