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. Discuss the problem which may arise during concurrency control and recovery in distributed database which are not encountered in controlized database environment.

List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view

what problems are raised by the database? why is it so controversial? why is data quality an issue?

Define the Boyce-Codd Normal Form with instance and also Compare BCNF and 3NF.  Ans: BCNF: For each functional dependency X->Y in a set F of functional dependencies over relati

Question: (a) Can a set of data requirements be correctly modelled by two or more different ER diagrams? Explain your answer. You may use a small example, if you think it will

Let us now make the E-R diagram for the student database as per the explanation given in the previous section. We can also states the overall logical structure of a database usi

sql is relationally complete-justify

Attributes attached to an entity can be of various types. Simple The attribute that cannot be further separated into smaller parts and shows the basic meaning is known as a

Describe five main functions of a database administrator. Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Genera

What are the different strategies of implementation of the Statecharts?  There are two strategies for implementation of state charts: i)   Basic Implementation Strategy