Database Management System | Computer XI
Data : It is raw fact and figure about person , place , event or thing which can be recorded in computer in the form of number , text , pictures , audio , video etc. Example Meropaper , 30 , hello world etc.
Information : It is the processed value which we get after processing by the computer . Example : I am 14 years old,I am a student etc.
Database : It is the well defined collection of data . Example : telephone directory , dictionary etc.
DBMS(Database Management System) : It is the collection of program that enables users to create and maintain database . Example : Ms. Access , Oracle , FoxPro etc.
Objectives of DBMS :
(i) To provide storage area for mass amount of relevant data .
(ii) To make access to the data easy for the end user.
(iii) To eliminate data redundancy .
(iv) To allow the growth of database .
(v) Protecting data against unauthorized access.
Advantages of DBMS :
(i) To make easy to add new data , modify the database and delete existing data .
(ii) Organize the data in proper sequence .
(iii) Eliminate the data redundancy of data.
(iv) Protecting data against unauthorized access .
(v) Allow the growth of database system .
Disadvantages of DBMS :
(i) Cost of purchasing a developing software .
(ii) Chances of losing data .
(iii) Chances of data leakage and hacking .
(iv) Cost of sharing data .
(v) Requires trained manpower .
RDBMS( Relational Database Management System ) :
The DBMS which is used to manage and manipulate the data in relational database model is called RDBMS . It is reducing data redundancy . Example : SQL Server , Oracle etc.
- Support for very large database .
- It is very useful in data redundancy .
- Automatic optimization of searching .
- Uniform security and privacy enough password .
- View and automatic backup .
Some useful links : Define Computer Architecture and Computer Organization (Grade 11).