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
Question: (a) Why is it important to know the architecture rather than to start requirement capture when designing a large scale system? (b) Who are the different people in

Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t



er diagtram for icici

What are the advantages of DBMS ? 1. Centralized Management and Control - One of the major advantages of using a database system is in which the organization could exert, thr

Which product produces the relation that has attributes of R1 and R2 ? Cartesian product produce the relation which has attributes of R1 and R2

Table Handling  In RDBMS more than one table can be tackled at a time by using join operation. Join operation is a relational operation that causes 2 tables with a common domai

Explain in detail the consistency model of the distributed file system you studied (GFS or AFS). Present the consistency model chosen and how it was achieved through design. Clarit

statical data