Informatics Practices
A company in Mega Enterprises has 4 wings of buildings as shown in the diagram:

Centre-to-centre distances between various buildings:
W3 to W1 — 50m
W1 to W2 — 60m
W2 to W4 — 25m
W4 to W3 — 170m
W3 to W2 — 125m
W1 to W4 — 90m
Number of computers in each of the wings:
W1 — 150
W2 — 15
W3 — 15
W4 — 25
Computers in each wing are networked but the wings are not networked. The company has now decided to connect the wings also.
(i) Suggest the most suitable cable layout for the above connections.
(ii) Suggest the most appropriate topology of the connection between the wings.
(iii) The company wants internet accessibility in all the wings. Suggest a suitable technology.
(iv) Suggest the placement of the repeater with justification.
(v) Suggest the placement of the Hub/Switch with justification if the company wants to minimize network traffic.
Answer
(i) A possible cable layout that connects all buildings with the minimum total distance could be: W3 → W1 → W2 → W4 as shown below:

(ii) Bus topology is the most appropriate topology for connecting the wings.
(iii) The company should setup an internet proxy server in wing W1. Computers of all the other wings will access the internet through this proxy server.
(iv) A repeater should be placed between W4 and W3, and another one between W3 and W2 to ensure signal strength is maintained over these longer distances.
(v) To minimize network traffic and ensure efficient data handling, the hub/switch should be placed in all wings.
Related Questions
Consider the following table named "GARMENT".
GCODE GNAME SIZE COLOUR PRICE 111 T-Shirt XL Red 1400.234 112 Jeans L Blue 1600.123 113 Skirt M Black 1100.65 115 Trousers L Brown 1500.50 116 Ladies Top L Pink 1200.25 Write SQL queries using SQL functions to perform the following operations:
(i) Display the name and price after rounding off to one decimal place.
(ii) Display all Gname in upper case.
(iii) Display the last three characters from Gname.
(iv) Display the highest Gcode from the table GARMENT.
(v) Display the sum of all prices of size 'L'.
Write the SQL functions which will perform the following operations:
(i) To return the summation of all non-NULL values of a data set.
(ii) To extract a substring starting from a position with a specific length.
(iii) To convert a string to uppercase.
(iv) To return the year for a specified date.
(v) To round off a number to a specified number of decimal places.
Write Python code to draw the following Bar graph representing the number of students in each class.

Write Python code to create a Line graph using the list of elements x and y. Set ylabel as "marks" and xlabel as "names". The title of the graph is 'Result'.
x = ['A', 'B', 'C', 'D', 'E'] y = [82, 25, 87, 14, 90]