Page 18 - ModularV1.1 _c8_flipbook
P. 18

ADVANTAGES OF A DATABASE SYSTEM

                  A database system has many benefits. Some of the important advantages are:
                      It minimizes the duplication of data by integrating and sharing the data files.
                      It saves the storage space.

                      All the users are provided with some access rights or privileges and permissions.
                      The files can be easily updated whenever any changes are being made.
                      It improves the data integrity as data is stored in a central location.

                      It provides various techniques to recover and backup data.
                      It provides security to important and confidential data.
                      TYPES OF DATABASES

                  There are mainly two types of databases:

                      Flat File Database: It is a type of database that contains records having
                     small number of fields without any structured relationship between them.
                     The most popular example of flat file database is MS Excel 2010.
                      Relational  Database: It is a  type  of database  that  stores data  in several
                                                                                                        Microsoft Office
                     tables and links those tables together to get a common piece of information.
                                                                                                          Excel 2010
                     This  type  of  database  system  is  called  Relational  Database  Management
                     System (RDBMS). Commonly used relational database systems are MS Access, Microsoft SQL

                     Server, ORACLE, etc.









                                                           Relational Databases
                   Clickipedia




                    The relational database was proposed by Edgar F. Codd. He gave a set of thirteen rules
                    (Codd’s rules) to define a Relational Database Management System.

                      STRUCTURE OF A DATABASE

                  Data is stored in the table of a database, as shown in the below diagram.

                                                                FIELDS

                                Reg No. Name                   Father’s Name       Date of Birth       Class
                                187/11     Krishna Kant        Mr. K.S. Kant       15/08/2007             VIII
                           RECORDS  156/12  Rishi Sharma       Mr. N.K. Sharma     22/10/2008              IX


                                                                                                           IX
                                                                                   16/04/2008
                                           Suraj Patel
                                194/11
                                                               Mr. G.S. Patel
                                123/12     Priyansh Sagar      Mr. P.K. Sagar      18/06/2007             VIII
                  16      Modular (Ver. 1.1)-VIII
   13   14   15   16   17   18   19   20   21   22   23