Review of Python – 2 — Computer Science STD 12 Science — Question

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

Table: Trainer

TID	Tname	City	HireDate	Salary
101	Sunaina	Mumbai	1998-10-15	90000
102	Anamika	Delhi	1994-12-24	80000
103	Deepti	Chandigarh	2001-12-21	82000
104	Meenakshi	Delhi	2002-12-25	78000
105	Richa	Mumbai	1996-01-12	95000
106	Maniprabha	Chennai	2001-12-12	69000

Table: Course

CID	CNAME	FEES	STARTDATE	TID
C201	AGDCA	12000	2018-07-02	101
C202	ADCA	15000	2018-07-15	103
C203	DCA	10000	2018-10-01	102
C203	DDTP	9000	2018-09-15	104
C205	DHN	20000	2018-08-01	101
C206	O LEVEL	18000	2018-07-25	105

(a) Display the Trainer Name, City and Salary in descending order of their hire date.

(b) To display the TNAME and CITY of Trainer of joined the institute in the month of December 2001.

(c) To display TNAME, HIREDATE,CNAME, STARTDATE from tables TRAINER and COURSE whose FEES is less than or equal to 10000

(d) To display number of trainer from each city

(e) select tid, tname,from trainer where city not in(‘delhi’,’mumbai’);

(f) select distinct tid from course;

(g) select tid , count (*), min(fees) from course group by tid having count(*)>1;

(h) Select count(*),sum(fees) from course where startdate <’2018-09-15’;

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

Observe the following table and answer the parts (i) and (ii) accordingly

Table: Product

Pno	Name	Qty	PurchaseDate
101	Pen	102	12-12-2011
102	Pencil	201	21-02-2013
103	Eraser	90	09-08-2010
109	Sharpener	90	31-08-2012
113	Clips	900	12-12-2011

(a) Write the names of most appropriate columns, which can be considered as candidate keys.

(b) What is the degree and cardinality of the above table?

 WAP to input 10 numbers and then display their sum and average. Also display the largest and the smallest of the numbers entered.

Answer the following questions based on the given script/code.

(a) Name the variable used as parameter.
(b) Name the variable used as an argument
(c) Write function header statement.

(d) Which statement will return a value?
(e) Name a local variable(s).
(f) Name a global variable(s).
(g) Write function call statement.
(h) Variable 'a' will return the value to variable ______________.
(i) Name formal parameter

Write a script to create an empty list and then
(a) Input 10 numbers from the users and store them in the list using append() method
(b) Find the sum of all the even elements present in the list

Differentiate between PAN and LAN types of networks. 

Observe the following table and answer the parts (i) and (ii) accordingly

Table: Product

Pno	Name	Qty	PurchaseDate
101	Pen	102	12-12-2011
102	Pencil	201	21-02-2013
103	Eraser	90	09-08-2010
109	Sharpener	90	31-08-2012
113	Clips	900	12-12-2011

(a) Write the names of most appropriate columns, which can be considered as candidate keys.

(b) What is the degree and cardinality of the above table?

Out of the following, which is the fastest (a) wired and (b) wireless medium of communication?

Infrared, Coaxial Cable, Ethernet Cable, Microwave, Optical Fiber

The data is about Time devoted by a student in various subject = 'English', 'Physics', 'Chemistry', 'Mathematics', 'Comp. Sci.' time (in hours) = 0.3, 1.5, 1.5, 2, 0.4. Write a python program to draw PIE chart for the above data.