Page 36 - TP_Prime_V2.2_Class8
P. 36

A Database Management System (DBMS) is software that enables users to create, manage,
                  and manipulate databases. It provides a systematic way to store, retrieve, and organise
                  data while ensuring data integrity, security, and consistency.


                   Advantages of a Database System


                  A database system has many benefits. Some of the important benefits or advantages are:
           Prime (Ver. 2.2)-VIII  •  It minimises the  duplication of data  by  organising data  in a  structured manner. This


                    ensures that data is not unnecessarily repeated across tables.
                  •  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 made.



                   Types of Databases

          34      There are mainly two types of databases:
                  • Flat File Database: A flat file database is a simple type of database that

                    stores data in a single table or file, often as plain text or in a spreadsheet
                    format. Each record in the flat file is typically stored as a single line of
                    text, with fields separated by a separator (like commas or tabs). The most
                    popular example of flat file database is Excel 2016.                                  Excel 2016

                  • Relational  Database: It is a type of database that stores data in several tables and
                    links those tables together through keys that allows efficient data retrieval and reduced
                    redundancy. Commonly used relational database systems are Microsoft Access, Microsoft
                    SQL Server, ORACLE, etc.










                                                           Relational Databases

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





                                    If a database is like a treasure chest and you're the treasure keeper, how would
                                    you organise and store your precious items to make sure you can find them easily

                                    when needed?
   31   32   33   34   35   36   37   38   39   40   41