Computer Science & Informatics Practices : XI , XII

# A complete Project on Scholar Registration demonstrating MySQL and Python Connectivity  import os import platform import mysql.connector import pandas as pd mydb=mysql.connector.connect(host="localhost",\                              user="root",\                              passwd="root",\                              database="scholar") mycursor=mydb.cursor() def RegisterScholar():     L=[]     enroll=int(input("Enter the roll number(Max 5 Digits) : "))     L.append(enroll)     name=input("Enter the Name of scholar: ")     L.append(name)     age=int(input("Enter Age of scholar : "))     L.append(age)     city=input("Enter the City of the Scholar : ")     L.append(city...

 ****************************************** Python 3.6   and MySQL Server 5.1  Connectivity ******************************************* STEP 1 :  First let us find the directory where Python is installed. ****************************************************** >>> import sys >>> sys.path ['', 'C:\\Users\\Hari\\AppData\\Local\\Programs\\Python\\Python36-32\\Lib\\idlelib',  'C:\\Users\\Hari\\AppData\\Local\\Programs\\Python\\Python36-32\\python38.zip',  'C:\\Users\\Hari\\AppData\\Local\\Programs\\Python\\Python36-32\\DLLs',  'C:\\Users\\Hari\\AppData\\Local\\Programs\\Python\\Python36-32\\lib',  'C:\\Users\\Hari\\AppData\\Local\\Programs\\Python\\Python36-32',  'C:\\Users\\Hari\\AppData\\Local\\Programs\\Python\\Python36-32\\lib\\site-packages'] >>>  The output shows that Python Interpreter is installed in the folder located at path (location) : C:\\Users\\Hari\\AppData\\Local\\Programs\\Python\\Python36-32...

  STEP 1 : CREATE OR USE AN EXISTING DATABASE    CREATE DATABASE NAMEOFDATABASE; STEP 2 : GET THE LIST OF ALREADY AVAILABLE DATABASES:    SHOW DATABASES; STEP 3 : USE A DATABASE OF YOUR CHOICE IN WHICH YOU WANT TO WORK    USE NAMEOFDATABASE; STEP 4: CREATE A TABLE     CREATE TABLE EMPLOYEE     ( EMPNO INT(6) PRIMARY KEY ,        ENAME VARCHAR(20) NOT NULL,       JOB VARCHAR(20) ,        HIREDATE DATE,        SAL FLOAT ,        DOB DATE ,        DEPTNO INT(5)); STEP 5 : INSERT RECORDS INTO TABLE INSERT INTO EMPLOYEE VALUE(1234, 'PREM' , 'CLERK' ,'1977-02-11' , 12000, '1950-12-31' , 20);  INSERT INTO EMPLOYEE VALUE(6574, 'GITA','SALESMAN', '1999-06-11',17000,'1961-06-11',30); ## SORT CUT WAY- INSERTING MULTIPLE RECORDS IN A SINGLE COMMAND ## INSERT INTO EMPLOYEE VALUES (6754, 'SITA' , 'MANAGER', '1999-03-12' ,39...

  SYLLABUS OF XII COMPUTER SCIENCE 2022-23 CBSE CS IP SYLLABUS 2022-23 LINK Unit I: Computational Thinking and Programming – 2  Revision of Python topics covered in Class XI.  Functions: types of function (built-in functions, functions defined in module, user defined functions), creating user defined function, arguments and parameters, default parameters, positional parameters, function returning value(s), flow of execution, scope of a variable (global scope, local scope)  Introduction to files, types of files (Text file, Binary file, CSV file), relative and absolute paths  Text file: opening a text file, text file open modes (r, r+, w, w+, a, a+), closing a text file, opening a file using with clause, writing/appending data to a text file using write() and writelines(), reading from a text file using read(), readline() and readlines(), seek and tell methods, manipulation of data in a text file  Binary file: basic operations on a binary file: open using file open modes (rb, rb...