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
   276   277   278   279   280   281   282   283   284   285   286