Page 294 - IT-802_class_12
P. 294

B.  Long answer type questions.
           1.  How DBMS can be used in education?
         Ans.  DBMS can be used in education to:
             Ð  keep data such as student information, grades, timetable and results.
             Ð  keep track of staff and faculty details.
             Ð  keep track of school/college information like department and course offerings
             Ð  keep track of all infrastructure information.
           2.  How DBMS can be used in the areas of companies?
         Ans.  DBMS can be used in the areas of companies to:
             Ð  To maintain information regarding the projects handled by them.
             Ð  To keep track of infrastructure, sales, and investments, loose.

           3.  Name any 5 applications that can be created using database?
         Ans.  Ð  Bill payment and bill generation application
             Ð  Library management application
             Ð  Real estate management application
             Ð  Inventory control application
             Ð  Shop management application
           4.  Give details of BUYER table along with its schema.
         Ans.  Schema: BUYER (Buyer_id, Password, First_name, Last_name, Address, Email_id, Phn_no)
                           Name                        Data Type                        Description

              Buyer_id                         INT(10)                    Buyer number (Primary Key)
              Password                         VARCHAR(20)                Login password of buyer

              First_name                       VARCHAR(20)                First name of buyer

              Last_name                        VARCHAR(20)                Last name of buyer
              Address                          VARCHAR(20)                Address of buyer

              Email_id                         VARCHAR(20)                Email id of buyer
              Phn_no                           INT(10)                    Contact number of buyer

           5.  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 Sample Paper 2023]
         Ans.  SHIPMENT (Shipment_id, Details, Shipment_date)
                           Name                          Data                            Remarks

              Buyer_id                         INT(10)                     Shipment number (Primary Key)
              Details                          VARCHAR(20)                location details

              Shipment_date                     DATE                       Date of shipment

           6.  List the various ways in which database management applications can be used in Government Sector.
                                                                                           [CBSE Sample Paper 2023]
         Ans.  For storing details of electoral roll, all types of taxes (Income tax, sales tax, house tax etc.), criminal records, details of PAN
             cards, AADHAR cards, vehicle registration, birth/death certificate registration.







          292   Touchpad Information Technology-XII
   289   290   291   292   293   294   295   296   297   298   299