Information technology nsqf level 2 class 10 pdf download

You can find the following topics in the book Downloading the book is very easy. You can download this book from the official website of the CBSE board.

The CBSE has uploaded this book for class 9th and 10th students. The book in pdf format is available free of cost. You do not need to pay any amount for this book. You can download the book on your mobile or on your laptop etc. You can take a printout of the book if you wish or you can read the book on your device also. Unit 2- Electronic Spreadsheet. Unit 4- Web Applications And Security.

Practical work will be given before the final examination of the class 10th board. There will be an examination of practical that means you have to perform some activities on the computer.

So, in the practical examination, there will be a written test on the computer and also there will be an Oral test taken by the teacher.

Here a project file is to be made with a given topic. Also, some oral questions will be asked by your teachers about your project. Those questions will be related to your project and that will be very simple. Tags: information technology code class 10 book solutions information technology code sample papers class 10 with solutions information technology code syllabus class Facebook Twitter.

Unknown November 13, at PM. In the era of globalized competition information technology plays a crucial role. Information technology has made significant changes in every field and enabled students to develop new learning and skills. In general, files of any format can be stored using the binary data type. The different types of binary data types available are listed here.

No validation required. Stores any array of bytes. Date time: Date time data types are used for describing date and time values for the field used in the table of a database. Date time data types in a database can be using for storing information such as date of birth, date of admission, date of product sale, etc. The different types of date time data types available are listed here. An address book uses only one table. But look at a different situation. If you are a dealer selling a single type of item and want to record details of your sales in the past month and also want the details of the client who purchased the item name, address, phone, date purchased, number of items bought etc , what would you do?.

Every time you sell an item to Sheela or Vaibhav or any other customer client you need to store the details again. So, what is the solution? Create one table for client details and another for sale details. Since each record has to be unique, you can insert a ClientID field to uniquely identify each client in the client table.

Since we cannot have an order without a customer, we call Client the parent and Sales the child table. Related tables like these share a common field. You store data about people once, but refer to those people many times in the database.

This unique field is called the primary key PK. A primary key is a unique value that identifies a row in a table. In our example, ClientID is the primary key in the Client table. Primary Keys are also indexed in the database, making it faster for the database to search for a record. Hence, the foreign key identifies a column or set of columns in one referencing table that refers to a column or set of columns in another referenced table.

Memorize it: one, parent, PK; many, child, FK. They can only see what you permit them to and can select only from the options you give them. Create a database for a stationery shop. Hint : Create fields for items, price, color, vendor, etc. State the relationship and difference between a primary and foreign key? List datatypes available in Numeric Datatype. List datatypes available in Alphaumeric Datatype. List datatypes available in Data Datatype. Fill in the blanks: 1. There are two types of languages for this task.

DDL statements create, modify, and remove database objects such as tables, indexes, and users. The goal is to provide efficient human interaction with the system.

The terms DML and query language are often used synonymously. This is used to retrieve and manipulate data in a relational database. Data manipulation language comprises the SQL data change statements, which modify stored data but not the schema or database objects.

This is easier for the user but may not generate code as efficient as that produced by procedural languages. Alternatively, you can also double-click on the OpenOffice. You should see a Window similar to the one displayed below Select the option database to launch the base application. You should are guided through the Database Wizard for creating a database. You will see a dialog box similar to the one displayed below. You can also open an existing database file that you have already created by selecting the option Open an existing database file.

Click Next. A dialog box similar to the one displayed below appears. Click Finish. The Save As dialog box appears as shown below. A window similar to the one displayed below. Now that you have created a database, you can work with the database as outlined in the next few sessions. What is the file extension for databases created using OpenOffice. Org Base? Ayan Bhardwaj on A letter of condolence to your friend on the death of his mother.

Download Our Educational Android Apps. Hindi Sr. Letter Writing Write an application to the Principal complaining about the behaviour of a Teacher. Write an application to the Principal giving some suggestions for the improvement of the school.