Functions — Computer Science STD 12 Science — Question

Observe the following STUDENTS and EVENTS tables carefully and write the name of the RDBMS operation which will be used to produce the output as shown in LIST ? Also, find the Degree and Cardinality of the LIST.

Write the few points about how technology is increasing the issue related to people's social life.

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

Differentiate between Bus and Star topology of networks. 

What is VoIP?  

Write the python script to read the content from .csv file (Comma Seperated Values) i.e "Student.csv" and then transfer the content to the SQL Table.

Define Values, columns and index related to pivoting.

Write SQL commands for the following:

Table: TEACHER

TID	NAME	AGE	DEPT	DATEOFJOIN	SAL	SEX
T118	Navin	40	Computer	2010-01-10	12000	M
T107	Chetna	37	History	2008-03-24	20000	F
T105	Sandeep	46	Maths	2006-12-12	30000	M
T110	Sangeeta	35	History	2010-07-01	25000	F
T101	Rudransh	42	Maths	2004-09-05	40000	M
T121	Neeraj	38	Physics	2011-04-01	28000	M

(i) To show information about the teachers of the history department.
(ii) To list the names of teachers earning a salary between 20000 and 30000.
(iii) To count the number of male teachers.
(iv) Display gender wise total number of teachers.
(v) To list the name and age of teachers of female teachers in descending order of date of join.
(vi) Increase the salary by 10% for Maths departments.
( vii) To delete the record of teacher Neeraj.

What, out of the following, will you use to have an audio-visual chat with an expert sitting in a faraway place to fix-up a technical issue?

Distinguish between MAC address and IP address with the help of example of each.