Basic HTML Version

|  | Table of Contents |  | View Full Version

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

| 27 28 29 30 31 32 33 34 35 36 37 |