DATABASE CONCEPTS Information . Information is processed data, which allows to be utilized in a significant way. Example SCERT College Road DPI Campus Chennai 600006 As you can see from the example above, data appears as a set of words and numbers. However, when the data is processed, organized and formatted, it gives a meaningful information about the SCERT institution contact address.
Database . Database is a repository collection of related data organized in a way that data can be easily accessed, managed and updated. Database can be a software or hardware based, with one sole purpose of storing data. DataBase Management System (DBMS) .
A DBMS is a software that allows us to create, define and manipulate database, allowing users to store, process and analyze data easily. DBMS provides us with an interface or a tool, to perform various operations to create a database, storing of data and for updating data, etc. DBMS also provides protection and security to the databases. It also maintains data consistency in case of multiple users.
Examples of DBMS softwares : Foxpro, dbase. 12th Computer Chapter - - . . Relational Database Management System (RDBMS) RDBMS is more advanced version of DBMS, that allows to data in a more efficient way.
It is used to store and manupulate the data that are in the form of tables. Examaple of RDBMS: MySQL,Oracle, MS-Access etc., . . Characteristics of Relational Database Management System .
Ability to manipulate data RDBMS provides the facility to manipulate data (store, modify and delete)in a data base. . Reduced Redundancy In the modern world hard drives are very cheap, but earlier when hard drives were too expensive, unnecessary repetition of data in database was a big problem But RDBMS follows Normalisation which divides the data in such a way that repetition is minimum. .Data Consistency On live data, it is being continuously updated and added, maintaining the consistency of data can become a challenge.
But RDBMS handles it by itself. . Support Multiple user and Concurrent Access RDBMS allows multiple users to work on it(update, insert, delete data) at