Question

28. How well does your school’s DBMS fulfill the functions of a DBMS as described in this chapter? Which functions are fully supported? Which are partially supported? Which are not supported at all?

Answer 1

Yes, we can say that school DBMS full fill mainly all the functionality of DBMS functionality.

Main advantages or core functionality of DBMS are:

1. Better data sharing

2. Improved data security

3. Better data integration

4. Minimized data inconsistency

5. Improved data access 6. Improved decision making

7. Maximized end-user productivity.

8. Providing Backup and Recovery.

9. Restricting unauthorized access.

10. Concurrency Control

Other main functionality are:

1. Retrieve and Update Data

2. Recovery of data or documents supported in school DBMS

3. Security of important files

4. Data Integrity

Partially functions supported are:

Data independence provides help in making changes to the database structure. Changes include adding new data, fields, changing relationships, etc. The DBA or school principal can make the necessary changes to the maintenance of the software.

Not supported, functionality is: School DBMS does not require catalog services.

The catalog contains information about the database structure, coordinates, fields, etc. It is usually accessed by the designer of the database. Separate updates are not required as this database does not have details around different locations.