Explain the advantages of database management system, Database Management System

Advantages of Database management system

Let us summarize the advantages.

Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy is the problem of storing the similar data item in more one place.  Redundancy makes several problems like requiring extra storage space, entering similar data more than once during data insertion, and deleting data from more than one place during deletion. Anomalies may happen in the database if insertion, deletion etc are not done properly.

Sharing of Data: In a paper-based record keeping, data cannot be shared between many users. But in computerized DBMS, lots of users can share the similar database if they are connected via a network.

 Data Integrity: We can handle data integrity by specifying integrity constrains, which are rules and restrictions about what type of data may be entered or manipulated within the database. This enhances the reliability of the database as it can be guaranteed that no wrong data can exist within the database at any point of time.

 Data security: We can restrict certain people from accessing the database or permit them to see certain portion of the database whereas blocking sensitive information. This is not possible very simply in a paper-based record keeping.

 

Posted Date: 7/26/2013 5:41:22 AM | Location : United States







Related Discussions:- Explain the advantages of database management system, Assignment Help, Ask Question on Explain the advantages of database management system, Get Answer, Expert's Help, Explain the advantages of database management system Discussions

Write discussion on Explain the advantages of database management system
Your posts are moderated
Related Questions
what does glory be mean

What is a SELECT operation? The select operation selects tuples that please a given predicate. We use the lowercase letter σ to denote selection.

Give the general form of SQL query? Select  A1, A2............., An From  R1, R2..............., Rm Where  P

(1)     Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER

What is the disadvantage of a call by reference? During a call by reference damage or loss of data is not restricted to the subroutine, but will instantly lead to alters to th

DML Precompiler All the DBMS have two basic sets of Languages - Data Definition Language (DDL) that have the set of commands needed to define the format of the data that is b

What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet



What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC