DATABASE MGT SYSTEMS

l Is a program that allows users to define, create, manipulate, store, maintain, retrieve and process the data in a database in order to produce meaningful information.

l DBMS overcomes all limitations of FPS

¡Eliminates separation and isolation of data.

¡Reduces data redundancy

¡Eliminates dependence between program and data.

¡Allows for representation of data from user’s view

¡Increases data flexibility

¡Superior flexibility and security over spreadsheet applications.

CHARACTERISTICS OF A DBMS

¡Computerized record-keeping system

¡Contains facilities that allow the user to:

l Add,delete files

l Insert retrieve, update, delete data.

¡Collection of databases; each can be used for separate purpose.

FUNCTION AND USES OF A DBMS

¡To Store data

¡To organize data

¡To control access of data

¡To protect data.

¡To provide decision support

l For inquiry, analysis and decision making.

¡To provide transaction processing.

l Through inputs, updates and process data with transactions will generate information needed by users...

COMPONENTS OF A DBMS.

¡Design tools.

lProvides features for creating the database and various application, forms and report.

¡Run-time facilities

lProcess the applications created by the design tools.

¡DBMS engine

lTranslates btwn the design tools and run-time facilities and the data.

Advantages and Disadvantages of a DBMS

•Advantages:

?Centralized data reduces management problems

?Data redundancy and consistency are controllable

?Flexibility of data is increased

?

•Disadvantages:

?Requires special knowledge

?Possible dependency of application programs to specific DBMS versions

make love

Author & Editor

Has laoreet percipitur ad. Vide interesset in mei, no his legimus verterem. Et nostrum imperdiet appellantur usu, mnesarchum referrentur id vim.