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

