Computer Science
Meticulous EduServe is an educational organization. It is planning to setup its India campus at Chennai with its head office at Delhi. The Chennai campus has 4 main buildings – ADMIN, ENGINEERING, BUSINESS and MEDIA.
Block to Block distances (in Mtrs.)
| From | To | Distance |
|---|---|---|
| ADMIN | ENGINEERING | 55 m |
| ADMIN | BUSINESS | 90 m |
| ADMIN | MEDIA | 50 m |
| ENGINEERING | BUSINESS | 55 m |
| ENGINEERING | MEDIA | 50 m |
| BUSINESS | MEDIA | 45 m |
| DELHI HEAD OFFICE | CHENNAI CAMPUS | 2175 km |
Number of computers in each of the blocks/Center is as follows:
| block/center | Number of computers |
|---|---|
| ADMIN | 110 |
| ENGINEERING | 75 |
| BUSINESS | 40 |
| MEDIA | 12 |
| DELHI HEAD | 20 |
(a) Suggest and draw the cable layout to efficiently connect various blocks of buildings within the CHENNAI campus for connecting the digital devices.
(b) Which network device will be used to connect computers in each block to form a local area network?
(c) Which block, in Chennai Campus should be made the server? Justify your answer.
(d) Which fast and very effective wireless transmission medium should preferably be used to connect the head office at DELHI with the campus in CHENNAI?
(e) Is there a requirement of a repeater in the given cable layout? Why/ Why not?
Answer
(a) Below diagrams shows the cable layout for connecting CHENNAI campus blocks:
(b) Switch network device will be used to connect computers in each block to form a local area network.
(c) Admin block in chennai Campus should be made the server, as it has maximum number of computers.
(d) Using microwave wireless transmission medium is preferable for connecting the head office in Delhi with the campus in Chennai.
(e) No, a repeater is not required in the given cable layout as the length of transmission medium between any two blocks does not exceed 70m.
Related Questions
Consider the tables PRODUCT and BRAND given below:
Table: PRODUCT
PCode PName UPrice Rating BID P01 Shampoo 120 6 M03 P02 Toothpaste 54 8 M02 P03 Soap 25 7 M03 P04 Toothpaste 65 4 M04 P05 Soap 38 5 M05 P06 Shampoo 245 6 M05 Table: BRAND
BID BName M02 Dant Kanti M03 Medimix M04 Pepsodent M05 Dove Write SQL queries for the following:
(i) Display product name and brand name from the tables PRODUCT and BRAND.
(ii) Display the structure of the table PRODUCT.
(iii) Display the average rating of Medimix and Dove brands.
(iv) Display the name, price, and rating of products in descending order of rating.
Vedansh is a Python programmer working in a school. For the Annual Sports Event, he has created a csv file named Result.csv, to store the results of students in different sports events. The structure of Result.csv is :
[St_Id, St_Name, Game_Name, Result]
Where
St_Id is Student ID (integer)
ST_name is Student Name (string)
Game_Name is name of game in which student is participating(string)
Result is result of the game whose value can be either 'Won', 'Lost' or 'Tie'.For efficiently maintaining data of the event, Vedansh wants to write the following user defined functions:
Accept() – to accept a record from the user and add it to the file Result.csv. The column headings should also be added on top of the csv file.
wonCount() – to count the number of students who have won any event.
As a Python expert, help him complete the task.
(i) Differentiate between r+ and w+ file modes in Python.
(ii) Consider a file, SPORT.DAT, containing records of the following structure: [SportName, TeamName, No_Players]
Write a function, copyData(), that reads contents from the file SPORT.DAT and copies the records with Sport name as “Basket Ball” to the file named BASKET.DAT. The function should return the total number of records copied to the file BASKET.DAT.
(i) How are text files different from binary files?
(ii) A Binary file, CINEMA.DAT has the following structure:
{MNO:[MNAME, MTYPE]}
Where
MNO – Movie Number
MNAME – Movie Name
MTYPE is Movie TypeWrite a user defined function, findType(mtype), that accepts mtype as parameter and displays all the records from the binary file CINEMA.DAT, that have the value of Movie Type as mtype.