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:

 

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.

 

Course Learning Outcome

Learning and Teaching Strategies

Assessment Strategies-

Students will :

 

CO71. Apply the properties and methods of visual basic controls
CO72. Implement various visual basic events
CO73. Design & Develop Visual basic forms with backend connectivity.
CO74. Develop visual basic projects
CO75. Implement SQL queries for different applications and data handling with forms

 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: 
2021-22
  • Printer-friendly version