The programme to be implemented using SQL
1. Create Table, SQL for Insertion, Deletion, Update and Retrival using aggregating functions.
2. Write Programs in PL/SQL, Understanding the concept of Cursors.
3. Write Program for Join, Union & intersection etc.
4. Creating Views, Writing Assertions, Triggers.
5. Creating Forms, Reports etc.
6. Writing codes for generating read and update operator in a transaction using different situations.
7. Implement of 2PL concerning central algorithm.
8. Developing code for understanding of distributed transaction processing.
Students are advised to use Developer 2000 Oracle 8+ version for above experiments. However, depending on the availability of Software’s students may use power builder/SQL Server/DB2 etc. for implementation?