FRONT END DESIGN TOOLS & SQL LAB

Paper Code: 
CAI 503
Credits: 
2
Periods/week: 
45
Max. Marks: 
100.00
Objective: 

Course Outcomes (COs):

 

Course Outcomes

(At Course Level)

Learning And Teaching Strategies

Assessment Strategies

The 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.

 

ESSENTIAL READINGS: 

 1. Avi Silberschatz, Henry F. Korth, S. Sudarshan,” Database System Concepts”, Seventh Edition, McGraw-Hill, ISBN 9780078022159

2. A. Leon & Leon, “SQL: A Complete Reference”, Tata McGraw-Hill Education, 1999.

REFERENCES: 

 SUGGESTED READINGS: 

1.  R. Ramakrishnan and J. Gehrke, “Database Management System”, Tata McGraw Hill, Latest edition 2007

2.  C. J. Date, “An introduction to Database Management System”, Pearson Education Asia, 8th Edition.

3.  Sheela Newsheeba M and Sudhakar D, “Simple SQL QUERIES: with practical implementation”, Paper book Sept, 2021.

4. Russell Newton, “SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL”, Walter Shields, Nov 2015, ClydeBank Media

 

JOURNALS:

  1. https://journal-bcs.springeropen.com/
  2. https://jisajournal.springeropen.com/
  3. https://www.sciencedirect.com/journal/thinking-skills-and-creativity

E-RESOURCES:

  1. https://www.freetutes.com/learn-vb6/
  2. https://www.uop.edu.jo/download/research/members/vb6_1__1_.0%20-%20visual%20basic%20-%20learn%20visual%20basic%206.0%20(nice%20manual).pdf
  3. https://www.thevbprogrammer.com/classic_vbtutorials.asp
  4. https://visualbasic.happycodings.com/forms/
Academic Year: 
2022-23
  • Printer-friendly version