logo

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

1 Pages318 Words293 Views
   

Added on  2019-09-16

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

   Added on 2019-09-16

ShareRelated Documents
DBMS stores data as a file, in this data is either stored in the hierarchical form or navigational form. The data stored in this is not normalized it means there is no relation present between the tables. Data redundancy is not present in the DBMS that there could be data duplicity present in this, in this data is not is not in integrated form because there is no relation between the tables of the structure and also data in each table is independent to other table because there is no common 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 fully normalized and there is relation among the tables. Data redundancy is present over there and there is very minimal chance of data duplicity. In this data is in integrated form due to relation between the tables and data is not fully independent in the table.The advantage of DBMS are controlling redundancy that is in file system each file has full data and there will be case of data repetition in each file but there is central control data so minimize the redundancy, data integrity maintain easily, less chance of data inconsistency, data can shared easily, restriction to an unauthorized person and we can easily backup data.The disadvantage of DBMS is to make a database of a big project makes its structure very complex and it will be very difficult to understand the structure by another person, with complex database it also comes with the large size, performance can be poor in some circumstance, failure cost a high impact on the project and the cost of develop DBMS is much higher if compare t other.
DBMS stores data as a file, in this data is either stored in the_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Data Modelling & SQL Language: Assignment
|11
|1420
|93

Data Modelling and SQL Language
|16
|2546
|97

Database and Information Management - Assignment
|5
|1165
|18

Database Systems: Normalization, ERD, Hierarchical vs Relational DBMS
|7
|1068
|231

IT Write-up: Data Models, DBMS Functions, Business Rules, and Relational Data Models
|8
|2015
|125

Data Modelling and SQL Language : Report
|31
|4640
|88