Computer Science)/B.Sc. (Lateral) DEGREE
EXAMINATION, MAY 2017.
Lab IV — (VISUAL BASIC AND ORACLE LAB)
(2007 onwards)
Time Three hours Maximum 100 marks
Examiner has to select ONE question and give it to the
candidate by LOT system.
1. 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 a table MARK with fields
REGNO, NAME, TAMIL, ENGLISH, MATHS,
BIOLOGY
Add 5 records
Show data in fields REGNO, NAME, TAMIL,
ENGLISH alone on the screen.
Show the record whose MATHS mark 100.
Sub. Code
36
DE-9518
2
wk4
2. Write and test a VB program to select candidates
for four posts based on their qualifications.
Male and PG Degree Manager
Male, Graduate and typing Clerk
Female and PG Degree Secretary
Female, graduate and Typing Steno
Create a table ADDRESS with the fields
NAME, STREET, CITY, PIN.
Add 6 records
Add the field DISTRICT
Fill all DISTRICT with CHENNAI
Change the PIN to 620008 where city is
TRICHY and PIN is 623003.
3. Write and test a VB program to display the day of
the given date. Convert upper case from lower case
to given word.
Create a table RESULT with the fields
REGNO, NAME, M1, M2, M3, TOT, RESULT
Add 6 records (except TOT and RESULT)
Fill TOT field with the sum of M1,
M2 and M3.
Fill the RESULT field with PASS if
TOT otherwise FAIL.
Cut here
DE-9518
3
wk4
4. Write a VB program to calculate simple interest or
compound interest using three command buttons
namely INPUT, CALCULATE and DISPLAY.
Create a table BIODATA with the fields
NAME, AGE, SEX, DEGREE, CITY
Add 5 records
Display all records of MALE employees
Remove all employee records whose AGE is
greater than 20
Display all records having AGE 20 and CITY
is Madurai.
5. Write and test a VB program to compute and print
either the sum of odd numbers or even numbers at
the uses's choice using label, text and option
buttons.
Create a table PERSONAL with the fields
SNO, NAME, CITY, PIN, PHONE
Add 5 records
Display all names without duplicate
Display all names and length of names
Display name, city in which only beginning
portion of name is known.
Cut here
DE-9518
4
wk4
6. Write and test a VB program to compute and print
either the sum or the product of first N natural
numbers. Use option button.
Create a table SALES with the fields
SALENO, SALENAME, SALEAMT, COMM,
SALEDATE.
Add 5 records
Replace comm with the following conditions
if sales amount is less than 5000 there is no
commission
if sales amount is greater than or equal to
5000 but less than or equal to 10000,
commission is 10% of sales amount.
if sales amount is greater than 10000
commission is 20%
Display all the records
Display the records having commission
1000.