Database Programming (CACS453) is a 3-credit subject in BCA 8th Semester at Tribhuvan University. Below you'll find notes, old question papers, and lab reports aligned with the TU BCA curriculum.
Course Code: CACS453 | Credits: 3 | Semester: 8 | Curriculum: BCA Curriculum 2018
Database programming with stored procedures and advanced SQL.
Database Programming provides the comprehensive knowledge about database programming in relational database management system, which encompasses with overview of fundamental SQL statement, PL/SQL Block, Exception, Cursors, Record, Triggers, Procedures, Functions and Packages.
The general objectives of this course is to enhance advance programming skills in relational database management system.
PL/SQL Concepts, Architecture, Block structure, Executing PL/SQL Script, DBMS_OUTPUT.PUT_LINE Statement, substitution Variable feature, PL/SQL Language fundamentals, DML Statement in PL/SQL, Transaction Control in PL/SQL. Conditional Control (if, nested if, Case), Repetitive Control (While, for, simple loop, Nested, continue, loop label)
Exception scope, user-defined exception, exception propagation, advance exception concepts (RAISE_APPLICATION_ERROR, EXCEPTION_INIT)
Types of cursors, cursor loop, Nested cursors cursor for loops , parameterized cursors, Nested cursors
Database Triggers BEFORE, AFTER Triggers, row and statement triggers, INSTEAD OF triggers
Functions (creating and invoking function and optimizing function in execution, creating packages, extending the package, package instantiation and initialization,
Laboratory works should be done covering all the topics listed above and a small work should be carried out using the concept learnt in each unit in individual or group.
The general teaching pedagogy includes class lectures, group discussions, case studies, guest lectures, research work, project work, assignments (theoretical and practical), and examinations (written and verbal), depending upon the nature of the topics. The teaching faculty will determine the choice of teaching pedagogy as per the need of the topics.