Page 295 - IT-802_class_12
P. 295

Subject Enrichment
            C.  Competency-based/Application-based question:
                  Ananya is creating an online shopping application. She wants to create a table for wish list. But she has no idea what
                 elements this table should have. Help her by giving the details of the Wish List table and its schema.

             Ans.  WISH_LIST (Buyer_id Commodity_id)

                             Name                      Type                            Description
                  Shipment_id                  INT(10)               Buyer number(Primary key and Foreign key)

                  Commodity_id                 INT(10)               Commodity number (Primary Key and Foreign key)




            Unsolved Exercise



                                                            Section A
                                                     (Objective Type Questions)
            A.  Choose the correct option.
               1.  Which of the following is not an example of eGovernance?
                 i.  To file property tax                          ii.  To apply for renewal of Passport
                 iii. To  start an online coding course for 3 months    iv.  To get Voters ID card issued
               2.  Which of the following is/are the applications of database in e-commerce?
                 i.  To maintain details on transactions that happens everyday
                 ii.  To store information on products such as price, quantity, quality, manufacturing date, and seller.
                 iii. To store information on the plans offered and plans subscribed by the users.
                 iv. All of these
               3.  Which of the following is the foreign key in order table?
                 i.  Order_id                                      ii.  Buyer_id
                 iii. Order_date                                   iv.  Current_status
               4.  What is the data type of Payment_date?
                 i.  Int                                           ii.  Varchar
                 iii. Date                                         iv.  Char
            B.  Fill in the blanks.

               1.  Cash on Delivery is a payment method in ................................ .
               2.  The primary key of ................................ table is a combination of both its attributes, the buyer_id and commodity_id.
               3.  The Phase of application development that involves creating a database and writing code is called ................................ .

               4.  If the buyer selects any category on the website, function ................................ is invoked to display all the products in that
                 category.

                                                            Section B
                                                    (Subjective Type Questions)
            A.  Short answer type questions.
               1.  What is the importance of password field on online reservation site?        [CBSE Sample Paper 2021]
               2.  Write any two uses of database in airlines.

               3.  What information does the PACKAGE table store?
               4.  Name the foreign keys of WISH LIST table.

                                                                                 Work-Integrated Learning IT-DMA  293
   290   291   292   293   294   295   296   297   298   299   300