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
---------------------------------------
-----------------------------------------------------------------------------
0 Comments