DBMS vs. RDBMS Comparison

This homework assignment focuses on comparing and contrasting Database Management Systems (DBMS) and Relational Database Management Systems (RDBMS). The solution details how DBMS stores data in a file-based system, either hierarchically or navigationally, with potential for data redundancy and lack of normalization. In contrast, RDBMS utilizes a tabular structure with primary and foreign keys, ensuring data normalization and minimizing redundancy. The advantages of DBMS, such as reduced redundancy, improved data integrity, and ease of data sharing, are discussed, alongside disadvantages like complex structure for large projects and potential performance issues. The assignment provides a clear understanding of the fundamental differences and trade-offs between these two database approaches.

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.