DBMS stores data as a file, in this data is either stored in the

Added on - 16 Sep 2019

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 1 of 1 pages
DBMS stores data as a file, in this data is either stored in the hierarchical form ornavigational form. The data stored in this is not normalized it means there is norelation present between the tables. Data redundancy is not present in the DBMSthat there could be data duplicity present in this, in this data is not is not inintegrated form because there is no relation between the tables of the structureand also data in each table is independent to other table because there is nocommon element between them.RDBMS store data in the tabular form and it uses attribute like primary key,foreign key to store the data as tables. The data present in tables are fullynormalized and there is relation among the tables. Data redundancy is presentover there and there is very minimal chance of data duplicity. In this data is inintegrated form due to relation between the tables and data is not fullyindependent in the table.The advantage of DBMS are controlling redundancy that is in file system each filehas full data and there will be case of data repetition in each file but there iscentral control data so minimize the redundancy, data integrity maintain easily,less chance of data inconsistency, data can shared easily, restriction to anunauthorized person and we can easily backup data.The disadvantage of DBMS is to make a database of a big project makes itsstructure very complex and it will be very difficult to understand the structure byanother person, with complex database it also comes with the large size,performance can be poor in some circumstance, failure cost a high impact on theproject and the cost of develop DBMS is much higher if compare t other.
Desklib Logo
You are reading a preview
Upload your documents to download or

Become a Desklib member to get access