# CS Class 11

## Boolean Logic Class 11 | Class 11 Computer Science Notes

Latest Boolean Logic Class 11 Notes including Boolean Operators, D Morgans Law, Logic Circuits, Logic Gates, Truth Table, AND, OR, NOT, NAND, NOR, XOR, XNOR gates. This Class 11 Computer Science Boolean Logic Notes is designed as very concisely to help students to secure highest marks. Boolean algebra Boolean Algebra was introduced by George Boole […]

## Computer System And Organization Class 11 Notes | Computer Science

Computer System And Organization Class 11 Notes including CPU, Software, Operating System, Hardware, Memory, Cache Memory, Language Translator, System Software topics. Specially designed for the students learning class 11 Computer Science according to syllabus suggested by CBSE to secure high marks with better understanding in less time and effort. What is computer system? A computer

## Class 12 IP SQL Practical Questions | MySQL Worksheet for Class 12

Download Latest and Complete pdf series of CBSE IP Class 12 Practical Program Worksheets with code and output covers all important topics. Practical Worksheets for Class 12 IP are designed to help students develop logical and analytical capabilities, problem solving skills, and improve their subject knowledge. these worksheets are best study materials for students designed

## What are the limitations of file system that can be overcome by a relational DBMS?

The limitation if file systems that can be overcome by a relational DBMS are: Data Redundancy: redundancy means repetition of same data in different tables. Redundancy leads to excess data storage and may cause data inconsistency. Data Inconsistency: When same data is managed differently in different places leads to data inconsistency. Data inconsistency creates unreliable

## Compared a file system, how does a database management system avoid redundancy in data through a database?

By storing data in different tables which are logically related, a database management system avoids redundancy in data through a database.

## Differentiate between Primary key and Foreign key

Primary Key Foreign Key It identifies the each record in a table uniquely. It maintains the relation between two tables. A foreign key is primary key in another related table. A table can have only one Primary key. A table can have more than one Foreign key. Primary key cannot have NULL values. Foreign key

## Differentiate between Database state and database schema

Database Schema Database State Database Schema represent overall design of the database. Database state represent current state of data in database. Database schema is changed ocassionally Database state is changed frequently Initially when defining a database, only Database schema is specified Initially when defining a database, database state is empty state.

## 1. Give the terms for each of the following:Collection of logically related records.

a) Collection of logically related records.b) DBMS creates a file that contains description about the data stored in the database.c) Attribute that can uniquely identify tuples in a relationd) Special value that is stored when actual data value is unknown for an attribute.e) An attribute which can uniquely identify tuples of the table but is

## Find the output of the following program segments:

(a)for I in range (20,30,2):print(i)(b)country = ‘INDIA’for i in country:print (i)(c)i=0; sum = 0while i < 9 :if i % 4 == 0:sum = sum + ii = i + 2print (sum) Ans: (a) Will display output2022242628        (b) Will display outputINDIA (c) Will display output 12

## What is the difference between else and elif construct of if statement?

To implement conditions in a program we always use if statement. We can use single if statement or multiple if statement as per our situation. When we want to implement multiple if statement than we use if…elif…else statement in python. Here ‘eleif’ is short form of ‘else if’ which is used in other languages. We

error: Content is protected !!