Rajasthan Board Informatics Practices Syllabus for Class 12


Rajasthan Board Syllabus for Class 12 Informatics Practices

Unit-1 Business computing

 

Introduction to Open Source based software:

Terminology: OSS, FLOSS, FNU, FSF, OSI ,W3C

Definitions: Open Source Software, Freeware, Shareware, Proprietary software,

localisation, UNICODE

Software : Linux, Mizilla web browser, apache server, MySQL, Postgres, Pango,

OpenOffice, Tomcat, PHP, Python

Websites : www.sourceforge.net, ww.openrdf.org, www.opensource.org, www.linux.com,

www.linux india.net, ww.gnu.org.

General concepts, User intefaces (front end), Underlying Database (Back End), Integration

of User Interface and Database;

More application areas of Databases:

Inventory control, Financial Accounting, Pay-Accounting System, Invoicing Management

System, Personal Management System/Hrd System, fees management , result analysis

system, admission management system, income tax management system;

Advanced Program Development Methodology: System Development Life Cycle,

Relational database Concept, Relational Database, Management System, Data Models

(Entity Relationship Model), Entity End Entity set, Attributes (Single, Composite and Multi-

Valued), Relationship (One-to-One, One-to-Many and Many-to-Many) Entity Relationship

Modeling Conventions, Communication with and RDBMS using SQL, relational database

management system, SQL statements, about programming language in SQL

 

Data Dictionary , Data Warehousing, Data Mining, Meta Data;

Object Modeling: Introduction to object oriented modeling using Unified Modeling

Language (Concepts only).

Client Server Computing : Concept of Client Server Computing

 

Unit-2 Programming : visual Basic

 

Programming Fundamentals

Modules : Modules in Visual Basic - Form Modules, Standard Modules, and Class Modules;

Procedures : Procedures (General, Event, Function, Property):

Control structures:

Revision of Decision Structure - IF, IF-THEN-ELSE, select case:

Revision of Looping Structure - Do While ..... Loop. Do.... Loop While, For .... Next,

For Each... Next:

Functions: Concept of Functions, Defining and Use of User Defined functions, function to

perform calculations, parameterized Functions;

Library Function (System Functions)

String function : Space ( ), Str( ) Right( ). Left( ), Mid( ), Instr ( ), Len( ), Ltrim( ), Rtrim

( ), Ucase( ), Lcase ( ), String( ),

Numeric function : Sgn ( ), Val( ), Int( );

Time-Related Function: Now ( ), Time( ), Minute( ), Month( );

Miscellaneous Function : MsgBox( ), InputBox( );

Types of forms: Single Document Interface (SDI) and Multiple Document Interface (MDI);

MDI Applications : Creating MDI form and Child form, Arranging Child Forms;

Accessing database from ORACLE using ODBC or ADO or OLEDB to connect with database.

Data Control : Accessing Data with the Data Control, Using Data - Aware Controls,

Using Data Control Properties- Database Name, Exclusive, Options, Read Only, Record

Source, Data

Control Methods - Refresh, Update Controls, Update Record ; Bound Controls: Adding

Bound Text and Bound Label Controls. Data - Bound list Boxes, Grids and Sub-Forms

ADO (ActiveX Data Objects): Connection Object, Command Object, and Recordset Object,

Special ADO Properties - Connection String (using single table), Command Text,

Command Types, Cursor Locations, Cursor Types, Lock Types, Mode Types,

ADO Data Control : Simple Data linking using ADO Data Control Methods, ADO Data

Control Events.

 

Unit 3: RELATIONAL DATABASE MANAGEMENT SYSTEM

 

Database Fundamentals

Concept of Database Transaction, Committing a Transaction, Concept of “All or None “

in a Transaction, Network Protocols Required (TCP/IP) for Data Communications, Stored

Procedures, Concepts of Database Frangmentation and Distributed Database.

PL/SQL (Programming Language in SQL)

 

Importance of Writing Procedures, Declaring Variables:, About PL/SQL Block Structure,

Program Consturcts, Use of Variable, Handling Variables in Pl.SQL, Types of Variables,

Declaration, Naming Rules, Assigning Values to Variable, Initialization, and Keywords,

Scalar Data Types, Base Scalar Data Types, Scalar Variable Declaration, % TYPE attribute:

for variable declaration, Declaring Boolean Variables, PL/SQL Record Structure,

Referencing Non- PL/SQL variables, DBMS_ OUTPUT._LINE;

Writing Executable Statements: PL/SQL Block Syntax and Guidelines, SQL functions in

Code, SQL functions in PL/SQL, PL/SQL functions, Data type Conversion, Nested Blocks

and variable Scope, Operators in PL/SQL, Using Bind Variable, Programming Guidelines,

Determining Variable Scope, SQL, Inserting Data, Uptating Data, Deleting Data, Naming

Conventions, Commit and Rollback Statement, SQL Cursor, and Cursor Attributes;

Writing Control Structure: Controlling PL/SQL Flow of Executio, If Statement, IFTHENELSE

Statement Executionb Flow, IF-THEN-ELSIF Statement Execution Flow,

Building Logical Conditions, Logic Tables, Boolean Conditions, Iterative Control: Loop

Statement, Basic Loop, FOR Loop, While Loop;

Creating Procedures: Overview of Procedures, Syntax for Creating Procedures,

Developing Stored Procedures and its Advantages, Creating a Stored Procedure Parameter

Modes, Creating Procedures with Parameters, IN and OUT parameters and Usage,

DEFAULT option for Parameters, Removing Stored Procedures;

Writing Cursors: Introduction to Cursors (Implicit and Explicit), Explicit Cursor Functions,

Controlling Explicit Cursors, Declaring, Opening and Closing the Cursors, Fetching data

from the Cursor, Explicit Cursor Attributes (% ISOPEN, % NOTFOUND, %

ROWCOUNT), controlling multiple fetches, Cursors and Records, Cursors FOR Loops,

Cursor FOR Loops using Sub Queries

 

Triggers: Types of Triggers: Row-Level Triggers, Statement Level Triggers. BEFORE and

AFTER Triggers, INSTEAD of Triggers, Valid Trigger Type, Trigger Syntax, Combining

Trigger Types, Enabling and Disabling Trigger, Replacing Trigger, Dropping a Trigger.

Development of Data Base Applications (Application Domain): Student database for school,

Employee database for a company, Library Database for Library Student database

management system for school, Employee database management system for a company,

Library Database management system for library, Railway Reservation system, Hotel

Reservation, Inventory Control System.

 

Practical-

 

Duration: 3 Hours

Total Marks : 30

 

1. Hands on experience

 

A Problem should be given covering the following features

(i) Start a Standard Exe Project and it should contain MDI form with Menu Bar and

Tool Bar (with Images)

(ii) Table structure in the database for the application with Constraints (Primary Key

Foreign Key, Check, and Unique).

(iii) A New Form to place an ADO component on it, for accessing data in table

Stored Procedure to perform transactions/ conditional update

(iv) Trigger (any)

(v) Making executable files of the project

 

2. Recods

 

(i) Create an Application using Visual Basic for Students Information System Having

a Student Table in Relational Database and a Student Data Form in Visual Basic

to enter data into the database.

(ii) Create an Application using Visual Basic for Criminals Information System

Having a Criminal Table in Relational Database and a Criminals Data Entry From

in Visual Basic to enter data into the database. The Data entry form should contain

form level an Field level checks using procedures.

(iii) Create an Application using Visual Basic for Nursing Home Automation System

having Linked tables (for example; Patent, Employee, Bill) in Relational Database

and a required Data Entry Forms in Visual Basic to enter Data into the database.

The Data entry form should contain form level and Field level checks using procedures.

Use of Bound controls and Sub-Forms are to be encouraged in this application.

(iv) Create a database handling application for Student Expert System. Following

Features are to be incorporated in the application.

 

a. Create following linked tables of Student in the Relational Database.

 

I. Student Master :containing general information about the student.

II. Student Detail : Table to store data having details such as Class. Section,

Marks and other relevant information.

III. Student Fee Detail: Should contain details like Financial Year, Class Fee, Fee

Status (Such as Paid an Un Paid)

IV. Account: General Accounts table to store fee collection details such as received

from, date, chequeno and other relevant information

 

b. The database should have Procedures to update data, Insert data and to perform other

database transactions.

c. Database triggers should also be defined wherever automatic data modification is required.

d. Visual basic forms for data entry.

e. Procedures in Visual Basic to perform Database Transactions and Commit changes made.

f. Reporting tool to make the MIS reports, required to analyze data entry

 

3 Project

 

The Following type of Case study can be adopted for the development of a project

A book publishing company B R Publishing Group is in existence since 1950. They were

untouched with latest technological inventions. They are still a traditional approach of

bookkeeping and accounts maintenance.

 

 

A company, Nova technology, introduced themselves as system integrator and

developers who can change existing working system into the latest concept of paper less office,

They wanted few details from the company about its working, The details are as under.

Name of the company is B R Publishing Group.

The company is having 20 employees. One Managing Director, Two Managers

(Work Manager and Marketing Manager) and 17 employees who work as a

team for book publishing.

The company Publishes books in different Indian languages and different topics.

Every book involves an Author and its detail.

The book is sold in the market at a variable discount options

Book Seller: 30%

Schools: 20% • Customer: 15%

The company is maintaining information about Author and all its details such as

Personal Information, Royalty etc.

The company manages information about the book such as Book Name, Author,

Quantity Sold, Quantity in Stock, etc.

The company maintains Customer (Book Sellers) information. Books Sold, Subject,

Language, and Amount Pending etc.

Reports are required at different levels, such as

Customer Listing • Book Listing

Language Wise Book Listing • Topic Wise Book Listing

Pending Amount Listing ( Customer Wise, Book Wise)

Author Royalty Detail • Bill Generation etc.

 

 

As a developer you are required to design the project and develop it as per

customer needs ( Developer can also visit a publishing company to collect customer details

and live data). Suitable assumptions can be made during implementation. A Proper normalized

database is to be maintained in the RDBMS and the front end is to be developed using

advanced interface controls user-friendly interface is to be generated.

 

Note: A. The above is a sample case study. Similar type of case can be developed

on different application areas such as Library, Hospital, Transport Authority,

Transporters, Wholesale Merchants, and Chemist Shops etc.

 

B. The case to be developed should preferably be obtained from live

situations.

 

4 Viva Voce

Five questions from topics covered in the syllabus

 

Prescribed Book:

 

Informatics Practices- Published by the Board of Secondary Education, Rajasthan, Ajmer

 

Rajasthan Board Best Sellers

In order to keep pace with technological advancement and to cope up with Rajasthan Board examinations, Pearson group has launched Edurite to help students by offering Books and CDs of different courses online.