Front End Design Tools & SQL Lab

Paper Code: 
CAI 503
Credits: 
02
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

To make students familiar with the basics of GUI programming language and the SQL environment. It is based on theory paper CAI 501 & CAI 502.

List of practical in VB:
1.    Use of different controls used in VB.
2.    Use of different message boxes and statements used in VB
3.    Menus, Sub-Procedures and Sub-functions
4.    Multiple Forms
5.    Use of List Boxes & Combo Boxes, Filling the List using Property window/
6.    Add Item Method, Clear Method, List box Properties, Removing an item from a list
7.    List Box/ Combo Box, Using String Function, Printing to printer using Print Method
8.    Use and working of Data Files
9.    Accessing Database File
10.    Advanced data handling

List of practical in DBMS:
Practical exercise on Every SQL command and function covered in DBMS syllabus will be done in lab session. Programs using PL/SQL commands will also be given and done in practical.

 
 

Academic Year: