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

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