InterviewSolution
Saved Bookmarks
| 1. |
Difference between RDBMS and DBMS in points |
|||
| Answer» | BASIS FOR COMPARISON | DBMS | RDBMS | \t\t\tStands forDatabase Management SystemRelational Database Management SystemData storageData is stored in the navigational model.Data is stored in the relational model (in tables).Data redundancyExhibitDoes not presentNormalizationNot performedRDBMS uses normalization to reduce or eliminate redundancy.ModifiabilityModification in data is complex.Modification in data is easy and simple.Data accessConsumes more time.Faster as compared to DBMS.Schema-based constraints and data dependenciesNot employedEmployed in RDBMS.Keys and indexesDoes not used.To establish relationship keys and indexes are used in RDBMS.Transaction managementInefficient, error prone and insecure.Efficient and secure.Distributed DatabasesNot supportedSupported by RDBMS.ExampleDbase, Microsoft Access, LibreOffice Base, FoxPro.SQL server, Oracle, mysql, MariaDB, SQLite.\t|
|---|---|---|---|---|