Data Structure — Computer Science STD 12 Science — Question

Which protocol helps us to browse through web pages using internet browsers? Name any one internet browser.       

Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables:

TABLE: SALESPERSON

CODE	NAME	SALARY	ITCODE
1001	TANDEEP JHA	60000	I2
1002	YOGRAJ SINHA	70000	I5
1003	TENZIN JACK	45000	I2
1005	ANOKHI RAJ	50000	I7
1004	TARANA SEN	55000	I7

TABLE: ITEM

ITCODE	ITEMTYPE	TURNOVER
I5	STATIONARY	3400000
I7	HOISTERY	6500000
I2	BAKERY	10090000

(a) To display the CODE and NAME of all salesperson having “I7” item Type Code from the table SALESPERSON.
(b) To display all details from table SALESPERSON in descending order of SALARY.
(c) To display the number of SALESPERSON dealing in each TYPE of ITEM.(Use ITCODE for the same)
(d) To display NAME of all the salesperson table along with their corresponding ITEMTYPE from the ITEM table.
(e) Select max(salary) from salesperson;
(f) Select distinct itcode from salesperson;
(g) select code,name,i.itcode from sales persons, item i where s.itcode=i.itcode and turnover>=7000000;
(h) Select sum (salary)from salesperson where itcode=”i2”;

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 function addrecord() a add new record to the binary file “employee” using list. The list should consist of employee number, employee name and salary.

What is a spam mail?          

Differentiate between Candidate Key and Alternate Key in context of RDBMS.

Write a script to create a list of names of 10 cities and then
(a) Display all the elements of the list
(b) Display all the elements of the list in reverse order

Find and write the output of the following Python code:

What are the positive effects of technology?

Differentiate between cardinality and degree of a table with the help of an example.