ADVANCED DATABASE MANAGEMENT SYSTEM (3340701)  

7
Credit
3 + 0 + 4
Lect + Tuto + Pract
Teaching Scheme
70 + 30 + 0
ESE + PA + ALA
Theory Marks
40 + 0 + 60
ESE + OEP + PA
Practical Marks
ESE - End Semester Examination, PA - Progress Assessment, ALA - Active Learning Assignments, OEP -Open Ended Problem


Rationale
This subject is associated with the designing of database for business, scientific and engineering application. By the end of this course the students will be able to write simple and advanced PL/SQL code blocks, use advanced features such as ref cursors and bulk fetches and database designing with normalization. Hence students will be able to design relational database which will help them in designing phase of projects in forthcoming semester.
Course Outcome
The theory should be taught and practical should be carried out in such a manner that students are able to acquire different learning out comes in cognitive, psychomotor and affective domain to demonstrate following course outcomes.
i. Execute various advance SQL queries related to Transaction Processing & Locking using concept of Concurrency control.
ii. Demonstrate use of Database Object.
iii. Perform PL/SQL programming using concept of Cursor Management, Error Handling, Package and Triggers.
iv. Understand Functional Dependency and Functional Decomposition.
v. Apply various Normalization techniques.

Active Learning
i. Software: Oracle 10e/11g express edition
ii. DBMS:http://nptel.iitm.ac.in/video.php?subjectId=106106093
iii. SQL Plus Tutorial: http://holowczak.com/oracle-sqlplus-tutorial/
iv. DatabaseTutorials:http://www.roseindia.net/programming-tutorial/DatabaseTutorials
v. Notes : http://service.felk.cvut.cz/courses/X36SQL//cviceni/plsql/pdf/
vi. SQL Basic Concepts: http://www.w3schools.com/sql/
vii. SQL Tutorial : http://beginner-sql-tutorial.com/sql.htm