CBSE class 12 Computer Science notes

Lessons

COMPUTER NETWORKING NOTES FOR CLASS 12 – II

Preview

Q1. What is Network Topology and its types? Network Topology is the structure to organize and interconnect computers on a network . Different types of network topologies are: i. Bus Topology Bus topology is a network type in which every computer and network device is connected to single cable. Advantages Short cable length. It is …

Database Concepts Class 12 CBSE

1. What is database? Database is a collection of related information. 2. What is Database Management Systems (DBMS)? DBMS is a software to store and maintain data in the form of tables. We can easily create, modify, delete and view data from database. Examples: Ms-Access, MySQL, SQLite, Microsoft SQL Server, Oracle etc. 3. What is …

SQL commands For class XII CBSE

DDL commands of SQL There are three DDL commands of SQL. 1. Create Table This statement is used to create the structure of a table. We can specify the various fields along wih their data types, size and range of values which can be stored in those fields. We can also specify the constraints applied …

SQL based questions with answers

Q1. Write SQL queries on the basis of following table. Relation :  Student Name Class Fee Gender DOB Rahul XII 1200 M 2005-02-01 Mehul XII 1200 M 2004-12-11 Manisha XI 1050 F 2006-10-12 Sujoy XI 1050 M NULL Sonakshi XII 1200 F 2005-09-19 Suman X 950 F 2008-06-16 i. Display all records from table student. …

Output based SQL queries with answers

Q1. Write output of the SQL queries on the basis of following table. Relation :  Student Name Class Fee Gender DOB Rahul XII 1200 M 2005-02-01 Mehul XII 1200 M 2004-12-11 Manisha XI 1050 F 2006-10-12 Sujoy XI 1050 M NULL Sonakshi X 1200 F 2005-09-19 i. Select * from student; Rahul XII 1200 M …

Class 12 Computer Science Practical File 2022 – 2023

Preview

Length: 0 minutes

Class 12 Computer Science Practical File 2022-2023 Class 12 Computer Science Project File – Student Data management Class 12 Computer Science Project File – Library Data management Python Programs 1. Program to add two numbers. x = int(input(‘Enter integer value:’)) print(‘Value entered:’, x) print(‘Type:’, type(x)) 2. Program to find simple interest. p = float(input(‘Enter principle’)) …

Class 12 Computer Science Project File 2023 | Student Data management Python Project

Preview

Length: 0 minutes

Class 12 Computer Science Project File 2023 | Student Data management class 12 Project   Download Documentation Download Project Code [Copy code to python file] Class 12 Computer Science Practical File import os import csv def addrecord():     print(“Add a new Record”)     print(“================”)     f=open(‘students.csv’,’a’)     s=csv.writer(f)     rollno=int(input(‘Enter rollno=’))     name=input(‘Enter name=’)     …

Class 12 Computer Science Project File 2023 | Library Data Management in Python

Preview

Length: 0 minutes

Class 12 Computer Science Project File 2023 | Library Data Management in Python   Download Documentation Download Project Code [Copy code to python file] Class 12 Computer Science Practical File import os import csv def addBook(): print(“Add a new Book Record”) print(“=====================”) f=open(‘library.csv’,’a’,newline=’\r\n’) s=csv.writer(f) bookid=int(input(‘Enter book id=’)) bookname=input(‘Enter book name=’) bookauthor=input(‘Enter author name=’) price=float(input(‘Enter price=’)) …

Project File Class 12 Computer Science 2023 | Hotel Management in Python 2023

Preview

Length: 0 minutes

Project File Class 12 Computer Science 2023 | Hotel Management in Python 2023   Download Documentation Download Project Code [Copy code to python file] Class 12 Computer Science Practical File import os import os import csv def newCustomer(): print(“Add a new Customer Record”) print(“=========================”) f=open(‘hotel.csv’,’a’,newline=’\r\n’) s=csv.writer(f) Customerid=input(‘Enter Customer id=’) Customername=input(‘Enter Customer name=’) roomno=input(‘Enter Room No=’) …

Project File Class 12 Computer Science | Hospital Management in Python

Preview

Length: 0 minutes

Project File Class 12 Computer Science | Hospital Management in Python   Download Documentation Download Project Code [Copy code to python file] Class 12 Computer Science Practical File import os import csv def newPatient(): print(“Add a new Patient Record”) print(“=========================”) f=open(‘Patient.csv’,’a’,newline=’\r\n’) s=csv.writer(f) Patientid=input(‘Enter Patient id=’) Patientname=input(‘Enter Patient name=’) Disease=input(‘Enter Disease=’) fee=float(input(‘Enter Fee=’)) Doctorname=input(‘Enter name of …

class 12 computer science practical paper with solution 2023

Preview

Length: 0 minutes

class 12 computer science practical paper with solution 2023 AISSCE Practical Examination 2021 COMPUTER SCIENCE (083) Time : 3 Hours                                                                                      M.M.  30   Q1.  A binary file “student.dat” has structure [Rollno,  Name, Class ].                                    7 a) Write a user defined function Create() to input data for a record and add to Student.dat . b) Write a function Display() in Python …