CA5108 DATABASE MANAGEMENT SYSTEMS LABORATORY-SYLLABUS

ANNA UNIVERSITY TRICHY SYLLABUS

CA5108 DATABASE MANAGEMENT SYSTEMS LABORATORY-SYLLABUS

LTPC 0032

1. Execute a single line and group functions for a table. 

2. Execute DCL and TCL Commands. 

3. Create and manipulate various DB objects for a table. 

4. Create views – partitions and locks for a particular DB. 

5. Write PL/SQL procedure for an application using exception handling. 

6. Write PL/SQL procedure for an application using cursors.

7. Write a DBMS program to prepare reports for an application using functions.

8. Write a PL/SQL block for transaction operations of a typical application using triggers.

9. Write a PL/SQL block for transaction operations of a typical application using package.

10. Design and develop an application using any front end and back end tool (make use of ER Diagram and DFD).

11. Develop an application using Menus.

12. Importing / Exporting Data.

13. Reports Creations Typical Applications – Banking – Electricity Billing Library Operation – Payroll – Insurance – Inventory – etc.

Total: 45


CHECK OUT ANNA UNIVERSITY TRICHY SYLLABUS