Page 281 - IT-802_class_12
P. 281
WORK-INTEGRATED LEARNING IT-DMA 4
Previous chapters provided you with an insight into how database management concepts are helpful
for organising the data in meaningful ways. They facilitate the fast retrieval of information as and when
required. You learned the data manipulation language SQL for creating, selecting, and modifying the data
in database. You also learned about various web applications that use databases for managing the data.
The purposes of database management systems are discussed in this chapter. We will also develop a
shopping application using database management systems and java.
4.1 IdentIfIcatIon of PotentIal Work areas
Since database management systems provide efficient data storage and fast retrieval, they find applications
in a variety of fields. Let us discuss some of the domains where database applications may be used.
4.1.1 In Education
Ð ÐTo keep data such as student information, grades, timetable and results.
Ð ÐTo keep track of staff and faculty details.
Ð ÐTo keep track of school/college information like departments and course offerings.
Ð ÐTo keep track of all infrastructure information.
4.1.2 In Banking
Ð ÐTo keep track of consumer data. For instance, Customer personal information like residence, age,
gender, PAN card, occupation, and contact information will be collected.
Ð ÐTo maintain account information details like deposit, withdraw and data pertaining to loans.
Ð ÐTo maintain details on the transactions that happen every day.
Ð ÐTo keep track of employee information like personal data, pay, PF information, leaves taken, joining
date, and retirement year.
4.1.3 At Hospitals
Ð ÐTo keep data on patients, such as their personal information, medical history, and date of hospitalisation.
Ð ÐTo save data on doctors, nurses, staff members, rooms, medical equipment, and medications.
4.1.4 In Government Sector
Ð ÐTo store information on the voter registration list, all forms of taxes (such as income tax, sales tax,
service tax, and property tax), and criminal histories.
Ð ÐTo save information about birth/death certificate registration, vehicle registration, PAN card and
AADHAR card details.
Work-Integrated Learning IT-DMA 279

