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 2020-2021

Preview

Length: 0 minutes

Class 12 Computer Science Practical File 2020-2021 Class 12 Computer Science Project File 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’)) r = float(input(‘Enter rate’)) t = float(input(‘Enter time’)) i=p*r*t/100 print(“Interest=”,i) 3. Program to check …

Class 12 Computer Science Project File | Student Data Management in Python

Preview

Length: 0 minutes

Class 12 Computer Science Project File 2021-2022 Student Data Management in Python Download Documentation Download Project Code [Rename file with .py extension] Other Links Library Data Management Project Hotel Management Project 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)     …

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

Preview

Length: 0 minutes

Class 12 Computer Science Project File 2022 Library Data Management in Python Download Documentation  Download Project Code [Rename file with .py extension]  Other Projects: Student Data Management Project Hotel Management Project Class 12 Computer Science Practical File import os import csv def newBook(): 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 …

Project File Class 12 Computer Science | Hotel Management in Python

Preview

Length: 0 minutes

Class 12 Computer Science Project File 2022 Library Data Management in Python Download Hotel Management System Documentation Download Project Code [Rename file with .py extension]  Other Projects: Student Data Management Project Library Data Management Project Class 12 Computer Science Practical File import os import csv def newrecord(): print(“Add a New Customer Record”) print(“================”) f=open(‘hotel.csv’,’a’,newline=’\r\n’) s=csv.writer(f) …

Project File Class 12 Computer Science | Hospital Management in Python

Preview

Length: 0 minutes

Class 12 Computer Science Project File 2022 Hospital Data Management in Python Download Hospital Management System Documentation Download Project code of Hospital Management System [ Rename file with .py extension] Other Projects: Student Data Management Project Library Data Management Project Class 12 Computer Science Practical File import os import csv def newpatient(): print(“Add a New …

class 12 computer science practical paper with solution

Preview

Length: 0 minutes

class 12 computer science practical paper with solution 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 to …

Class 12 computer science sample paper term 2 solutions

Preview

Length: 0 minutes

Sample Question Paper COMPUTER SCIENCE (Code: 083) Download Sample paper in MS Word Format Download Sample paper in PDF Format Maximum Marks: 35                                                                            Time: 2 hours General Instructions The question paper is divided into 3 sections – A, B and C Section A, consists of 7 questions (1-7). Each question carries 2 Section B, consists …