12th CLASS PRACTICAL LIST
1. Define a class my array to find the largest
and smallest element using member functions.
2. Define a structure employee to store employee
code, employee name, address, phone number and salary. Create objects of
employee type and read and display their details according to the sorted order
of their salary.
3. To display the details of a class Travel using
classes and objects.
4. To display the details of the class Hotel
using classes and Objects.
5. Write a program to show the working of all
types of Constructors and Destructors.
6. Write a program to print the Fibonacci series
using Copy constructor.
7. Simulation of Banking system using
inheritance.
8. Write a Program to calculate the number of
vowels in a file using data file handling.
9. Give a file student.dat that stores the
details of some students. These details include roll number, name, class and
marks in 5 subjects. Using the details in this file create another file called
result.dat, which should store fields roll number, percentage and Grade. Grade
must be assigned according to the following criteria.
Percentage
|
Grade
|
>=75
|
A
|
>=60 &&
<75
|
B
|
>=50 &&
<60
|
C
|
>=40 &&
<50
|
D
|
<40
|
E
|
10. Write a program to create a file by accepting
data fropm the user and make a menu driven program as given below
· Char by Char
i. Number of Character
ii. Number of Blank Spaces
iii. Number of Vowels
iv. Number of specific character input by the user
· Word by Word
i. Number of Words
ii. Number of a specific word input by the user
· Line by Line
i. Number of lines
ii. Number of Lines starting with a specific
character input by the user
11. Write a Program to Illustrate the use of this
Pointer.
12. Write a Program to print the address and value
at address by using the concept of array of pointers.
13. Write a Program to implement Linear search
using a 1-d array.
14. Write a Program to implement Binary search
using a 1-D array.
15. Write a Program to implement selection sort
using a 1-D array.
16. Write a Program to implement Bubble sort using
a 1-D array.
17. Write a Program to implement Insertion Sort
using a 1-D array.
18. Write a Program to implement Stack using an
array.
19. Write a Program to implement Queue using an
array.
20. Write a Program to implement Stack using
Linked Lists.
21. Write a Program to implement queue using
Linked.
22. Write a Program to implement circular queue
using an array.
SQL PRACTICALS
1. Given the following tables for a database
LIBRARY :
Book_Id
|
Book_Name
|
Author_Name
|
Publishers
|
Price
|
Type
|
Quantity
|
C0001
|
Fast Cook
|
Lata Kapoor
|
EPB
|
355
|
Cookery
|
5
|
F0001
|
The Tears
|
William Hopkins
|
First Publishers
|
650
|
Fiction
|
20
|
T0001
|
My First C++
|
Brain and Brooke
|
EPB
|
350
|
Text
|
10
|
T0002
|
C++ Brainworks
|
A. W. Rossaine
|
TDH
|
350
|
Text
|
15
|
F0002
|
Thunderbolts
|
Annaborts
|
First Publishers
|
750
|
Fiction
|
50
|
Table:ISSUED
Book_Id
|
Quantity_Issued
|
T0001
|
4
|
C0001
|
5
|
F0001
|
2
|
Write SQL queries for
(a) to (f):
a) To show Book name, Author name and Price of
books of First Publishers.
b) To list the names from books of Text type.
c) To display the names and price of all books in
ascending order of their price.
d) To increase the price of all books of EPB
Publishers by 50.
e) To display the Book_Id, Book_Name and
Quantity_Issued for all books which have been issued.
f) To insert a new row in the table ISSUED having
the following data : “F0003”,1
g) Give the output of the following queries based
on the above tables:
i. Select count(*) from BOOKS;
ii. Select max(Price) from BOOKS where
Quantity>=15;
iii. Select Book_Name, Author_Name from BOOKS where
Publisher=”EPB”;
iv. Select count(distinct Publishers) from BOOKS
where Price>=400;
2. Given the following tables for a database
FURNITURE:
Table: FURNITURE
No
|
Itemname
|
Type
|
Dateofstock
|
Price
|
Discount
|
1
|
White lotus
|
Double bed
|
23/02/02
|
30000
|
25
|
2
|
Pink feather
|
Baby cot
|
20/01/02
|
7000
|
20
|
3
|
Dolphin
|
Baby cot
|
19/02/02
|
9500
|
20
|
4
|
Decent
|
Office table
|
01/01/02
|
25000
|
30
|
5
|
Comfort zone
|
Double bed
|
12/01/02
|
25000
|
25
|
6
|
Donald
|
Baby cot
|
24/02/02
|
6500
|
15
|
7
|
Royal finish
|
Office table
|
20/02/02
|
18000
|
30
|
8
|
Royal tiger
|
Sofa
|
22/02/02
|
31000
|
30
|
9
|
Econo sitting
|
Sofa
|
13/12/01
|
9500
|
25
|
10
|
Eating paradise
|
Dining table
|
19/02/02
|
11500
|
25
|
Table : Arrivals
No
|
Itemname
|
Type
|
Dateofstock
|
Price
|
Discount
|
11
|
Wood comfort
|
Double bed
|
23/03/03
|
25000
|
25
|
12
|
Old fox
|
Sofa
|
20/02/03
|
17000
|
20
|
13
|
Micky
|
Baby cot
|
21/02/03
|
7500
|
15
|
Write SQL queries for
(a) to (f):
a) To show all information about Baby cots from
the FORNITURE table.
b) To list the Itemname which are priced more
than 15000 from the FURNITURE table.
c) To list the Itemname and Type of those items,
in which Dateofstock is before 22/01/02 from the FURNITURE table in descending
order of Itemname.
d) To display the Itemname and Dateofstock of
those items, in which Discount percentage is more than 25 from FURNITURE table.
e) To count the number of items, whose Type is
“Sofa” from FURNITURE table.
f) To insert a new row in the ARRIVALS table with
the following data :
14, “Velvet touch”, “Double bed”, {25/03/03}, 25000, 30
g) Give the output of the following SQL
statements :
i. Select count(distinct Type) from FURNITURE;
ii. Select max(Discount) from FURNITURE;
iii. Select avg(Discount) from FURNITURE where
type=”Baby cot”;
iv. Select sum(price) from FURNITURE where
Dateofstock<{12/02/02}.
3. Given the tables EMPLOYEE and SALARY. Write
SQL commands for the statements (i) to (iv) and Give outputs for SQL queries
(v) to (vi):
Table: EMPLOYEE
Eid
|
Name
|
Depid
|
Qualification
|
Sex
|
1
|
Deepali Gupta
|
101
|
M.C.A
|
F
|
2
|
Rajat Typagi
|
101
|
B.C.A
|
M
|
3
|
Hari Mohan
|
102
|
B.A
|
M
|
4
|
Harry
|
102
|
M.A
|
M
|
5
|
Sumit Mittal
|
103
|
B.Tech
|
M
|
6
|
Jyoti
|
101
|
M.Tech
|
F
|
Table:SALARY
Eid
|
Basic
|
DA
|
HRA
|
Bonus
|
1
|
6000
|
2000
|
2300
|
200
|
2
|
2000
|
300
|
300
|
30
|
3
|
1000
|
300
|
300
|
40
|
4
|
1500
|
390
|
490
|
30
|
5
|
8000
|
900
|
900
|
80
|
6
|
10000
|
300
|
490
|
89
|
i. To display the frequency of employees
department wise.
ii. To list the names of those employees whose
name starts with ‘H’.
iii. To add a new column in salary table. The
column name is Total_Sal.
iv. To store the corresponding values in the
Total_Sal coumn.
v. Select max(Basic) from SALARY where Bonus>40;
vi. Select count(*) from EMPLOYEE group by Sex;
vii. Select Distinct Depid from EMPLOYEE;
4. Given the following tables FLIGHTS and FARES.
Write SQL commands for the statements (i) to (iv) and give output for SQL
queries (v) to (vi):
Table:FLIGHTS
FL_NO
|
STARTING
|
ENDING
|
NO_FLIGHTS
|
NO_STOPS
|
IC301
|
Mumbai
|
Delhi
|
8
|
0
|
IC799
|
Bangalore
|
Delhi
|
2
|
1
|
MC101
|
Indore
|
Mumbai
|
3
|
0
|
IC302
|
Delhi
|
Mumbai
|
8
|
0
|
AM812
|
Kanpur
|
Bangalore
|
3
|
1
|
IC899
|
Mumbai
|
Kochi
|
1
|
4
|
AM501
|
Delhi
|
Trivandrum
|
1
|
5
|
MU499
|
Mumbai
|
Madras
|
3
|
3
|
IC701
|
Delhi
|
Ahmedabad
|
4
|
0
|
Table: FARES
FL_NO
|
AIRLINE
|
FARE
|
TAXPER
|
IC701
|
Indian Airlines
|
6500
|
10
|
MU499
|
Sahara
|
9400
|
5
|
AM501
|
Jet Airways
|
13450
|
8
|
IC899
|
Indian Airlines
|
8300
|
4
|
IC302
|
Indian Airlines
|
4300
|
10
|
IC799
|
Indian Airlines
|
10500
|
10
|
MC101
|
Deccan Airlines
|
3500
|
4
|
i. Display FL_NO and NO_FLIGHTS from “Kanpur” to
“Bangalore” from the table FLIGHTS.
ii. Arrange the contents of the table FLIGHTS in
the ascending order of FL_NO.
iii. Display the FL_NO and fare to be paid for the
flights from Delhi to Mumbai using the tables FLIGHTSS and FARES, where the
fare to be paid=FARE+FARE*TAXPER/10.
iv. Display the minimum fare ”Indian Airlines” is
offering from the table FARES.
v. Select FL_NO, NO_FLIGHTS, AIRLINES from
FLIGHTS, FARES where STARTING=”Delhi” and FLIGHTS. FL_NO=FARES.FL_NO.
vi. Select count(distinct ENDING) from FLIGHTS.
vii. Given the tables stationery and CONSUMER.
Write SQL commands for the statements (i) to (iv) and give outputs for SQL
queries (v) to (viii)
Table:STATIONERY
S_ID
|
StationeryName
|
Company
|
Price
|
DP01
|
Dot pen
|
ABC
|
10
|
PL02
|
Pencil
|
XYZ
|
6
|
ER05
|
Eraser
|
XYZ
|
7
|
PL01
|
Pencil
|
CAM
|
5
|
GP02
|
Gel pen
|
AMC
|
15
|
Table: CONSUMER
C_ID
|
ConsumerName
|
Address
|
S_ID
|
01
|
Good Learner
|
Delhi
|
PL01
|
06
|
Write Well
|
Mumbai
|
GP02
|
12
|
Topper
|
Delhi
|
DP01
|
15
|
Write and Draw
|
Delhi
|
PL02
|
16
|
Motivation
|
Bangalore
|
PL01
|
i. To display the details of those Consumers
whose Address is Delhi.
ii. To display the details of the stationery whose
Price is in the range of 8 to 15 (Including).
iii. To display the ConsumerName, Address from
table CONSUMER and Company, Price from table STATIONERY with their
corresponding matching S_ID.
iv. To increase Price of all stationery by
2.
v. Select distinct Address from CONSUMER.
vi. Select CONSUMER, max(Price), min(Price),
count(*) from STATIONERY group by Company;
vii. Select CONSUMER.ConsumerName,
STATIONERY.StationeryName, STATIONERY.price from STATIONERY, CONSUMER where
CONSUMER.S_ID=STATIONERY.S_ID;
viii. Select StationeryName, Price*3 from
STATIONERY;
