CBSE COMPUTER SCIENCE

'''Write a python program where an element of the length of the list L is added in list L repeatedly. L=[9,'March',1995] Expected output: L=[9,'March',1995,3,4,5,6.....n] {from 3 to n - newly added element (by the length of the list L)}''' L=[9,'March',1995] N=int(input('Number of Terms')) for i in range(len(L),N+1): L.append(i) print(L)

[0:22 am, 16/02/2024] SHUN: 1. https://t.me/askpythonquestions 2. https://t.me/cbsecomputerscience 3. https://t.me/todayweareaslearners 4. Python Basics-1 t.me/QuizBot?start=ayrNqFKS 5. Python List-1 t.me/QuizBot?start=eowBkzeL 6. Python List-2 t.me/QuizBot?start=k8DYZ3Oa 7. Python List-3 t.me/QuizBot?start=Smn9ThxH 8. Python FILE HANDLING -1 t.me/QuizBot?start=nQD1Q3kG 9. Python FILE HANDLING -2 t.me/QuizBot?start=vx12PVG3 10. Python FILE HANDLING -3 t.me/QuizBot?start=7VvdcQtz 11. Python FILE HANDLING -4 t.me/QuizBot?start=MnPrt2v4 12. Python FILE HANDLING -5 t.me/QuizBot?start=ohtwqD6S [0:25 am, 16/02/2024] SHUN: S SHUNMUGA SUNDARAM, M.E, A.M.I.E, MISTE,. IAENGG, [26-03-2022 PM 10:52] https://docs.google.com/forms/d/e/1FAIpQLSfmxplpwpPhPSSes85fNfzncjnJr_44F-Je6oaQxqOXegZUjQ/viewform?usp=sf_link S SHUNMUGA SUNDARAM, M.E, A.M.I.E, MISTE,. IAENGG, [26-03-2022 PM 10:56] https://docs.google.com/forms/d/e/1FAIpQLSerzc_CmhXPqPaavdIylIdVqx5SqONqMLWDxNwkjVBf50ddTw/viewform?usp=sf_link S SHUNMUGA SUNDARAM, M.E, A.M.I.E, MISTE,. IAENGG, [26-03-2022 PM 10:57] https://docs.google.com/forms/d/e/1FAIpQLScv8gwLmRu5d6j0nCRisCZvAMasyxrDjo13indJBCxlNGQnCw/viewform?usp=sf_link S SHUNMUGA SUNDARAM, M.E, A.M.I.E, MISTE,. IAENGG, [26-03-2022 PM 10:58] https://docs.google.com/forms/d/e/1FAIpQLSecNF_hZlT1v7mPBDqwbOziAets89bAuCuv7outXM3XOlGl4g/viewform?usp=sf_link S SHUNMUGA SUNDARAM, M.E, A.M.I.E, MISTE,. IAENGG, [26-03-2022 PM 10:59] https://docs.google.com/forms/d/e/1FAIpQLSe90SPfhaMr5W-Z2KGfks-TCNe5Xt3oPQALUmz0J68TvwXHmA/viewform?usp=sf_link S SHUNMUGA SUNDARAM, M.E, A.M.I.E, MISTE,. IAENGG, [26-03-2022 PM 11:00] https://docs.google.com/forms/d/e/1FAIpQLSeRkJ9rhxQxJNEumkDTDhHd-pkeMIWZdNa5yxFQmEgv9YxSnQ/viewform?usp=sf_link

17. Consider the following Employee table – Table Name – Employee The primary key of this table is Employee_ID and Manager_ID is a foreign key that references Employee_ID. Write SQL commands for the following: (a) Create the above table CREATE TABLE EMPLOYEE ( Employee_ID INTEGER PRIMARY KEY, Employee_Name VARCHAR(20) NOT NULL, Job_Title VARCHAR(20), Salary DECIMAL(10,2) DEFAULT 40000, Bonus VARCHAR(10), Age INTEGER, FOREIGN KEY (Manager_ID) REFERENCES Employee(Employee_ID) ); (b) Insert values as shown above INSERT INTO Employee ( Employee_Id, Employee_Name, Job_Title, Salary, Bonus, Age, Manager_Id) Values (1201, “Divya”, “President”, 50000, NULL, 29, NULL); or INSERT INTO Employee ( Employee_Id, Employee_Name, Job_Title, Salary, Bonus, Age, Manager_Id) Values (1201, “Divya”, “President”, 50000, NULL, 29, NULL), (1205, “Amyra”, “Manager”, 30000, 2500, 26, 1201), (1211, “Rahul”, “Analyst”, 20000, 1500, 23, 1205), (1213, “Manish”, “Salesman”, 15000, NULL, 22, 1205), (1216, “Megha”, “Analyst”, 22000, 1300, 25, 1201), (1217, “Mohit”, “Salesman”, 16000, NULL, 22, 1205); (c) Delete the Employee having Employee_ID 1217. DELETE FROM Employee WHERE Employee_Id = 1217; (d) Update the salary of “Amyra” to 40000. UPDATE Employee SET Salary = 40000 WHERE Employee_Name = “Amyra”; (e) Alter the table Employee so that NULL values are not allowed for Age column. ALTER TABLE Employee MODIFY Age INTEGER NOT NULL; (f) Write a query to display names and salaries of those employees whose salary are greater than 20000. SELECT Employee_Name, Salary FROM Employee WHERE Salary>20000; (g) Write a query to display details of employees who are not getting any bonus. SELECT * FROM Employee WHERE Bonus IS NULL; (h) Write a query to display the names of employees whose name contains “a” as the last alphabet. SELECT Employee_Name FROM Employee WHERE Employee_Name LIKE “%a”; (i) Write a query to display the name and Job title of those employees whose Manager_ID is 1201. SELECT Employee_Name, Job_Title FROM Employee WHERE Manager_ID = 1201; (j) Write a query to display the name and Job title of those employees whose Manager is “Amyra” SELECT Employee_Name, Job_Title FROM Employee WHERE Manager = “Amyra”; (k) Write a query to display the name and Job title of those employees aged between 26 years and 30 years. SELECT Employee_Name, Job_Title FROM Employee WHERE Age BETWEEN 26 AND 30; 18. A Railway company uses machines to sell tickets. The machine details and daily sales information are recorded in two tables: The primary key of the table Machine is Machine_ID. Records in the table Sales are uniquely identified by the fields Machine_ID and Date. (a) Create the tables Machine and Sales. CREATE TABLE MACHINE ( MACHINE_ID CHAR(3) PRIMARY KEY, Station CHAR(30) ); CREATE TABLE SALES ( MACHINE_ID CHAR(3) NOT NULL UNIQUE, Date DATE NOT NULL UNIQUE; Tickets_Sold INTEGER; Income DECIMAL(8,2) ); (b) Write a query to find the number of ticket machines in each station. SELECT Station FROM Machine GROUP BY Tickets_Sold; (c) Write a query to find the total ticket income of the station “New Delhi” of each day. SELECT Station FROM Machine where Station=”New Delhi” GROUP BY Sales HAVING SUM(Income); (d) Write a query to find the total number of tickets sold by the machine (Machine_ID = 122) till date. SELECT SUM(Tickets_Sold) FROM Sales WHERE Machine_ID = 122;

Online classes for IP and CS.. Contact 9994548619

SAMPLE PAPERS REGARDING