Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 68 - 2629_Devagiri_C-8
P. 68

    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.

                          Data security: It ensures data safety through security systems, user
                         roles and permissions, allowing only authorised users to access and

                         modify the data.

                                                     Data  integrity: Data  integrity  ensures that data  is  accurate,
                                                    consistent and reliable. Databases use constraints to prevent errors,
                                                    such as disallowing negative quantities or verifying that a supplier
                                                    exists before processing an order.

                          Data backup: Data backup in databases means making a copy of the
                         database files so that you can restore your data if it gets lost, damaged
                         or corrupted. It is a safety measure to protect important information.

                             DATABASE MANAGEMENT SYSTEM (DBMS)

                      A Database Management System (DBMS) is a software that allows users to control the creation,
                      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,
                      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.

                             RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS)

                      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
                      (keys) to enable the retrieval of related information. The software package that is used to handle
                      relational databases is known as the Relational Database Management System (RDBMS).

                       66
                            Premium Edition-VIII

| 63 64 65 66 67 68 69 70 71 72 73 |