CBSE Class 12 Informatic Practices Web Applications
WEB APPLICATIONS Introduction History of World Wide Web Internet is such a wonder box that whenever we need some information on any topic, we refer to internet. Information is available on almost all the topics - from Ayurveda to Advaced Medical Surgeries, from basic colors to…
CBSE Class 12 Informatic Practices RDBMS Concepts
Introduction DBMS and Transaction Management Raunak studies in Class XII. He is very helpful. During summer vacations, he helped his aunt's son in his studies. His aunt was very pleased with him and gave him a cheque of ` 2000.00. Raunak knows that after presentation of the…
CBSE Class 12 Informatic Practices Open Source
Open Source Concept Introduction After learning this chapter the student will be able to: Understand about OSS/FOSS/FLOSS Cite different examples of OSS Describe open document format Understand character encoding in Indian languages Know about open type/true type/static/…
CBSE Class 12 Informatic Practices Object Oriented
James Alexander is a resident of a developed nation and works as a freelance consultant. He is hired by one of the corporate houses of a developing nation to plan a strategy to improve production in one of their factories which is located in a remote village named Khabri. The…
CBSE Class 12 Informatic Practices MySQL
Database Concepts After studying this lesson the students will be able to: Recall the terminology used in RDBMS concepts. Recall and effectively use the SQL commands and clauses learnt in class XI. Realize that much more is to be learnt for effective use of databases…
CBSE Class 12 Informatic Practices IT Applications
IT APPLICATION In class 11, you have already learnt about broad categories of IT application as e-Gaming, e-Business, e-Governance, e-Learning etc. e-Business involves applications dealing with buying and selling of products and services. e-Governance involves applications…
CBSE Class 12 Informatic Practices GUI Programming
GUI PROGRAMMING - A REVIEW Learning Objectives After studying this lesson the students will be able to: Identify, name and state the usage of the different components of the NetBeans IDE. Identify and name the various methods and properties associated with the various…
CBSE Class 12 Informatic Practices Databases and SQL
MORE ON DATABASES AND SQL Learning Objectives After studying this lesson the students will be able to: Define the terms: (i) Group (Aggregate) functions, Constraints (ii) Cartesian Product, Join, Referential Integrity, Foreign Key. Write queries using aggregate…
CBSE Class 12 Informatic Practices Database Connectivity
Imagine a swanky air-conditioned car showroom in prime location of the city with all modern car accessories available in an outlet within the showroom. The showroom has a DATABASE CONNECTIVITY wonderful ambience, employs skilled salesperson with excellent communication skills…
CBSE Class 12 Informatic Practices Computer Networking
After learning this chapter the students will be able to: Define what a Computer Network is List the benefits of networking List different wired and wireless media for communication Identify different network devices Identify the type of network on the basis of…
CBSE Class 12 Informatic Practices Advanced Programming
Learning Objectives After studying this lesson the students will be able to: Define objects and their usage Appreciate the usage of native classes Math and String Understand the need and use of methods pow() and round() of Math class Understand the need and use of…
CBSE Class 12 Informatics Practices Transactions Procedures and Functions
Chapter – 4 Transactions, Procedures and Functions (Informatics Practices) A transaction is a sequence of SQL statements to accomplish a single task. Example: Transfer funds between bank accounts. -- assume source_acct, dest_acct, amount, -- and source_balance are defined…
CBSE Class 12 Informatics Practices Tables And Exception Propagation
Chapter – 3 Tables And Exception Propagation (Informatics Practices) PL/SQl TABLEs combine characteristics of SQL tables and C/Pascal arrays. Like SQL tables: consist of records (must have a numeric primary key) can grow/shrink as elements are added/removed Exceptions An…
CBSE Class 12 Informatics Practices PL SQL
Chapter – 1 PL/SQL (Informatics Practices) PL/SQL = Procedural Language extensions to SQL An Oracle-specific language combining features of: modern, block-structured programming language database interaction via SQL Designed to overcome declarative SQL's inability to specify…