Page 13 - 2501_KVS_C-8

1.4 TABLE IN A DATABASE

Students, there are various methods of storing data in a database but a table provides
a very good and user-friendly way of representing data in the form of rows and columns.
Therefore, most of the database software use “Table” to store data in a systematic manner.
Let us now understand its meaning.

Table: A table is a structure which is formed after the intersection of multiple rows
and columns. Intersection of a row and a column is called a Cell. Every table has some
fields or columns and some data is stored in these columns. Let us understand the
concept of Table from the given example:

In the above table on Student, there are 4 columns/fields and 5 rows/records of 5 students
and the intersection of these rows and columns form a table with 4 X 5 = 20 boxes having

some kind of data in them.

1.5 DATA TYPE IN A TABLE

Data Type: A data type is used to specify the type of data which may be used in a
column in a table. For example, there may be different types of data which we deal
with, like, integers, decimal values, character values, special characters/symbols, etc.
So, in order to store a particular type of value, we need its data type.

Introduction to Database Concepts 11