Page 296 - IT-802_class_12
P. 296

B.  Long answer type questions.
           1.  List the various ways in which database management applications can be used in government sector.

           2.  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.

           3.  A hospital is making database of patients and its staff. Doctor table includes Docid, Dname, and Department. Give details of
             Patient Table along with its schema.

           4.  Give details of PAYMENT Table along with its schema.
           5.  Aman wants to shop shoes online. Write detailed Steps/ procedure to be followed while shopping online.
                                                                                           [CBSE Sample Paper 2021]


        C.  Competency-based/Application-based question:                                            Subject Enrichment
               Viraj is creating an application for online shopping. He is creating a table for commodities. The information stored in this
             table is given below:
               COMMODITY (Commodity_id, Name, Category_id, Price, Quantity, Discount, Brand, Color, Size, Seller_id, Description)
              He wants to declare foreign keys in this table. Help him do so.





        Previous Years’ Questions



          1.  Predict the output:                                                                          [2023]
             String myStr = “Welcome Users”;

             System.out.println(“New String:”+myStr.toUpperCase());
         Ans.  WELCOME USERS
          2.  Write the use of database management in Railways.                                            [2022]
         Ans.   The uses of database management in Railways are as follows:
               •  To  store  information  about  train  details  such  as  arrival  time,  departure  time,  fares,  passenger  capacity,  number  of
               bookings.
               • To keep track of online and offline reservations.
          3.  (a)  How are database management concepts helpful in Telecommunications?                     [2022]
              (b)   An Airlines company is making a database of its flights and staff. The staff table includes: Emp_id, Emp_name, Emp_
                 dob, E_sal. Give the details of Flight table with its scheme.
         Ans.  (a)  The uses of database management in Telecommunication are as follows:
                  • To store information on communication networks, customers, call records, and their bills.
                  • To store information on the plans offered and plans subscribed by the users.
              (b)  Flight Table
                  Schema: Flight (Flight_Number, Fllight_From_Flight_To, Flight_capacity, Flight_Fare)
                         Name                Type                        Remarks
                  Flight_Number       INT(10)            Flight Number, Primary Key
                  Flight_From         VARCHAR(30)        Flight Departure from
                  Flight_To           VARCHAR(30)        Flight Destination
                  Flight_capacity     INT(10)            Seating capacity of flight
                  Flight_Fare         DECIMAL(10,2)      Fare of ticket



          294   Touchpad Information Technology-XII
   291   292   293   294   295   296   297   298   299   300   301