Class 12 – Information Technology [Code 802]
Unit 4: Work Integrated Learning IT – DMA
Important Question Answer / Notes as Question Answer
Que 1: Why DBMS is used in various domains?
Answer: Database management systems have found applications in various domains as they provide efficient storage and fast retrieval of data.
Que 2: List advantages of Work Integrated Learning with a suitable. [CBSE SQP]
Answer: Allows the user to Integrate front-end and back-end Applications.
For Example:-
The database can be created in any RDBMS package and Front End can be created in Java NetBeans
Que 3: Describe how Database management applications can be used in the Banking sector. OR Explain Work integrated learning with respect to the Banking sector. [CBSE SQP]
Answer: Database management applications can be used in the Banking sector are: –
For storing information about customers. For example,
(i) Personal details such as an address, age, PAN card, occupation, and contact numbers.
(ii) Accounts and loans-related information.
(iii) Information regarding daily transactions.
For storing employee details. For example,
(i) Personal information and salary,
(ii) Leaves taken, joining date, retirement year.
Que 4: Describe how Database management applications can be used in the Education sector. OR Explain Work integrated learning with respect to the Education sector. [CBSE QP 2018, SQP]
Answer: Database management applications can be used in the Education sector are: –
(i) For storing information such as student details, marks, and results.
(ii) For storing information about faculty and staff members.
(iii) For storing details about the school/college such as infrastructure details, department, and offered course details.
Que 5: Describe how Database management applications can be used in the Hospitals sector. OR Explain Work integrated learning with respect to the Hospital sector. [CBSE SQP]
Answer: Database management applications can be used in the Hospitals are:
(i) For maintaining information regarding patients such as their personal details, health records, and hospitalization data.
(ii) For storing information regarding doctors, nurses, staff members, rooms, medical equipment, and medicines.
Que 6: Describe how Database management applications can be used in the Government sector. OR Explain Work integrated learning with respect to the Government sector. [CBSE SQP 22-23]
Answer: Database management applications can be used in Government Sector, for storing details of
- Electoral roll,
- All types of taxes – Income tax, Sales tax, House tax, GST, etc.
- Criminal records.
- PAN cards,
- AADHAR cards,
- Vehicle registration,
- Birth/Death certificate registration.
Que 7: Describe how Database management applications can be used in the Companies. OR Explain Work integrated learning with respect to Companies. [CBSE SQP]
Answer: Database management applications can be used in companies are:
(i) For storing information regarding employees such as name, address, contact number, salary, position, and joining date.
(ii) For maintaining information regarding the projects handled by them.
(iii) For keeping track of infrastructure, sales, and investments.
Que 8: Describe how Database management applications can be used in E-Commerce. OR Explain Work integrated learning with respect to the E-Commerce sector. [CBSE SQP]
Answer: Database management applications that can be used in E-Commerce are:
(i) For storing information regarding products such as price, quantity, quality, manufacturing date, and seller.
(ii) For storing information regarding customers such as name, contact number, address and their orders.
Que 9: Describe how Database management applications can be used in the Airlines. OR Explain Work integrated learning with respect to the Airline sector. [CBSE SQP]
Answer: Database management applications can be used in Airlines are:
(i) For storing information about flight details such as arrival time, departure time, fares, passenger capacity, and number of bookings.
(ii) For keeping track of online and offline reservations.
Que 10: Describe how Database management applications can be used in the Railways. OR Explain Work integrated learning with respect to Railways. [CBSE SQP]
Answer: Database management applications that can be used in Railways are:
(i) For storing information about train details such as arrival time, departure time, fares, passenger capacity, and number of bookings.
(ii) For keeping track of online and offline reservations.
Que 11: Describe how Database management applications can be used in the Telecommunications. OR Explain Work integrated learning with respect to Telecommunications sector.
Answer: Database management applications can be used in Telecommunications are:
(i) For storing information regarding communication networks, customers, call records, and their bills.
(ii) For storing information about the plans offered and plans subscribed by the users.
Que 12: Describe how Database management applications can be used in the Hotels. OR Explain Work integrated learning with respect to Hotel sector. [CBSE SQP]
Answer: Database management applications can be used in Hotels are:
(i) For storing information regarding guests, their check-in and check-out times, duration of stay, room number allocated.
(ii) For keeping track of booked and available rooms.
(iii) For storing information regarding hotel staff, menu items, and infrastructure.
Que 13: Write the name of applications which require DBMS.
Answer: DBMS can be used in various applications. These are:
(i) College/school management application.
(ii) Online reservation application for airline, railways, buses, movie and hotels.
(iii) Application for online tutorials and tests.
(iv) Hospital management application.
(v) Company management application.
(vi) Bank management application.
(vii) Shopping application.
(viii) Bill payment and bill generation application.
(ix) Library management application.
(x) Real estate management application.
(xi) Inventory control application.
(xii) Shop management application.
(xiii) Restaurant management application.
(xiv) Telecom management application.
(xv) Insurance management application.
Que 14: Name one front end and one Back end application to create Web Applications. [CBSE SQP]
Answer: Front end – Java NetBeans; Back end – MySQL
Que 15. Explain User Interface with a suitable example. [CBSE SQP]
Answer: User Interface is a design of an application with which user interacts or communicates with the program. It must be user friendly, easy to interact. For example
Que 16: A Hospital is making database of patients and its staff. Doctor table includes Docid, Dname, Department. Give details of Patient Table along with its schema. [CBSE SQP 21-22]
Answer: The structure of table Patient is
| Name | Type | Remarks |
| pid | Varchar(5) | Patient unique number |
| pname | Varchar(20) | Patient name |
| phone | Int(10) | Patient phone no |
| disease | Varchar(20) | Disease he/she is suffering from |
Schema of table Patient :- Patient (pid, pname,phone,disease)
Que 17: Name two domains where database management may be used. [CBSE SQP 22-23]
Answer: Education, Banking, Hotels, Railways, Airlines, Companies, Hospitals, etc.
Que 18: A company is making database of its items and shipment. Item table includes item code, item name, item cost. Give details of Shipment Table along with its schema. [CBSE SQP 22-23]
Answer: Details of Shipment Table is
| Name | Type | Remarks |
| Shipment_id | INT(10) | Shipment number (Primary Key) |
| Details | VARCHAR(30) | Location details |
| Shipment_date | DATE | Date of shipment |
Schema of Shipment Table is : SHIPMENT (Shipment_id, Details, Shipment_date)
Que 19: The telephone banking service includes [CBSE QP 2017]
1. Automatic balance voice out
2. Inquiry all term deposit account
3. Direct cash withdraw
4. Utility bill payments
5. Voice out last five transactions
(a) 1, 2, 3 and 5 only
(b) 1, 2, 4 and 5 only
(c) 2, 3, 4 and 5 only
(d) All 1, 2, 3, 4 and 5
Answer: (b) 1, 2, 4 and 5 only
Que 20: What are the benefits of Work Integrated Learning to students? [CBSE QP 2017]
Answer: Benefits of Work Integrated Learning are –
- A student can learn to create and design of Database.
- A student can learn to create and design user interface.
- A student can learn to how to use and connect Front end to Back end.
Que 21: What is the meaning/purpose of Work Integrated Learning? [CBSE QP 2017, 18]
Answer: Work Integrated learning (WIL) is the term given to educational activities that integrate academic learning of a discipline with its practical application in the workplace. The aim is to ensure that students develop the ability to integrate their learning through a combination of academic and work-related activities. It helps in creating application based on front end and back end.
