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 […]
CS Class 11
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
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
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.
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
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.
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
(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
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