Page 376 - Informatics_Practices_Fliipbook_Class12
P. 376

a.  Add a new column Discount in the INVENTORY table.
             b.  Set appropriate discount values for all cars keeping in mind the following:

               i.  No discount is available on the LXI model.
               ii.  VXI model gives a 10% discount.
               iii.  A 12% discount is given on cars other than LXI model and VXI model.
             c.  Display the name of the costliest car with fuel type "Petrol".

             d.  Calculate the average discount and total discount available on Car4.
             e.  List the total number of cars having no discount.
         34.  Simplified Learning consultant is opening its new office in Chennai. The new office is spread in three buildings as
            shown below:



                                           Alpha Block               Beta Block





                                                     Gamma Block



             Distances between various buildings are as follows:

             Alpha to Beta Block      65m

             Alpha to Gamma Block     120m


             Beta to Gamma Block      145m

             Number of computers:

             Alpha Block               125

             Beta Block                60

             Gamma Block               50

             As a network expert, provide the best possible answer for the following queries:
             a.  Suggest the type of network established between the buildings.
             b.  Suggest the most suitable place (i.e., building) to house the server of this organization.

             c.  Suggest the placement of REPEATER with justification.
             d.  Name a device which will be used to connect computers within each building.
             e.   The organization is planning to link its Chennai office to another office situated in a hilly region where cable
               connection is not feasible. Suggest an economic way to connect it.
        35.   “Anutulya Creations”-A start-up fashion house has set up  its main centre at Kanpur, Uttar Pradesh for its dress
            designing, production and dress supplying activities. It has 4 blocks of buildings.   [CBSE Sample Paper, 2022]
             Distance between the various blocks is as follows:
             A to D                   50 m
             A to P                   60 m



          362  Touchpad Informatics Practices-XII
   371   372   373   374   375   376   377   378   379   380   381