DISTANCE EDUCATION
B.C.A./B.C.A/(Lateral) DEGREE EXAMINATION,
DECEMBER 2017.
LAB III — ORACLE AND VISUAL BASIC
(2003 onwards)
Time Three hours Maximum 100 marks
Examiner has to select and give ONE question to each
candidate by lot system.
1. Write and test a VB program to read principal,
number of years and rate of interest through
INPUT boxes. Compute and print the simple
interest and compound interest through labels.
Create table PERSONAL with the following
structure.
Field Name Type Width Decimal
SNO Numeric 8
NAME Character 20
CITY Character 20
PIN Numeric 6
PHONE Numeric 6
Add 5 records
display the contents of the table
display the ascending order sorted list with
NAME as primary key
Display the descending order sorted list with
CITY as primary key
Display the contents with appropriate
headings.
Sub. Code
36
DE-9813
2
wk10
2. Write and test a VB program to compute and print
either the SUM or the product of the first N natural
numbers. Use option button.
Create table BIODATA with following structure.
Field Name Type Width Decimal
NAME Character 25
AGE Numeric 2
SEX Character 1
DEGREE Character 8
CITY Character 20
Add 5 records (BIODATA of 5 employees)
Display all records of MALE employees
Delete all BSC degree holders and then
display the table contents
Remove all employee records whose AGE is
greater than 20
Display all records having AGE 20 and CITY
is COIMBATORE.
DE-9813
3
wk10
3. Write and test a VB program to print twenty
address labels in a two-column format for the
address.
THE REGISTRAR,
ALAGAPPA UNIVERSITY,
KARAIKUDI -630 003.
Create table PAY with the following structure.
Field Name Type Width Decimal
EMPNO Numeric 85
NAME Character 25
DOJ Date
BPAY Numeric 8 2
DA Numeric 8 2
HRA Numeric 3
DEDU Numeric 3
GPAY Numeric 8 2
NPAY Numeric 8 2
Add 5 records (Fill all fields except DA, HRA,
DEDU, GPAY and NPAY)
Fill DA with 75% of BPAY for all employees
Fill HRA with 300 for all employees
Fill DEDU with 750 for all employees
Fill GPAY with the sum of BPAY, DA and
HRA
Fill NPAY with GPAY DEDU
Display EMPNO, NAME, BPAY, DEDU,
GPAY, NPAY alone
DE-9813
4
wk10
4. Write and test a VB program to compute and print
either the sum of odd numbers or even numbers at
the user's choice using label, text and option
buttons.
Create table SALES with the following structure.
Field Name Type Width Decimal
SALE NO Numeric 5
SALE NAME Character 20
SALE AMT Numeric 8 2
COMM Numeric 6 2
SALE DATE DATE
Add 5 records
Replace COMM with the following conditions
If sales amount is less than 1000 there is no
commission.
If sales amount is greater than or equal to
1000 but less than or equal to 5000,
commission is of sales amount
If sales amount is greater than 5000,
commission is 10%.
Display all the records
Display the records having commission 1000
Display the average sales and average
commission
Display the total sales and total commission.
DE-9813
5
wk10
5. Write and test a VB program to display the pay of
the given date and convert the given word into
uppercase from lower case.
Create table LABEL with the following structure.
Field Name Type Width Decimal
NAME Character 20
STREET Character 20
CITY Character 20
PIN Numeric 6
Add 5 records
Display the contents of the table
Display the ascending order sorted list with
NAME as primary key
Display the descending order sorted list with
CITY as primary key
Display the contents with appropriate
headings.
DE-9813
6
wk10
6. Write a VB program to calculate simple interest or
compound interest using three command buttons
namely Input, Calculate, Display.
Create Table RESULT with the following structure.
Field Name Type Width Decimal
REGNO Numeric 8
NAME Character 20
MARK 1 Numeric 3
MARK 2 Numeric 3
MARK 3 Numeric 3
TOTAL Numeric 3
RESULT Character 4
Add 5 records (Fill all fields except TOTAL,
RESULT fields)
Fill TOTAL field with the sum of MARK
MARK 2 and MARK 3
Fill the RESULT field with if total
150 otherwise 'FAIL
Find the maximum mark in MARK 1 and
MARK 3 fields
Display all the contents.
DE-9813
7
wk10
7. Write a VB program to do temperature conversion
C to F and F to C at user's choice using Label, Text
and Enter Key.
Create table MARK with the following structure.
Field Name Type Width Decimal
REG NO Numeric 8
NAME Character 20
TAMIL Numeric 3
ENGLISH Numeric 3
MATHS Numeric 3
BIOLOGY Numeric 3
Add 5 records
Show data in fields REGNO, NAME, TAMIL
BIOLOGY alone on the screen
Show data in fields REGNO, BIOLOGY
MATHS alone on the screen
Show data in fields NAME REGNO alone
on the screen
Show all fields on the screen.
DE-9813
8
wk10
8. Write and test a VB program that allows the user
choice among four arithmetic operations of addition,
subtraction, multiplication and division with two
given numbers.
Create table ADDRESS with the following
structure.
Field Name Type Width Decimal
NAME Character 20
STREET Character 20
CITY Character 20
PIN Numeric 6
Add 5 records
Display the structure of the table
Add the field DISTRICT
Fill all DISTRICT with CHENNAI
Change the PIN to 630003 where city is
KARAIKUDI and PIN 623 003.
——————