Explain the Concept of Databases:
A database is a collection of logically related data sets of files. Normally, these files/data sets are of different nature, used for specific purposes. These may be organized in various ways to meet various processing and retrieval requirements of the organization or users For Example;
A bank may have separate files for its clients i.e.
- Savings A/C
- Automobile loan
- Personal Loan
- Clients biographic information etc
The bank clients or customers database would include records from each of these files. Using a series of programs, data for any client may be added , retrieved or updated depending upon the activity at a particular time. It is a computerized system whose overall purpose is to maintain information and to make that information available at any time. A database system is just a computerized and fast record keeping system. A database itself can be regarded as a kind of electronic file cabinet, a warehouse or a repository for a collection of computerized data files. The user of the database normally has the following facilities to enjoy
- Adding new, blank files to the database
- Inserting new data into the existing files
- Retrieving data from existing files
- Updating data in existing files
- Deleting data from existing files
- Removing existing files, empty or otherwise from database
Objectives of Databases
There are at least three main objectives of databases in basic level for using the database organization
In database, information is coordinated from different files and operated on a single file. Logically, the information is centralized, physically data may be located on different devices i.e. scattered around over on different locations, connected through data communication links.
If a data is contained in more than on file is changed then all files must be updated if that item is changed. In a database, only one copy of data is kept, therefore, the data is more consistent
Conventionally, if the format of a file is changed then all the programs have to be changed. However, a data base allows the organization of data to be changed without the need to re-program. It allows programs to be modified without re-organization of data.