Page 32 - CT_AI_Class-5
P. 32
UNDERSTANDING DATABASE
Once data has been collected, it needs to be stored
somewhere safe and organised so that it can be
found whenever it is needed. That is exactly what a
database does.
A database is like a large, well-organised digital
cupboard. Instead of paper files and folders, it keeps information in electronic tables.
These tables are organised in rows and columns. Rows are like horizontal lines of
information and columns are vertical lines of information. The big difference is that
a database can hold millions of rows of information and find what you’re looking for
in less than a second.
Think of it like a spreadsheet, a tool that shows data in rows and columns. For
example, imagine your school keeps a record of every student in a simple table. It
might look like this:
Student ID Name Class City Total Marks
001 Aanya Sharma 5A Mumbai 485
002 Rohan Mehta 5B Delhi 472
003 Priya Iyer 5A Chennai 493
004 Kabir Singh 5C Kolkata 461
Rows: Each row holds information about one student. For example, the first row
holds all the details about Aanya Sharma.
Columns: Each column contains one type of information. For instance, the first
column contains student IDs, the second column contains names and so on.
A database works in exactly the same way. The school can use this database to
find all students from a particular city, sort students from highest to lowest marks
or check which students are in Class 5A.
Sorting and Filtering the Data
Two of the most useful things you can do with a database are sorting and filtering.
These actions help you make sense of large amounts of data in a very short time.
Sorting
Sorting means putting data in a particular order. For example, you can sort a list
of names from A to Z or sort a list of marks from highest to lowest. When you sort
data, all the information in each row stays together, so a student’s name, city and
marks all move as one group.
30 Artificial Intelligence (CT & AI)-V
