Data Structure — Computer Science STD 12 Science — Question

Write the output for the following commands:

Table- Loan_accounts

account	cust_name	loan_amount	installment	int_rate	start_rate	interest
1	R.K. Gupta	300000	36	12.00	2009-07-19	Null
2	S.P. Sharma	500000	48	10.00	2008-03-22	Null
3	K.P. Jain	300000	36	Null	2007-08-03	Null
4	M.P. Yadav	800000	60	10.00	2008-12-06	Null
5	S.P. Sinha	200000	36	12.50	2010-01-03	Null
6	P. Sharma	700000	60	12.50	2008-06-05	Null
7	K.S. Dhall	500000	48	Null	2008-03-05	Null

(a)

(b)

(c)

(d)

(e)

Consider the following table Bank.

Table: Bank

AccNo	Cust_name	FD_Amount	Months	Int_Rate	FD_Date
1001	Arti Gupta	30000	36	6.00	2018-07-01
1002	Dilip Lal	50000	48	6.75	2018-03-22
1003	Navin Gupta	30000	36	NULL	2018-03-01
1004	D.P. Yadav	80000	60	8.25	2017-06-12
1005	Jyoti Sharma	20000	36	6.50	2017-01-31
1006	Rakesh Kumar	70000	60	8.25	2018-06-15
1007	K.D. Singh	50000	48	NULL	2018-07-05
1008	Anjali Sharma	60000	48	6.75	2017-04-02
1009	Swati Garg	40000	42	6.50	2018-06-15
1010	Rupinder Kaur	25000	36	6.50	2018-09-27

Write SQL commands for the statements (a) to (g) on the table BANK

(a) Display details of all the FD whose rate of interest is NOT NULL.

(b) Display amounts of various FD from the table Bank. An FD Amount should appear only once.

(c) Display the number of months of various loans from the table Bank. A month should appear only once.

(d) Display the Customer Name and FD Amount for all the Bank which do not have a number of months is 36.

(e) Display the Customer Name and FD Amount for which the FD amount is less than 500000 or int_rate is more than 7.

(f) Display the details of all FD which started in the year 2018.

(g) Display the details of all FD whose FD_Amount is in the range 40000 to 50000.

Write a script to create a list of 10 random floating point numbers and then
(a) Find the mean of the elements present in the list (without using sum() function)
(b) Find the mean of all those elements of the list which are more than the mean calculated in 5c (above part of the question)

Write a menu based python program using function to find TSA and Vol of Cylinder, Sphere and Cone according to choice entered by the user.

Write the different types of plagiarism.

Expertia Professional Global (EPG) is an online corporate training provider company for IT related courses. The company is setting up their new campus in Mumbai. You as a network expert have to study the physical locations of various buildings and the number of computers to be installed. In the planning phase, provide the best possible answers for the queries (a) to (d) raised by them.

Building to Building distances (in Mtrs.)

FROM	To	Distance
Administrative Building	Finance Building	60
Administrative Building	Faculty Studio building	120
Finance Building	Faculty Studio building	70

Number of computers in each of the blocks/Center is as follows:

Administrative Building	20
Finance Building	40
Faculty Studio building	120

(a) Suggest the most appropriate building, where EPG should plan to install the server.

(b) Suggest the most appropriate building to building cable layout to connect all three buildings for efficient communication.

(c) Which type of network out of the following is formed by connecting the computers of these three buildings?

LAN, MAN, WAN

(d) Which wireless channel out of the following should be opted by EPG to connect to students of all over the world?

Infrared, Microwave, Satellite

Write a script to create two lists of 5 floating point values each and then
(a) Sort the first list using sort() method and display it without using any loop
(b) Reverse the second list using reverse() method and display it without using any loop
(c) Append the second list to the first list using extend() method
(d) Delete all the elements from the second list using clear() method
(e) Display the first list (after performing the above operations)
(f) Input an integer from the user and find how many times does it exist in the first list using count() method

Write a function search () to search a record in a binary file according to the student number entered by the user. Also display the message “Record not found” in case record not found in the file.

Granuda Consultants are setting up a secured network for their office campus at Faridabad for their day to day office and web based activities. They are planning to have connectivity between 3 buildings and the head office situated in Kolkata. Answer the questions (a) to (d) after going through the building positions in the campus and other details, which are given below:

Distances between various buildings:

Building “RAVI” to Building “JAMUNA”	120m
Building “RAVI” to Building “GANGA”	50m
Building “GANGA” to Building “JAMUNA”	65m
Faridabad Campus to Head Office	1460km

Number of computers:

Building “RAVI”	25
Building “JAMUNA”	150
Building “GANGA”	51
Head Office	10

(a) Suggest the most suitable place (i.e. block) to house the server of this organization. Also give a reason to justify your suggested location.

(b) Suggest a cable layout of connections between the buildings inside the campus.

(c) Suggest the placement of the following devices with justification:

(i) Switch

(ii) Repeater

(d) The organization is planning to provide a high speed link with its head office situated in KOLKATA using a wired connection. Which of the following cable will be most suitable for this job?

(i) Optical Fiber

(ii) Co-axial cable

(iii) Ethernet cable

Write AddClient(Client) and DeleteClient(Client) methods in python to add a new Client and delete a Client from a List of Client Names, considering them to act as insert and delete operations of the queue data structure.