Dear students

You can opt anyone topic from these in group of minimum 2 members

LIST OF PROJECTS OF COMPUTER SCIENCE OF CLASS XII:

  1. Student Management System
  2. Hotel Management System
  3. Blood Banking system
  4. Audio-Video Library Management System
  5. Library Management system
  6. Payroll Management system
  7. Air-Ticketing System
  8. Health Club Management system
  9. Online Admission system
  10. Telephone directory system
  11. Retail shop system
  12. Canteen Management System
  13. Time-table Management System
  14. Income-Tax Calculation System
  15. Inventory Control System
  16. Hospital Management System
  17. Banking Management System
  18. Employee Information System
  19. Automation of Fees System
  20. Computerized Voter System
  21. ATM 22. Macdonald’s – Food ka Mood 23. OLX.in

Thanks

Teacher- Mrs. Jyoti Bhatia

KV AFS Arjangarh

New Delhi-47

NEW LIST OF PRACTICALS

Class XII

CLASS, OBJECT, CONSTRUCTOR & DESTRUCTOR

  1. Define a class HOTEL to represent records of 10 customers with the following data member.

i) Room No ii) Name of the customer

iii) Type of Room (A for AC-Room N for Non-AC Room), iv) Tariff (per day) v) Bill

The class also contains member functions to do the following:-

(i) Create an account of new customer (ii) To Calculate the bill of Customer as per following specifications: *AC- Rs. 500 per day

*NON AC- Rs. 300 per day

(iii) To Display the data member(iv) Exit

  1. Write a C++ Program using classes and objects to simulate result preparation system for 30 students. The data available for each student includes roll no, name and marks in 3 subjects. The percentage marks and grade are to be calculated from the above information. The percentage marks are the average marks and the grade is calculated as:

Percentage marksGrade

<50‘F’

>= 50 & <60‘D’

>=60 & <75‘C’

>= 75 & <90‘B’

>= 90 & <100‘A’

  1. Define a class CLOTHING to represent fabrics details with the following data member.

i) Code (Integer) ii) Type (String)

iii) Material (String),iv) Qty (Integer).v) Price (Float)vi) Bill (Float)

The class also contains member functions to do the following:

(i) Create a new order (ii) To calculate the price as per specifications:

Type price

TROUSER 1500

SHIRT 1200

for material other than "COTTON" gets reduced price by 25%.

(iii) To calculate the billiv) to initialize the data members. (Constructor)

(v) To Display the data member(vi) Exit

  1. Make a class RETAIL by using constructor overloading and destructor with following details:

i) Category (String) ii) Type (String)

iii) Qty (Integer).iv) Price (Float)v) Bill (Float)

INHERITANCE
  1. Construct classes using Multiple Inheritance in it.
  2. Construct classes showing Hierarchical Inheritance in it.
DATA FILE HANDLING
  1. Write a menu driven program in C++ using following user defined functions
  • To Create a text file called abc.txt
  • To count the characters present in text file.
  • To count the words present in text file.
  • To count the lines present in text file.
  • To display the content of text file on screen
  • Exit
  1. WAMP in C++ by using a class Hotel whose objects are written in a binary file called “HOTEL.DAT” and performs following operations on it.

1)Add a new record in binary file.

2)Display all records of binary file.

3)Copy records into another binary file “REST.DAT”

4)Search for a matching record depending on the name of Customer.

5)Exit

ARRAY
  1. WAMP in C++ to perform following operations on 1-D Array:-
  1. Create an array of 10 integers
  2. Sort the array using bubble sort
  3. Search for a given integer from the array using linear search.
  4. Search for a given integer from the array using binary search.
  5. Display resultant array
  6. Exit
  1. Write a menu driven program to perform following functions on 2-D Array -

1)Accept one matrix of mxn order.

2)Sum of each diagonal of a given matrix.

3)Sum of each row of a given matrix.

4)Product of each column of a given matrix.

5)Sum of alternate elements of given matrix.

6)Transpose of a given matrix.

7)Exit

  1. Write a menu driven program to perform following functions on 2-D Array -

1)Accept two matrices of mxn and pxq dimensions.

2)Sum of Matrices

3)Product of Matrices

4)Exit

  1. Write a menu driven program to perform following functions on 1-D Array -

1)Accept two 1-D arrays containing M and N Element resp.

2)Sort the array using selection sort in descending order.

3)Merge both arrays in third array in ascending order.

4)Display third array.

5)Exit

STACK AND QUEUE
  1. Write a C++ program to implements a Stack using Array. The stack stores integer data. The program should allow the user to PUSH elements into the STACK, POP elements from the STACK & display the elements of the STACK.
  2. Write a C++ program to implements a Stack using Linked List. The stack stores integer data. The program should allow the user to PUSH elements into the STACK, POP elements from the STACK & display the elements of the STACK.
  3. Write a C++ program to implements a Queue using Array. The queue stores float data. The program should allow the user to insert elements into the queue, delete elements from the queue & display the elements of the queue.
  4. Write a C++ program to implements a Queue using Linked List. The queue stores float data. The program should allow the user to insert elements into the queue, delete elements from the queue & display the elements of the queue.
  5. Write a C++ program to implements a Queue using Circular Queue. The stack stores float data. The program should allow the user to insert elements into the queue, delete elements from the queue & display the elements of the queue.

SQL QUERIES

  1. Table: School_Bus

Rtno / Area_covered / Capacity / Noofstudents / Distance / Transporter / Charges
1 / Vasant kunj / 100 / 120 / 10 / Shivam travels / 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 / Kissan Tours / 95000

(a)To show all information of students where capacity is more than the no of student in order of rtno.

(b)To show area_covered for buses covering more than 20 km, but charges less then 80000.

(c)To show transporter wise total Noofstudents traveling.

(d)To show rtno, area_covered and average cost per student for all routes where average cost per student is - charges/noofstudents.

(e)Add a new record with following data:

(11, “Moti bagh”, 135, 160, 10,”Kissan tours“, 35000);

(f)Give the output considering the original relation as given:

  1. Select sum(distance) from school_bus where transporter= ‘Yadav Co.’;
  2. Select min(noofstudents) from school_bus;
  3. Select avg(charges) from school_bus where transporter= ‘Anand travels’;
  4. Select distinct transporter from school_bus;
  1. Write the SQL query commands based on following table. Consider the following tables Employee and salary. Write SQL commands for the statements (i) to (iv) and give outputs for SQL queries (v) to (viii).

Table: Employee

E_id / Name / Deptid / Qualification / Gender
1 / Deepali Gupta / 101 / MCA / F
2 / Rajat Tyagi / 101 / BCA / 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

E_id / Basic / DA / HRA / Bonus / Net Salary
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 show the name of employees department-wise.

(ii)To list the names of those employees only whose basic is greater than 3000.

(iii)To print the net salary from salary table whereas net salary is calculated as Basic+Da+Hra+Bonus.

(iv)To increase the bonus of all employees with 200.

(v)Select name from employee where e_id=(select e_id from salary where basic= (select max(basic) from salary));

(vi)select Avg(basic) from salary where bonus >40;

(vii)Select Count(*) from employee where Gender=’F’;

(viii)Select name from employee where qualification having sub-word Tech ;