Data Visualisation — Computer Science STD 12 Science — Question

Write the output produced by the following SQL commands:

WAF update_record_rool(n) to read the student number as parameter and update the record in student table.

Observe the table ‘Club’ given below:

Table: Club

Member_id	Member_Name	Address	Age	Fee
M001	Sumit	New Delhi	20	2000
M002	Nisha	Gurgaon	19	3500
M003	Niharika	New Delhi	21	2100
M004	Sachin	Faridabad	18	3500

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

(ii) If a new column contact_no has been added and three more members have joined the club then how these changes will affect the degree and cardinality of the above given table.

Write a function to read the content from the "quotes.txt" and transfer the content to the file "Duplicate.txt" but while transfer all the upper case character to lower case character, lower case character to uppercase character and rest of the character as it is.

Write the algorithm for the bubble sort.

What is Trojan Horse?     

Write a python script to read a number from the user and print the Fibonacci series up to that number.

What are the adverse effects of e-Waste?

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?