Database

Introduction

We use computers for varied applications. The applications could also be scientific or processing. Application like payroll examination process, banking, railway price ticket reservation system, airlines reservation system, budget preparation. during this chapter, we'll study concerning processing generally and concerning operating with a particular information package, namely, 'Star workplace Base'.

Data and Information

Data

The term knowledge comes from the planet data point, which suggests a truth. the info is as truth concerning folks, places or some entities. In computers, knowledge is solely the worth assigned to a variable. The term variable refers to the name of a memory, location that may contain only 1 knowledge at any purpose of your time. as an example, contemplate the subsequent statements.

Steven Smith is sixteen years previous.

Steven Smith is within the twelfth Std.

Steven Smith got eightieth marks in arithmetic.

Let 'name', 'age', 'class', 'mark' and 'subject' be some outlined variables. Now, allow us to assign a price to every of those variables from the on top of statements.

Name = Steven Smith

Class = Twelve

Age = Sixteen

Marks = Eighty

Subject = Arithmetic.

In the on top of example the values assigned to the 5 totally different variables ar referred to as knowledge.

consider another example offer below:

Texas is five hundred kilometres off from urban center

Texas is 1500 feet on top of water level.

These are 2 facts a couple of place referred to as Texas. during this example name of the town, i.e. ' Texas', the gap in click, '500', the name of another place "Dallas" and therefore the height of the town in feet. i.e '1500' are knowledge for the variables 'city', 'distance', 'place' and 'height' severally.

The data are often of various sorts. the info sorts are often Character, Number, or Boolean. The numeric knowledge sort are often whole number, float, double, precision, date, time, etc. The programming languages and packages offer their own intrinsic (system defined) primitive knowledge sorts like whole number and float. except for several applications, like 'supplier numbers', 'part names', 'city names', 'colors' etc., The system outlined primitive knowledge sorts alone aren't adequate. For such functions, information Systems offer a facility by that user will outline their own additional refined knowledge sorts as referred on top of, that are referred to as user-defined knowledge sorts.

Information

We will currently see what's info with regard to computers. info is outlined as a collection of processed knowledge that convey the

relationship between knowledge thought of. process suggests that to try to to some operations or computations on {the knowledge|the info|the information} of various variables to relate them so these data, once connected, convey some that means. Thus, info is as cluster of connected knowledge transfer some that means. within the example on top of, once the info of the variables 'name' and 'age' are connected, we have a tendency to get the subsequent info.

Steven Smith is sixteen years previous.

In the same example, once {the data|the info|the info} of the variables 'name' and 'class' are connected we have a tendency to get another information as

Steven Smith is within the twelfth Std.

Further, once we relate the info of the variables. 'name', 'marks', and 'subject', we have a tendency to get additional info that 'Steven Smith' got eightieth marks in arithmetic. Similarly, once the info 'Texas', 'Dallas' and '500' are connected, it offers info that Texas is five hundred kilometres off from urban center.