Limited Time Offer: Get 2 Months of ABCmouse.com for only $5!

My Classroom Website

                                                                                           PRACTICAL LIST FOR CLASS XII

1. Define a class HOTEL in C++ with the following description:     

                Private Members

  • Rno                        //Data Member to store Room No
  • Name                    //Data Member to store customer Name
  • Tariff                     //Data Member to store per day charge
  • NOD                      //Data Member to store Number of days
  • CALC                      //A function to calculate and return amount as NOD*Tariff  and if the value of NOD*Tariff is more than 10000 then as 1.05*NOD*Tariff          

Public Members:

Checkin( )            //A function to enter the content RNo,Name, Tariff and NOD

Checkout()         //A function to display Rno, Name, Tariff, NOD

and Amount (Amount to be displayed by calling function CALC( )

 

2. Define a class Applicant in C++ with following description:                                       

Private Members

  • A data member ANo ( Admission Number) of type long
  • A data member Name of type string
  • A data member Agg(Aggregate Marks) of type float
  • A data member Grade of type char
  • A member function GradeMe( ) to find the Grade as per the Aggregate Marks obtained by a student. Equivalent Aggregate marks range and the respective Grades are shown as follows

Aggregate Marks                                                         Grade

> = 80                                                                            A

Less than 80 and > = 65                                                  B

Less than 65 and > = 50                                                  C

Less than 50 and > = 33                                                  D

Less than 33                                                                                       E

Public Members

  • A function Enter( ) to allow user to enter values for ANo, Name, Agg & call function GradeMe( ) to find the Grade
  • A function Result ( ) to allow user to view the content of all the data members.

 

3. Assume a text file “coordinate.txt” is already created. Using this file create a C++ function to count the number of words having first character capital.

 

4. Function to count number of lines from a text files (a line can have maximum 70 characters or ends at ‘.’)

 

5. C++ program, which initializes a string variable to the content “There is an island of opportunity in the middle of every difficulty.” and output the string one character at a time to the disk file “OUT.TXT”.

 

6. Write a function in a C++ to count the number of uppercase alphabets, alphabats, digits, white spaces and vowels present in a text file “BOOK.txt”

 

7. Assume a text file “Test.txt” is already created. Using this file, write a function to create three files “LOWER.TXT” which contains all the lowercase vowels and “UPPER.TXT” which contains all the uppercase vowels and “DIGIT.TXT” which contains all digits.

 

8. Write a function in C++ to count the no. of “He”, or “She” words present in a text file “story.txt”.If the file “story.txt” content is as follows:

He is playing in the ground. She is

playing with her dolls.

The output of the function should be

Count ofHe/She in file is: 2

 

9. Write a function in C++ to search for camera from a binary file “CAMERA.DAT” containing the objects of class CAMERA (as defined below). The user should enter the ModelNo and the function should search and display the details of the camera.                                                                               

class CAMERA

{long ModelNo; float MegaPixel; int Zoom; Char Details[120];

public:

void Enter()        {              cin>>ModelNo>>MegaPixel>>Zoom;    gets(Details);      }

void Display(){   cout<<ModelNo<<MegaPixel<<Zoom<<Details<<endl;                }

long GetModelNo() {     return ModelNo;             }

 

10. Write a function COPYABC() in C++, that would copy all those records having areacode as “123” from TELEPHONE.DAT to TELEBACK.DAT

 

11. Write a Get2From1() function in C++ to transfer the content from one array ALL[ ] to two different arrays Odd[ ] and Even[ ]. The Odd[ ] array should contain the values from odd positions(1,3,5,….) of ALL[ ] and Even[ ] array should contain the values from even positions (0,2,4,…) of ALL[ ].

Example: If the ALL array contains 12,34,56,67,89,90 the Odd[ ] array should contain 34, 67,90 and the Even[ ] array should contain 12,56,89                                                                                              

12. Write a DSUM() function in C++ to find sum of Diagonal Elements from a NxN Matrix. (Assuming that the N is a odd number)                                                                                             

13. Write a function in C++ which accepts an integer array and its size as arguments and replaces elements having even values with its half and elements having odd values with twice its value

14. Write a function in C++ which accepts an integer array and its size as argument and exchanges the value of first half side elements with the second half side elements of the array.

Example: If an array of eight elements has initial content as 2,4,1,6,7,9,23,10. The function should rearrange the array as 7,9,23,10,2,4,1,6.

15. Write a function in c++ to find and display the sum of each row and each column of 2 dimensional array. Use the array and its size as parameters with int as the data type of the array.

16. Write a function in C++, which accepts an integer array and its size as parameters and rearrange the array in reverse.

Example if an array of five members initially contains the elements as 6,7,8,13,9,19

Then the function should rearrange the array as 19,9,13,8,7,6

17. Write a function in C++, which accept an integer array and its size as arguments and swap the elements of every even location with its following odd location.

Example : if an array of nine elements initially contains the elements as 2,4,1,6,5,7,9,23,10 Then the function should rearrange the array as 4,2,6,1,7,5,23,9,10

18. Write function SORTPOINTS() in c++ to sort an array of structure Game in descending order of points using Bubble Sort Note: Assume the following definition of structure Game

struct Game

{long PNo; // Player Number

char PName[20];

long points;};

19. Write a c++ function to shift all the negative numbers to left and positive number in the right side.

20. Define a function SWPCOL() in C++ to swap ( interchange) the first column elements with the last column elements, for a two dimensional array passed as the argument of the function.

Example : if the two dimensional array contains

2 1 4 9

1 3 7 7

5 8 6 3

7 2 1 2

After swapping of the content of 1st and last column, it should be

9 1 4 2

7 3 7 1

3 8 6 5

2 2 1 7

21. Write the function to find the largest and second largest number from a two dimensional array. The function should accept the array and its size as argument.

22. Write a function in C++ to merge the contents of two sorted arrays A & B into third array C. Assuming array A is sorted in ascending order, B is sorted in descending order, the resultant array is required to be in ascending order.

23. Write a function in C++ to perform Delete operation on a dynamically allocated Queue containing Members details as given in the following definition of NODE:                           

struct NODE

{long Mno;                          //Member Number

 char Mname[20];            //Member Name

 NODE *Link;};

24. Define functions in C++ to perform a PUSH and POP operation in a dynamically allocated stack considering the following :

struct Node

{ int X,Y;

Node *Link; };

class STACK

{ Node * Top;

public:

STACK( )

 {TOP=NULL;}

void PUSH( );

void POP( );

~STACK( ); };

 

25. Write a function in C++ to perform a Add and Delete operation in a dynamically allocated Queue considering the following:

struct node

{

int empno ;char name[20] ;float sal ;

 Node *Link;

};

Q1 Write SQL commands for (i) to (viii) on the basis of relations given below:

BOOKS

book_id               Book_name                       author_name                    Publishers           Price      Type      qty

k0001                    Let us C                                Sanjay mukharjee           EPB                        450         Comp    15

p0001                    Genuine                              J. Mukhi                               FIRST PUBL.        755         Fiction 24

m0001                   Mastering c++                   Kanetkar                              EPB                        165         Comp    60

n0002                    Vc++ advance                    P. Purohit                            TDH                        250         Comp    45

k0002                    Near to heart                     Sanjeev                                FIRST PUBL.        350         Fiction 30

 

ISSUED

Book_ID

Qty_Issued

L02

13

L04

5

L05

21

i. To show the books of FIRST PUBL Publishers written by P.Purohit.

ii. To display cost of all the books written for FIRST PUBL.

iii. Depreciate the price of all books of EPB publishers by 5%.

iv. To display the BOOK_NAME,price of the books whose more than 3 copies have been issued.

v. To show total cost of books of each type.

vi. To show the detail of the most costly book.

 

Q2. Write SQL commands for (a) to (f) and write output for (g) on the basis of PRODUCTS relation given below:

PRODUCT  TABLE

PCODE PNAME                                 COMPANY          PRICE STOCK      MANUFACTURE    WARRANTY

P001      TV                                           BPL                         10000    200         12-JAN-2008                       3

P002      TV                                           SONY                     12000    150         23-MAR-2007                     4

P003      PC                                           LENOVO               39000    100         09-APR-2008                      2

P004      PC                                           COMPAQ             38000    120         20-JUN-2009                      2

P005      HANDYCAM                       SONY                     18000    250         23-MAR-2007                     3

a) To show details of all PCs with stock more than 110.

b) To list the company which gives warranty for more than 2 years.

c) To find stock value of the BPL company where stock value is sum of the products of price and stock.

d) To show number of products from each company.

e) To count the number of PRODUCTS which shall be out of warranty on 20-NOV-2010.

f) To show the PRODUCT name which are within warranty as on date.

g). Give the output of following statement.

(i) Select COUNT(distinct company) from PRODUCT.

(ii) Select MAX(price)from PRODUCT where WARRANTY<=3

 

3.

Table : SchoolBus

Rtno

Area_overed

Capacity

Noofstudents

Distance

Transporter

Charges

1

Vasant kunj

100

120

10

Shivamtravels

100000

2

Hauz Khas

80

80

10

Anand travels

85000

3

Pitampura

60

55

30

Anand travels

60000

4

Rohini

100

90

35

Anand travels

100000

5

Yamuna Vihar

50

60

20

Bhalla Co.

55000

6

Krishna Nagar

70

80

30

Yadav Co.

80000

7

Vasundhara

100

110

20

Yadav Co.

100000

8

Paschim Vihar

40

40

20

Speed travels

55000

9

Saket

120

120

10

Speed travels

100000

10

Jank Puri

100

100

20

Kisan Tours

95000

 
  1. To show all information of students where capacity is more than the no of student in order of rtno.
  2. To show area_covered for buses covering more than 20 km., but charges less then 80000.
  3. To show transporter wise total no. of students traveling.
  4. To show rtno, area_covered and average cost per student for all routes where average cost per student is - charges/noofstudents.
  5. Add a new record with following data:

                (11, “ Moti bagh”,35,32,10,” kisan tours “, 35000)   

  1. Give the output considering the original relation as given:

         (i)  select sum(distance) from schoolbus where transporter= “ Yadav travels”;

         (ii) select min(noofstudents) from schoolbus;

       (iii) select avg(charges) from schoolbus where transporter= “ Anand  travels”;

  1. select distinct transporter from schoolbus;

 

4.

TABLE : GRADUATE

S.NO

NAME

STIPEND

SUBJECT

AVERAGE

DIV.

1

KARAN

400

PHYSICS

68

I

2

DIWAKAR

450

COMP. Sc.

68

I

3

DIVYA

300

CHEMISTRY

62

I

4

REKHA

350

PHYSICS

63

I

5

ARJUN

500

MATHS

70

I

6

SABINA

400

CEHMISTRY

55

II

7

JOHN

250

PHYSICS

64

I

8

ROBERT

450

MATHS

68

I

9

RUBINA

500

COMP. Sc.

62

I

10

VIKAS

400

MATHS

57

II

 
  1. List  the names of those students who have obtained DIV 1 sorted by NAME.
  2. Display  a report, listing NAME, STIPEND, SUBJECT  and amount of stipend received in a year assuming that the STIPEND  is paid every month.
  3. To count the number of students who are either PHYSICS or COMPUTER SC graduates.
  4. To insert a new row in the GRADUATE table:    11,”KAJOL”, 300, “computer sc”, 75, 1

   (e)     Give the output of following sql statement based on table GRADUATE:

  1. Select MIN(AVERAGE) from GRADUATE where   SUBJECT=”PHYSICS”;
  2. Select SUM(STIPEND) from GRADUATE WHERE div=2;
  3. Select AVG(STIPEND) from GRADUATE where AVERAGE>=65;
  4. Select COUNT(distinct SUBDJECT)  from GRADUATE;

(f)     Assume that there is one more table GUIDE in the database as shown below:

Table: GUIDE

MAINAREA

ADVISOR

PHYSICS

VINOD

COMPUTER SC

ALOK

CHEMISTRY

RAJAN

MATHEMATICS

MAHESH

 

 

 

 

 

 

g) What will be the output of the following query:

SELECT NAME, ADVISOR               FROM  GRADUATE,GUIDE WHERE SUBJECT= MAINAREA;

 

5.            Write SQL command for (i)  to (vii) on the basis of the table SPORTS

 

Table: SPORTS

Student NO

Class

Name

Game1

Grade

Game2

Grade2

10

7

Sammer

Cricket

B

Swimming

A

11

8

Sujit

Tennis

A

Skating

C

12

7

Kamal

Swimming

B

Football

B

13

7

Venna

Tennis

C

Tennis

A

14

9

Archana

Basketball

A

Cricket

A

15

10

Arpit

Cricket

A

Atheletics

C

 

  1. Display the names of the students who have grade ‘C’  in either Game1 or  Game2 or both.
  2. Display the number of students getting grade ‘A’ in Cricket.
  3. Display the names of  the students who have same game for both Game1 and Game2.
  4.  Display the games taken up by the students, whose name starts with ‘A’.
  5.  Assign a value 200 for Marks for all those who are getting grade ‘B’ or  grade ‘A’ in both Game1 and  Game2.
  6. Arrange the whole table in the alphabetical order of Name.
  7.  Add a new column named ‘Marks’. 

 

6. Write SQL command for (i)  to (vii) on the basis of the table Employees & EmpSalary

                                                                               

Table: Employees

Empid

Firstname

Lastname

Address

City

010

Ravi

Kumar

Raj nagar

GZB

105

Harry

Waltor

Gandhi nagar

GZB

152

Sam

Tones

33 Elm St.

Paris

215

Sarah

Ackerman

440 U.S. 110

Upton

244

Manila

Sengupta

24 Friends street

New Delhi

300

Robert

Samuel

9 Fifth Cross

Washington

335

Ritu

Tondon

Shastri Nagar

GZB

400

Rachel

Lee

121 Harrison St.

New York

441

Peter

Thompson

11 Red Road

Paris

                                                                                Table: EmpSalary

Empid

Salary

Benefits

Designation

010

75000

15000

Manager

105

65000

15000

Manager

152

80000

25000

Director

215

75000

12500

Manager

244

50000

12000

Clerk

300

45000

10000

Clerk

335

40000

10000

Clerk

400

32000

7500

Salesman

441

28000

7500

Salesman

 

Write the SQL commands for the following :

  1. To show firstname,lastname,address and city of all employees living in paris                                              
  2. To display the content of Employees table in descending order of Firstname.                                             
  3. To display the firstname,lastname and total salary of all managers from the tables Employee and empsalary , where total salary is calculated as salary+benefits.                                                  
  4. To display the maximum salary among managers and clerks from the table Empsalary.          

Give the Output of following SQL commands:                                                                            

  1. Select firstname,salary from employees ,empsalary where designation = ‘Salesman’ and Employees.empid=Empsalary.empid;
  2. Select count(distinct designation) from empsalary;
  3. Select designation, sum(salary) from empsalary group by designation having count(*) >2;
  4. Select sum(benefits) from empsalary where designation =’Clerk’;

 

7. (a) What do you understand by Selection and Projections in relational algebra ?           

Consider the following table EMPLOYEE and salgrade and answer (b) and (c) part of the Question:

Table: EMPLOYEE

ECODE

NAME

DESIG

SGRADE

DOJ

DOB

101

Abdul Ahmad

EXECUTIVE

S03

23-Mar-2003

13-Jan-1980

102

Ravi Chander

HEAD-IT

S02

12-Feb-2010

22-Jul-1987

103

John Ken

RECEPTIONIST

S03

24-Jan-2009

24-Feb-1983

104

Nazar Ameen

GM

S02

11-Aug-2006

03-Mar-1984

105

Priyam Sen

CEO

S01

29-Dec-2004

19-Jan-1982

 

Table:SALGRADE

 

SGRADE

SALARY

HRA

S01

56000

18000

S02

32000

12000

S03

24000

8000

(b) Write SQL commands for the following statements:                                                                

(i) To display the details of all EMPLOYEES in descending order of DOJ.

(ii) To display NAME and DESIG of those EMPLOYEES whose SALGRADE is either S02 or SO3.

(iii) To display the content of all the EMPLOYEES table, whose DOJ is in between 09-Feb-2006 and 08-Aug-2009.

(iv) To add a new row with the following

109, ‘Harish Roy’, ‘HEAD-IT’, ‘S02’,’09-Sep-2007’, ’21-Apr-1983’

(c) Give the output of the following SQL queries :                                                                                            

                (i) SELECT COUNT(SGRADE), SGRADE  FROM EMPLOYEE GROUP BY SGRADE;

                (ii) SELECT MIN(DOB), MAX(DOJ) FROM EMPLOYEE;

                (iii) SELECT NAME,SALARY FROM EMPLOYEE E, SALGRADE S

WHERE E.SGARDE=S.SGRADE AND E.ECODE<103;

                (iv) SELECT SGRADE, SALARY+HRA FROM SALGRADE WHERE SGRADE=’S02’

Get 2 Months for $5!