12th CLASS PRACTICAL LIST
April-May
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.
June
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.
July
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;
No comments:
Post a Comment