Data File Handling — Computer Science STD 12 Science — Question

Write a python program to make the pie chart from the given data:

labels = ['Oxygen','Hydrogen','Carbon_Dioxide','Nitrogen']

values = [4500,2500,1053,500]

Write a Python programming to display a bar chart on the popularity of Programming Languages.

Sample data:

Programming languages: Java, Python, PHP, JavaScript, C#, C++ Popularity: 22.2, 17.6, 8.8, 8, 7.7, 6.7

To display even natural numbers from 2 to n, where n is to be input from the user. For example, if the value of n is 13, the output should be 2 4 6 8 10 12.

Rewrite the following code in python after removing all syntax error(s). Underline each correction done in the code.

Consider the following table HOSPITAL.

Table: HOSPITAL

PNo	Name	Age	Department	DateofAdm	Charges	Sex
1	Mayank	65	Surgery	23/02/2018	600	M
2	Babita	24	ENT	01/01/2019	400	F
3	Kashish	45	Orthopaedic	19/12/2018	400	M
4	Tarun	12	Surgery	01/10/2018	600	M
5	Manisha	36	ENT	12/01/2018	400	F
6	Imran	16	ENT	24/02/2018	400	M
7	Ankita	NULL	Cardiology	20/08/2018	800	F
8	Zoya	45	Gynecology	22/02/2018	500	F
9	Kush	19	Cardiology	13/01/2019	800	M
10	Shalini	31	Medicine	19/02/2018	300	F

Note: PNo is the primary key in the above table.

Write SQL commands for the statements (a) to (g) on the table HOSPITAL.
(a) To display the details of all the patients whose name starts with the alphabet ‘Z’.
(b) To change the age of the patient Kush to 20.
(c) To increase the charges of all the patients by 5%.
(d) To remove the record of the patient whose Name is Tarun.
(e) To add another column DocName(Doctor Name) of the type varchar in the above table.
(f) To display patient detail whose age is missing(null).
(g) To decrease the charges by 5% of all the patients admitted to the ENT department.

Input principal and time. Then calculate simple interest. If time is more than 10 years, calculate the simple interest at rate of 8% p.a. Otherwise calculate it at rate of 12% p.a.

Write the output of the given program:

Write two advantages of using an optical fiber cable over an Ethernet cable to connect two service stations, which are 190m away from each other.

Write a python program to accept a line from the user and store that in a file “story.txt”. 

Write one advantage of Star Topology of network? Also, illustrate how 5 computers can be connected with each other using Star topology of network.