Laboratories

SL NO.

NAME OF LAB

NO. OF LAB

1

Computer lab

02

2

Chemistry lab

01

3

Physics lab

01

4

Biology lab

01

5

Math lab

01

6

Jr.Science lab

01

7

Geography lab

01

Practical of Computer

Class- XI Science

1. Display and print the given values:

            (a) 33+23

            (b) S=24+9 (first assign 24+9 to s and then print S

2. Write a program to read a floating point number n.  Print n, n2, n3, n4 and n5.

3. Write a program to read two numbers and print their quotient and remainder.

4. Write a program to compute simple interest and compound interest

5. Write a program to find the area of a triangle using formula 1/2*base*height.

6. Write a short program to input a digit and print it in word.

7. Write a program to input marks in 3 subjects; compute average and then calculate grade as per following guidelines:

Grade

Marks

A

80% and above

B

70-79%

C

60-69%

D

50-59%

E

40-49%

R

39% and below

 

8. Write a program that prints out a list of the integer from 1 to 20 and their squares.

9. Write a script to print the following:

A

AB

ABC

ABCD

10. Write a program to find the factorial of given number.

Practical Record

Class: - XII Science

SN.

Program Description

 1.     

Write a program to input two numbers m and n and display first m multiples of n.

 2.     

Write a program to input day number of a week and display the corresponding day name.

 3.     

Write a program to read a string and print out the following :

   1)  No. of capital alphabets,

   2)  No. of small alphabets,

   3)  No. of non-alphabets

 4.     

Write a program to read a string and print it after replacing each of its capital alphabets by the corresponding small alphabet and each small alphabet by its corresponding capital alphabet.

 5.     

Write a program to input 10 elements in an array and then display these elements.

 6.     

Write a program to input 10 elements in an array and then display these elements in reverse order.

 7.     

Write a program to input elements in a 2D array and then display this array in matrix form.

 8.     

Write a program to input elements in a 2D array and then display the sum of main diagonal elements of this array.

 9.     

Write a function to check whether a given string is palindrome or not.

10.     

A class STUDENT has 3 data members:

Name, Roll Number, Marks of 5 subjects, Stream

and member functions to input and display data. It also has a function member to assign stream on the basis of the table given below:

Average Marks    Stream

96% or more    Computer Science

91% - 95%      Electronics

86% - 90%      Mechanical

81% - 85%      Electrical

75% - 80%      Chemical

71% - 75%      Civil

Declare a structure STUDENT and define the member functions.

Write a program to define a structure STUDENT and input the marks of n (<=20) students and for each student allot the stream. (Don't use any array).

11.     

Define a class student with the following specifications:

Private members of the class:

Admission Number - An Integer

Name             - string of 20 characters

Class            - Integer

Roll Number      - Integer

Public members of the class:

getdata()   - To input the data

showdata()   - To display the data

 

Write a program to define an array of 10 objects of this class, input the data in this array and then display this list.

12.     

Create a class student with data members name, class, section, roll No. and function members getdata(), printdata(), and promote(). From this class derive a class 'Sr_std' with additional data member stream. Also include another function member change_stream().

Use these classes in a program.

13.     

Write a program to input the name of a text file from the user and display:

a)   The number of blanks present in the file.

b)   The number of lines present in the file.

c)    The number of capital alphabets present in the file.

d)    The number of small alphabets present in the file.

e)    The number of lines starting with a capital alphabet.

f)    The number of words present in the file.

g)    The number of digits present in the file.

h)    The number of words ending with a vowel

14.     

Write a program to input the name of a text file from the user. Then input a string and search for the string in the file. The program should an appropriate message if the file with the given name is not present.

15.     

Write an interactive C++ program to open a text file and then display the following:

   1)  Frequency table of all the alphabetic characters present in the file.

   2)  Number of numeric characters present in the file.

16.     

Declare a structure telerec in C++, containing name (20 characters) and telephone number. Write a program to maintain a file of telephone records. The program should allow the following functions on the file:

   1)  To append records in the file.

   2)  Display the name for a given telephone number. If the telephone number does not exist then display error message "record not found".

   3)  Display the telephone number(s) for a given name. If the name does not exist then display error message "record not found".

17.     

Create two payroll files COMP1.DAT and COMP2.DAT. Each of the files should have the following fields:

EmpNo   : Integer

Name    : A string of 20 characters

Salary  : A floating point number.

Both the files should be created in the increasing order of the EmpNo. Your program should then merge the two files and obtain a third file NEWCOMP.DAT. The program should also display the data from all the three files.

Do not use arrays for merging and sorting of the files. You can assume that the EmpNo are unique.

18.     

Write a menu driven program in C++ to perform the following functions on a binary file “BOOK.DAT” containing objects of the following class:

class Book

{           int BookNo;

            char Book_name[20];

  public:

            // function to enter book details

            void enterdetails();

            //function to display Book details

            void showdetails();

            //function to return Book_no

            int Rbook_no() {return Book_no;}

            //function to return Book_name

            int Rbook_name() {return Book_name;}

 

};

1.      Append Records

2.      Modify a record for a given book no.

3.      Delete a record with a given book no.

4.      Search for a record with a given Book name

5.      Display a sorted list of records (sort on Book No.)

6.      Display a sorted list of records (Sort on Book Name)

19.     

Write a program that reads a list of numbers from the user and places them in an array of type float. Once the numbers are stored in the array, the program should find their average and print it along with the list of numbers. Use pointer notation wherever possible.

20.     

Write a program to input integer data in two arrays. Sort one of the arrays in ascending order and the other in descending order. Then merge them into a third array so that the data in the third array is in ascending order. The program should then display the data from all the three arrays.

21.     

Write a function in C++ which accepts an integer array and its size as arguments/parameters and exchanges the values of first half side elements with the second half side elements of the array.

Example:

If an array of eight elements has initial contents as

2,4,1,6,7,9,23,10

The function should rearrange the array as

       7,9,23,10,2,4,1,6

22.     

Write a function in C++ to find and display the sum of each row and each column of a two-dimensional array of type float. Use the array and its size as parameters with float as its return type.

23.     

Write a program to input two matrices, find their sum, difference, or product depending upon user’s choice, and then display the resultant matrix along with the original matrices.

24.     

Write a menu driven program which allows the user to perform the following operations on a queue (Array implementation):

   1)  Insert

   2)  Delete

Display

25.     

Write a function in C++ which accepts an integer array and its size as arguments/parameters and assigns the elements into a two-dimensional array of integers in the following format:

If the array is 1, 2, 3, 4, 5, 6   If the array is 1, 2, 3

The resultant 2-D array is:        The resultant 2-D array is:

1 2 3 4 5 6                              1 2 3

1 2 3 4 5 0                              1 2 0

1 2 3 4 0 0                              1 0 0

1 2 3 0 0 0

1 2 0 0 0 0

1 0 0 0 0 0

26.     

Write a menu driven program which allows the user to perform the following operations on a stack (Array implementation):

   1)  Push

   2)  Pop

   3)  Display

27.     

Write a menu driven program which allows the user to perform the following operations on a stack (Linked implementation):

   1)  Push

   2)  Pop

   3)  Display

28.     

Write a menu driven program which allows the user to perform the following functions on a queue (Linked implementation):

   1)  Insert

   2)  Delete

   3)  Display

Consider the tables given below and answer the questions that follow:

Table: Employee

No

Name

Salary

Zone

Age

Grade

Dept

1

Mukul

30000

West

28

A

10

2

Kritika

35000

Centre

30

A

10

3

Naveen

32000

West

40

 

20

4

Uday

38000

North

38

C

30

5

Nupur

32000

East

26

 

20

6

Moksh

37000

South

28

B

10

7

Shelly

36000

North

26

A

30

 

Table: Department

Dept

DName

MinSal

MaxSal

HOD

10

Sales

25000

32000

1

20

Finance

30000

50000

5

30

Admin

25000

40000

7

 

 

 

 

 

Write SQL commands to:

Create Table

    1.     

Create the table Employee.

    2.     

Create the table Department.

 Insert data in a table

    3.     

Insert data in the table Employee

    4.     

Insert data in the table Department.

Simple Select

    5.     

Display the details of all the employees.

    6.     

Display the Salary, Zone, and Grade of all the employees.

    7.     

Display the records of all the employees along with their annual salaries. The Salary column of the table contains monthly salaries of the employees.

    8.     

Display the records of all the employees along with their annual salaries. The Salary column of the table contains monthly salaries of the employees. The new column should be given the name “Annual Salary”.

Conditional Select using Where Clause

    9.     

Display the details of all the employees who are below 30 years of age.

10.     

Display the names of all the employees working in North zone.

11.     

Display the salaries of all the employees of department 10.

Using NULL

12.     

Display the details of all the employees whose Grade is NULL.

13.     

Display the details of all the employees whose Grade is not NULL.

Using DISTINCT Clause

14.     

Display the names of various zones from the table Employee. A zone name should appear only once.

15.     

Display the various department numbers from the table Employee. A department number should be displayed only once.

Using Logical Operators (NOT, AND, OR)

16.     

Display the details of all the employees of department 10 who are above 30 years of age.

17.     

Display the details of all the employees who are getting a salary of more than 35000 in the department 30.

18.     

Display the names and salaries of all the employees who are not working in department 20.

19.     

Display the names and salaries of all the employees who are working neither in West zone nor in Centre zone.

20.     

Display the names of all the employees who are working in department 20 or 30.

21.     

Display the details of all the employees whose salary is between 32000 and 38000.

22.     

Display the details of all the employees whose grade is between ‘A’ and ‘C’.

23.     

Display the details of all the employees aged above 30 in West zone.

Using IN Operator

24.     

Display the names of all the employees who are working in department 20 or 30. (Using IN operator)

25.     

Display the names and salaries of all the employees who are working neither in West zone nor in Centre zone. (Using IN operator)

Using BETWEEN Operator

26.     

Display the details of all the employees whose salary is between 32000 and 38000.

(Using BETWEEN operator)

27.     

Display the details of all the employees whose grade is between ‘A’ and ‘C’.

(Using BETWEEN operator)

Using LIKE Operator

28.     

Display the name, salary, and age of all the employees whose names start with ‘M’.

29.     

Display the name, salary, and age of all the employees whose names end with ‘a’.

30.     

Display the name, salary, and age of all the employees whose names contain ‘a’

31.     

Display the name, salary, and age of all the employees whose names do not contain ‘a’

32.     

Display the details of all the employees whose names contain ‘a’ as the second character.

Using Aggregate functions

33.     

Display the sum and average of the salaries of all the employees.

34.     

Display the highest and the lowest salaries being paid in department 10.

35.     

Display the number of employees working in department 10.

Using ORDER BY clause

36.     

Display the details of all the employees in the ascending order of their salaries.

37.     

Display the details of all the employees in the descending order of their names.

38.     

Display the details of all the employees in the ascending order of their grades and within grades in the descending order of their salaries.

Using GROUP BY clause

39.     

Display the total number of employees in each department.

40.     

Display the highest salary, lowest salary, and average salary of each zone.

41.     

Display the average age of employees in each department only for those departments in which average age is more than 30.

Using UPDATE, DELETE, ALTER TABLE

42.     

Put the grade B for all those whose grade is NULL.

43.     

Increase the salary of all the employees above 30 years of age by 10%.

44.     

Delete the records of all the employees whose grade is C and salary is below 30000.

45.     

Delete the records of all the employees of department 10 who are above 40 years of age.

46.     

Add another column HireDate of type Date in the Employee table.

JOIN of two tables

47.     

Display the details of all the employees who work in Sales department.

48.     

Display the Name and Department Name of all the employees.

49.     

Display the names of all the employees whose salary is out of the specified range for the corresponding department.

50.     

Display the name of the department and the name of the corresponding HOD for all the departments.