Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 59 - 2611_SmartGPT Pro V(5.0) C-8
P. 59

    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).

                     Microsoft Access, Oracle, MySQL, etc. are some of commonly used RDBMS.

                                                                                                             PURE
                         The Relational Model was proposed in 1970 by E.F. Codd of IBM.                      FACT

                                                                                              MySQL: My First Database  57

| 54 55 56 57 58 59 60 61 62 63 64 |