DATABASE MANAGEMENT
EXPLANATION OF DATABASE MANAGEMENT
Any organization is depend upon the data . So it becomes more vital and important to the organization And it become necessary to manage and manipulate the data . This process of managing the data is known as DATABASE MANAGEMENT.
LEVELS OF DATA The data has different hierarchy levels. And data is logically organized into
The data has different hierarchy levels. And data is logically organized into
v CHARACTER v FIELD v RECORD v FILE v DATABASE
EXPLANATION
CHARACTER The Character is most basic logical data element which consist of single Alphabet Numeric symbol For example :Name of the person Date of birth
FIELD The next higher level of Data is ‘FIELD’ It consist of group of characters. It represents the an attribute in . For example
RECORD The record is related to fields of data . The combination of fields make the record or table. For example
FILE A group of related records are known as file . Example
DATABASE The data base is the highest level in hierarchy. It is the integrated collection of logically related records or file.
OBJECTIVES OF DATA BASE
The objectives are 1. CONTROLLED REDUNDANCY The redundant data occupies the space and also cause to create errors in tables. The major objective is to remove duplicity.
EASE of LEARNING & USE The database is easy to use which mean to access the database the professional skilled users and programmers are not required.
Security The security can be maintained by allocating passwords . And also unauthorized access can be restricted to the data.
Accuracy The users can be able to make accuracy in the DATA BASE.
BACKUP The user can take the back up whole database and store it into hardware.
RECOVERY The Database Administrator can recover the whole data in case of damage to the data.
Shared In multiuser application the data in database can be shared. The data can be shared if database is integrated. For example Data in banks
Performance The major objective is to give the performance as the users or the organizational required and it can also be design to give qualitative performance.
Types of DATA BASE
DATA BASE MANAGEMENT SYSTEM Dbms is the software that organize the data Manage the data Manu plate the data Calculate the data