FRONT END DESIGN TOOLS & SQL LAB

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

The course will enable the students to

  • Learn the practical aspect of GUI programming language and the SQL environment
  • Develop Practical knowledge by working on exercises based on Visual Basic and PL/SQL commands.
Course Learning OutcomeLearning and Teaching StrategiesAssessment Strategies
Students will be able to:
 
       CO57. Designing the fully functional projects visual basic forms

      CO58. Applying the properties and methods of visual basic controls

       CO59. Handling visual basic events

       CO60. Develop SQL queries for different applications

 
 
          Approach in teaching:
          Interactive Lectures, Discussions, student centered approach, Through video Tutorials 
          Learning activities:
          Presentations,  Quizzes and  Assignments
 
 
          Class test, Semester end examinations, Quiz, Solving problems in tutorials,
          Assignments, Presentation, Individual and group projects and peer review.
 
 
 
 
 
 
 
 

 

 

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: 
2020-21
  • Printer-friendly version