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?

