Explain the advantages of database management system, Database Management System

Assignment Help:

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.

 


Related Discussions:- Explain the advantages of database management system

What is sql, What is SQL, and why is it important? SQL stands for Struc...

What is SQL, and why is it important? SQL stands for Structured Query Language, and is the most significant data processing language in use today. It is not a complete programm

Explain the functional mode with help of an example, Explain the Functional...

Explain the Functional Mode with help of an example. Functional Model  The functional model shows a computation and functional derivation of data values in it without ind

Draw an e-r diagram and convert it to a relational schema, In an organisati...

In an organisation various projects are undertaken. Each projects can employ one or more employees. Every employee can work on one or more projects. Each project is undertaken on

What are the benefits of prepared statements, What are the benefits of prep...

What are the benefits of prepared statements and place holders? Parameter binding operations automatically handle escaping of characters Encourage Statement reuse

Software failures-database recovery and security, Software failures :  In s...

Software failures :  In such cases, a software error abruptly stops the implementation of the current transaction (or all transactions), therefore leading to losing the state of pr

Create the table, Question: Using the data model express the following ...

Question: Using the data model express the following queries in SQL. (a) Create the Table named "Cinema" and make the cinema_code to be the primary key of the relation and

In e-r diagram how relationship type is represented, In E-R Diagram how rel...

In E-R Diagram how relationship type is represented ? In E-R Diagram relationship type is represented as a Diamond.

List and also explain the dissimilar stages of ddlc, List and also explain ...

List and also explain the dissimilar stages of DDLC ?

Data manipulation language, Data Manipulation Language Data manipulatio...

Data Manipulation Language Data manipulation language (DML) describes a set of commands that are used to query and change data within existing schema objects. In this case comm

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd