Class 12 Computer Science Solution Volume 2 | HS 2nd Year Computer Science Book Solution Assam | Class 12 Computer Science Answer Assamese Medium | C++Concepts | File Handling | Data Structures | Sumita Arora | Textbook XII 11th Edition | HS 2nd Year Computer Science Suggestion and Notes Assam |

----------------------------------------------------

Class 12 Computer Science with  Solution Volume 2 

Class XII Computer Science with Question and Answer 

Class 12 Computer Science writer Sumita Arora

-----------------------------------------------------

CONTENT



-----------------------------------------------------------------------------

 
---------------------------------------
11.1 Introduction
---------------------------------------
---------------------------------------
11.2 Purpose of Databases
---------------------------------------
---------------------------------------
11.3 Database Abstraction
    11.3.1 Various Levels of Database Implementation
    11.3.2 Concept of Data Independence
---------------------------------------
---------------------------------------
11.4 Different Data Models
    11.4.1 The Relational Data Model
    11.4.2 The Network Data Model
    11.4.3 The Hierarchical Data Model
---------------------------------------
---------------------------------------
11.5 The Relational Model
    11.5.1 Terminology 
    11.5.2 Views
    11.5.3 Structure of Relational Databases
    11.5.4 The Relational Algebra
---------------------------------------
---------------------------------------
11.6 Comparison of Data Models 
---------------------------------------
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
 
---------------------------------------
12.1 Introduction
---------------------------------------
---------------------------------------
12.2 Processing Capabilities of SQL
---------------------------------------
---------------------------------------
12.3 Data Definition Language
---------------------------------------
---------------------------------------
12.4 Data Manipulation Language
---------------------------------------
---------------------------------------
12.5 SQL Processing 
    12.5.1 Concept of Data Types 
    12.5.2 Various SQL Commands and Functions
    12.5.3 Some Built - In Functions 
    12.5.4 Joins 
    12.5.5 Union 
    12.5.6 Some more DDL Commands
---------------------------------------
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
 
---------------------------------------
13.1 Development of Boolean Algebra
---------------------------------------
---------------------------------------
13.2 Binary Valued Quantities
---------------------------------------
---------------------------------------
13.3 Logical Operations
     13.3.1 Logical Function or Compound Statement
     13.3.2 Logical Operators
     13.3.3 Evaluation of Boolean Expressions using Truth Table
---------------------------------------
---------------------------------------
13.4 Basic Logic Gates
    13.4.1 Inverter (Not Gate)
    13.4.2 OR Gate
    13.4.3 AND gate
---------------------------------------
---------------------------------------
13.5 Basic Logic Gates    
---------------------------------------
---------------------------------------
13.6 Principle of Duality
---------------------------------------
---------------------------------------
13.7 Basic Theorems of Boolean Algebra
    13.7.1 Properties of 0 and 1
    13.7.2 Indempotence Law
    13.7.3 Involution
    13.7.4 Complementanty Law
    13.7.5 Commutative Law 
    13.7.6 Associative Law
    13.7.7 Distributive Law
    13.7.8 Absorption Law
    13.7.9 Some other Rules of Boolean Algebra 
---------------------------------------
---------------------------------------
13.8 demorgan's Theorems
    13.8.1 DeMorgan's First Theorem
    13.8.2 DeMorgan's Second Theorem
---------------------------------------
---------------------------------------
13.9 Derivation of Boolean Expression 
   13.9.1 Minterms
   13.9.2 Maxterms
   13.9.3 Canonical Expression
---------------------------------------
---------------------------------------
13.10 Minimization of Boolean Expression
     13.10.1 Algebraic Method
     13.10.2 Simplification using Karnaugh Maps
     13.10.3 Sum - of - Products Reduction using Kamaugh Map
     13.10.3 Sum - of - Products Reduction using Kamaugh Map
     13.10.4 Product - of - Sum Reduction using Karnaugh Map
---------------------------------------
---------------------------------------
13.11 More About Logic Gates
     13.11.1 NOR Gate
     13.11.2 NAND Gate
     13.11.3 XOR Gate ( Exclusive OR Gate )
     13.11.4 XNOR Gate ( Exclusive NOR Gate ) 
     13.11.5 NAND to NAND and NOR to NOR Design
---------------------------------------
---------------------------------------
13.12 Use of Boolean Operators in Search Engine Queries
---------------------------------------
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
 
---------------------------------------
14.1 Introduction
---------------------------------------
---------------------------------------
 14.2 What is a Network ?
---------------------------------------
---------------------------------------
14.3 Need for Networking 
    14.3.1 Network Goals
    14.3.2 Application of Networks
---------------------------------------
---------------------------------------
14.4 Evolution of Networking
    14.4.1 ARPANET 
    14.4.2 The Internet 
    14.4.3 The Interspace 
    14.4.4 Elementary Terminology of Networks 
---------------------------------------
---------------------------------------
14.5 Switching Techniques 
    14.5.1 Circuit Switching 
    14.5.2 Message Switching 
    14.5.3 Packet Switching 
---------------------------------------
---------------------------------------
14.6 Data Communication Terminologies 
---------------------------------------
---------------------------------------
14.7 Transmission Media
    14.7.1 Twisted Pair Cable 
    14.7.2 Coaxial Cable 
    14.7.3 Optical Fibers 
    14.7.4 Guided Media Compared 
    14.7.5 Micro Wave ( Terrestrial Microwave ) 
    14.7.6 Radio Wave 
    14.7.7 Satellite ( Sattelite Microwave ) 
    14.7.8 Other Unguided Media 
---------------------------------------
---------------------------------------
14.8 Types of Networks
    14.8.1 Local Area Network ( LAN )
    14.8.2 Metropolitan Area Network ( MAN ) 
    14.8.3 Wide Area Networks ( WAN ) 
    14.8.4 Personal Area Network ( PAN ) 
    14.8.5 Comparing these Networks 
---------------------------------------
---------------------------------------
14.9 Network Topologies
    14.9.1 Point - to - Point Link 
    14.9.2 The Star Topology 
    14.9.3 The Bus or Linear Topology 
    14.9.4 The Ring or Circular Topology 
    14.9.5 The Tree Topology 
    14.9.6 Graph Topology 
    14.9.7 Mesh Topology 
    14.9.8 Fully Connected 
    14.9.9 Factors to consider for Topology Selection 
---------------------------------------
---------------------------------------
14.10 Network Devices
    14.10.1 Modem 
    14.10.2 RJ - 45 
    14.10.3 Ethernet Card 
    14.10.4 Hub 
    14.10.5 Switch 
    14.10.6 Repeater
    14.10.7 Bridge 
    14.10.8 Router
    14.10.9 Gateway 
    14.10.10 WiFi Card 
---------------------------------------
---------------------------------------
 14.11 LAN Design 
      14.11.1 Network Components Checklists
---------------------------------------
---------------------------------------
14.12 Communication Protocols 
      14.12.1 HTTP ( Hypertext Transfer Protocol ) 
      14.12.2 FTP ( File Transfer Protocol )
      14.12.3 TCP / IP ( Transmission Control Protocol / Internet Protocol ) 
      14.12.4 SLIP / PPP 
---------------------------------------
---------------------------------------
14.13 Wireless / Mobile Computing
     14.13.1 Wireless vs. Mobile Computing 
     14.13.2 Wireless / Mobile Computing Technologies 
---------------------------------------
---------------------------------------
14.14 Internetworking Terms and Concepts 
     14.14.1 WWW ( World Wide Web ) 
     14.14.2 Telnet 
     14.14.3 Web Browser and Web Server 
     14.14.4 Web Sites , Web Addresses and Web Pages 
     14.14.5 URL and Domain Names 
     14.14.6 Web Hosting 
     14.14.7 Web 2.0 
     14.14.8 HTML 
     14.14.9 XML ( extensible Markup Language ) 
     14.14.10 DHTML ( Dynamic HTML ) 
     14.14.11 Web Scripting 
---------------------------------------
---------------------------------------
14.15 Network Security
     14.15.1 Related Terms 
     14.15.2 IPR Issues 
---------------------------------------
---------------------------------------
14.16 Viruses 
    14.16.1 How Computer Viruses Spread ? 
    14.16.2 Damage that Viruses Cause 
    14.16.3 Trojan Horses 
    14.16.4 Worms 
    14.16.5 Spam 
    14.16.6 Virus Prevention 
---------------------------------------
---------------------------------------
14.17 Payment Transactions using Online Banking
     14.17.1 Mobile Banking 
     14.17.2 e - Wallet
---------------------------------------
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
 
 ---------------------------------------
Appendix D : Joins in SQL 
 Appendix E : Cloud Computing
---------------------------------------
-----------------------------------------------------------------------------