Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 125 - CodePilot V5.0 C8
P. 125

    The need for databases is as follows:                                  Amit Sen          Amit Sen
                                                                                            Richa Tondon      Richa Tondon
                         Reduction of data  redundancy: It  refers to  unnecessary          Deepak Patel      Deepak Patel
                        duplication of data. A centralised database helps avoid this        Nitish Reddy      Nitish Reddy
                                                                                            Anil Gurang       Anil Gurang
                        by storing only one version of the data.                            Amit Sen
                                                                                            Richa Tondon
                                                              Data sharing: It  allows multiple  users  to  access  and
                                                             work on the  same  data  simultaneously,  facilitating

                                                             real-time collaboration.
     In the  past,  databases  were managed  manually on  paper.  This  was  time-consuming  and
     error-prone. As the need for handling more complex data grew, businesses and organisations
                         Data security: It ensures data safety through security systems, user
     shifted  to  Relational  Database  Management  Systems  (RDBMS)  like  MySQL, PostgreSQL  and
                        roles and permissions, allowing only authorised users to access and
     Oracle. These systems offer several advantages over traditional manual methods.
                        modify the data.

     DATA AND INFORMATION
                                                    Data  integrity: Data  integrity  ensures that data  is  accurate,
     Data includes raw facts, figures or symbols that are yet to be processed into meaningful information.   consistent and reliable. Databases use constraints to prevent errors,
     Data can exist in various forms, including numbers, text, images, audio, video or observations.    such as disallowing negative quantities or verifying that a supplier

     Information is  processed  and  organised  data  that  becomes  meaningful  and  useful  for     exists before processing an order.
     decision-making, trend analysis or learning.

                         Data backup: Data backup in databases means making a copy of the
       Roll No.  Computer
     Roll No.  Student Name  106  86  Roll No.  Student Name  Maths Science English Computer   database files so that you can restore your data if it gets lost, damaged
     101   Aarav Sharma  103  78  101  Aarav Sharma  85  90  88  85
     101  85  102  Riya Patel  78  82  80  98  or corrupted. It is a safety measure to protect important information.
     105   Arjun Reddy  105  81  103  Saanvi Iyer  92  88  91  78
       Roll No.   Science  102  98  104  Meera Deshmukh 70  75  72  79
     102   Riya Patel  105  Arjun Reddy  88  84  86  81
     101  90  104  79  106  Kavya Menon  80  85  79  86
     105  84  104   Meera Deshmukh
     102  82
     103   Saanvi Iyer      DATABASE MANAGEMENT SYSTEM (DBMS)
     106  85
     103  88  106   Kavya Menon
                     A Database Management System (DBMS) is a software that allows users to control the creation,
     104  75
     Data  Process  Information
                     maintenance and use of a database. It performs the tasks of maintaining databases so that the
                     information is readily available. It helps to manage the data of different fields like banks, offices,
     INTRODUCTION TO DATABASE  railways, airlines, etc. DBMS allows users to store, manage and organise all the data in a way that
                     makes it easy to find and use whenever they need it.
     A  database is defined as an organised  collection  of data  that  is stored  and accessed
     electronically. With the help of a database, data can be stored, modified and retrieved. It acts as
     a container for information that can be efficiently managed.  RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS)

     NEED FOR A DATABASE  A relational database is a type of database that stores data in the form of tables. These tables are
                     structured with rows and columns and they can be related to each other through common fields
     Data is important today, but without proper systems, it may become inconsistent or get duplicated.
                     (keys) to enable the retrieval of related information. The software package that is used to handle
     A database keeps data organised and centralised making it accessible, secure and consistent.
                     relational databases is known as the Relational Database Management System (RDBMS).

                                                                                                                      123
                                                                                              MySQL: My First Database

| 120 121 122 123 124 125 126 127 128 129 130 |