VIVA (DBIRS)

VIVA Notes(DBIRS) click here to download

DBIRS List Of Experiment

1.       To Perform SQL’s DDL and DML commands using Building Table.

2.       To create a Database For Banking System using ER-Model and conversion of ER-Model into tables.

a)      Relation b/w Customer and account.

b)      Relation b/w Customer and loan

c)       Relation b/w Loan and Payment

d)      Relation b/w Customer and Employee

e)      Relation b/w Branch and Loan

f)       Generalization of Account into Saving acc. And checking acc.

3.       To perform SQL DRL queries.

4.       To create a Database for Student Marksheet using ER-Model and conversion of ER-Model into tables.

5.       To create a Database for Engineering Admission using ER-Model and conversion of ER-Model into tables.

6.       To create a Database for Salary Sheet Preparation using ER-Model and conversion of ER-Model into tables.

7.       To create a Database forIncome tax using ER-Model and conversion of ER-Model into tables.

8.       To create a Database for Library software using ER-Model and conversion of ER-Model into tables.

9.       Write VB Program for

i)                    Largest of three number

ii)                   Prime

10.   Write VB Program for

iii)                 Power of a given Number

iv)                 Table of a given Number

11.   Write VB Program to make a Calculator.

12.    Write a VB Program to calulate Capliary Rise

13.   Write a VB Program to calulate Discharge of Fluid

14.   Write a VB Program to calculate Latitude and Depration of Given Bearing.

15.   Write a VB Program to Find Volume Strain

16.   Write a VB Program to calulate Elongation due to self weight.

17.   Write a VB Program to connect a Student table on SQL server and show the data of the table in VB Data Grid View, also search a perticular record based on roll number.

18.   Write a VB Program to connect a Student table on SQL server and perform the Add,Modify and delete operation from VB form.

Pactical Exam Question Bank

1.      Write a program to accept basic salary from the keyboard. Calculate the gross salary that includes basic salary, 50% DA and 40% HRA.

2.      Write a program to accept a number and display it in reversed form.

3.            Write a program to find the factorial of a number.

4.            Write a program to display the multiplication table of a user entered number. The table must be upto 10.

5.            Write a program to calculate the value of the following series.

1+1/2+1/3+1/4+⋯1/n

 6.            Write a program to display the following for the users specified number of lines.

*

**

*** 

****

*****

|

 n lines

7.            Write a program to display the following for the user specified number of lines.

       *

      **

     ***     

    ****

   *****

  ******  

    |

   n lines

8.            Write  a program to display the following asking the user for the number of lines

1

12

123

1234

12345

123456

9.            Write a program to display the following asking the user for the number of lines.

A

ABA

ABCBA

ABCDCBA

ABCDEDCBA

ABCDEFEDCBA

   

10.        Write a program to calculate the value of

11.        Write a program to display first 10 numbers divisible by 5 and 8.

12.        Write a program to check if the entered number is prime number or not.

13.        Write a program to check if the entered number is Armstrong or not.

14.        Write a program to check if the year entered is leap year or not.

15.        Write a program to display the user entered number in words.

16.        Write a menu driven program to perform add / subtract / multiply / divide / modulus based on the users choice.

17.        Write a program to find GCD and LCM of two numbers.

18.        Write a program to find the factorial of a number using a function.

19.        Write a program to find n Fibonacci elements, using a recursive function.

20.        Write a program to find value of y using recursive function, where y=xⁿ.

21.        Write a program to accept ‘n’ integers from user into an array and display the average of these numbers.

22.        Write a program to accept ‘n’ integers from user into an array and display the count of even and odd numbers of these.

23.        Write a program to find an element in an array and display the index of the element using a function. OR Write a program to implement sequential search algorithm.

24.        Write a program to sort numbers in ascending order.  Write a program to implement bubble sorting algorithm for sorting numbers in ascending order.

25.        Write a program to add two matrices of size m x n.

26.        Write a program to accept a string, copy it into another string and display this new string without using string.h header file.

27.        Write a program to accept two strings, join them and display the result without using string.h header file.

28.        Write a program to accept a string and find its length without using the string header file.

29.        Write a program to reverse a user entered string without using string.h header file.

30.        Write a program to check whether the entered string is palindrome or not (Do not use the string header file).

31.        Write a program to count blank spaces, digits, vowels and consonants in the string.

32.        Write a program to swap two numbers using a function. Pass the values to be swapped to this function using call-by-value method.

33.        Write a program to swap two numbers using a function. Pass the values to be swapped to this function using call-by-reference method.

34.        Write a program to store and display the name, roll number and fees of a student using structure.