Page 18 - Database-En-V3

The advantages of database as declared below:

1. Data recovery and backups:
Database management systems provide backup copies of the database, and restore
data in the event of any malfunction rather than the destruction of the data, and even
if the data is destroyed, backup copies can be used.

2. Instant data update:
Designing the database in a standard and integrated form, and unifying the source of
data for all applications that handle it, grantee that any update, modification, addition,
or deletion, is immediate applied for all applications that use the database.

3. lowFirgeudreu1nadcaonmcmyodn adattaabosre dwuithpltiwcoaptiroognr:ams that provide maulti services to different users
Since a single database is used, no attributed or data is recorded more than once. Only
a limited repetition of a number of data fields occurs in a manner controlled by the
database designer in order to link the data to each other. These fields are called
foreign keys, and we will discuss them in detail later in the database design part. This
prevents loss of storage space, effort, and time required for that.

4. Data consistency or consistency:
Not duplicating data within one database is allowed, so there is no the absence of any
incompatible data. This is because entering, modifying, or deleting any data takes
place in the same database and all applications that deal with the database are
affected by it. (For example, in the university system, when the number of hours for a
particular subject is modified, this modification appears in student schedules and
professor schedules.

5. Provides flexibility:
The database processing system is characterized as great flexibility, adjustability and
database requires very little time and effort and therefore low cost (such as deletion
and addition).

6. Availability of standard specifications:
Usually, the database designer places restrictions on the data and their relationships
with each other. These restrictions are imposed by the system on all those dealing
with the database, which ensures the availability of high standard specifications
because they are mandatory from the system (for example, we do not enter a score
greater than one hundred when entering the students’ grade, assuming that the
maximum grade for the course is Academic score: 100 marks.

11 Training unit in the field of technological information - at the Supreme Council of Universities © Intellectual property rights 2024