0
DBMS stands for database management system. DBMS reduce data redundancy as it checks if the data is duplicate and if duplicate then store it as a single record.
Wiki User
∙ 2014-11-21 15:53:09
Add your answer:
Earn +20 pts
Advantages of normilisation in dbms?
To reduce the data redundancy and saving disk space.
What is Data redundancy in DBMS?
In database we store data however the can be redundant. Redundancy means repetitive data that is taking extra storage space . So to reduce or prevent the storage space we should eliminate redundancy or just reduce it.
What is the difference between controlled redundancy and uncontrolled redundancy?
Redundancy is controlled when the dbms ensures that multiple copies of the same data are consistent. If the dbms has no control over this, uncontrolled redundancy.
What are the advantages DBMS?
-data redundancy:which reduce the redundancy-repetition of data -security-it provides security for various levels -data sharing-it allows multiple users to access and share the data becomes easier in dbms -data concurrency:it allow multiple users to acess the same data simultaniously
What are advantages of dbms approach?
There are number of advantages of DBMS approach , some of them are : Data integrity is maintained, Data accessibility is also easy, The redundancy of data is also reduced.
What is de-normalisation in dbms?
Hi, Denormalisation is the process to read the performance by adding redundancy of data or by grouping of data.
What are the characteristics of DBMS?
Database management system is full form of DBMS . Characteristics of a DBMS are following : 1) It maintains data integrity. 2) It reduces redundancy. 3) make access to data easy.
DO you have redundancy of records in distributed DBMS?
Redundancy means duplicacy of data or repetitive data. In distributed database case the data is stored in different systems . So the answers is yes there can be redundancy of records / data.In distributed database , data is stored in different systems. Since the data is distributed there is redundancy of records.
What are the advantages of database management system?
There are many advantages of database management system. DBMS makes it much easy to store and manage data . DBMS also helps in reducing redundancy of data.
What is redundancy in dbms?
If in the database have more then one records of same type then it is called redundancy.
Difference between file processing and dbms?
DBMS overcomes all the disadvantage of traditional FPS. The main difference between FPS and DBMS is that FPS do not support data sharing, data security and non redundancy.
Introduction of dbms?
dbms- database management systems............ it is a collection of interrelated data and the set of programs to access those datas....... it is used to meet the disadvantages of the file systems....... there are many disadvantages of filesystems....... lik,, data redundancy and data in consistency, difficulty to access data,integrity problems, atomicity problems............. dbms is quite complicated but better than file systems
