Work Integrated Learning IT DMA Notes | Class 12 IT 802

Work Integrated Learning IT DMA Notes is designed for students of Class 12 IT 802. it includes potential work area of database application, how database can be used various domains,

What is Work Integrated Learning?

Work integrated learning refers to integrating academic learning with its real time practical applications. The main objective of WIL is to support experiential learning and develop decision making and problem solving ability in the students.

What is Work Integrated Learning IT?

Work integrated learning IT refers to integrating academic learning with its real time practical applications in the field of Information Technology.

Identification of Potential Work Area

What are the work areas that uses database management system?

  • Education
  • Banking
  • Hospitals
  • Government sectors
  • Companies
  • E-commerce
  • Airlines
  • Railways
  • Telecommunications
  • Hotels

How DBMS can be used in the area of Education?

  • For storing information such as student details, marks and result.
  • For storing information about faculty and staff members.
  • For storing details about school/college such as infrastructure details, department and offered course details.

How DBMS can be used in the area of Banking?

  • For storing information about customers For example,
    • Personal details such as address, age, PAN card, occupation, contact numbers.
    • Accounts and loans related information.
    • Information regarding daily transactions.
  • For storing employee details such as their personal information, salary, leaves taken, joining date, retirement year.

How DBMS can be used in the area of Hospitals?

  • For maintaining information regarding patients such as their personal details, health records, hospitalization date.
  • For storing information regarding doctors, nurses, staff members, rooms, medical equipment, and medicines.

How DBMS can be used in the area of Government Sector?

  • For storing details of electoral roll, all types of taxes (Income tax, sales tax, house tax etc.), criminal records.
  • For storing details of PAN cards, AADHAR cards, vehicle registration, birth/death certificate registration.

How DBMS can be used in the area of  Companies?

  • For storing information regarding employees such as name, address, contact number, salary, position, joining date.
  • For maintaining information regarding the projects handled by them.
  • For keeping track of infrastructure, sales, and investments.

How DBMS can be used in the area of  E-Commerce?

  • For storing information regarding products such as price, quantity, quality, manufacturing date, seller.
  • For storing information regarding customers such as name, contact number, address and their orders.

How DBMS can be used in the area of Airlines?

  • For storing information about flight details such as arrival time, departure time, fares, passenger capacity, number of bookings.
  • For keeping track of online and offline reservations.

How DBMS can be used in the area of Railways?

  • For storing information about train details such as arrival time, departure time, fares, passenger capacity, number of bookings.
  • For keeping track of online and offline reservations.

How DBMS can be used in the area of Telecommunication?

  • For storing information regarding communication networks, customers, call records, and their bills.
  • For storing information about the plans offered and plans subscribed by the users

How DBMS can be used in the area of Hotels?

  • For storing information regarding guests, their check-in and check-out times, duration of stay, room number allocated.
  • For keeping track of booked and available rooms.
  • For storing information regarding hotel staff, menu items, and infrastructure.

List of Applications that can be developed using database in their respective domains (areas)

  • College/school management application.
  • Online reservation application for airline, railways, buses, movie and hotels.
  • Application for online tutorials and tests.
  • Hospital management application.
  • Company management application.
  • Bank management application.
  • Shopping application.
  • Bill payment and bill generation application.
  • Library management application.
  • Real estate management application.
  • Inventory control application.
  • Shop management application.
  • Restaurant management application.
  • Telecom management application.
  • Insurance management application.

6 thoughts on “Work Integrated Learning IT DMA Notes | Class 12 IT 802”

Leave a Comment

Your email address will not be published. Required fields are marked *

error: Content is protected !!