find and solve || findandsolve.com
Please wait.....

DBMS vs RDBMS



DBMSRDBMS
In DBMS relationship between two tables or files two specified at the creation are maintained programmaticallyIn RDBMS realtionship beteween tables or files can be time of table
DBMS does not support Client/Server/ArchitectureMost of the RDBMS supports Client/Server/Architecture
DBMS does not support Distributed databasesMost of the RDBMS supports Distributed database
In DBMS there is no security of dataIn RDBMS There are multiple levels of security 

1.Logging in at O/S level 

2.Command level(i.e. at RDBMS level) 

3.Object level 

4. in DBMS there is no security of data 

5. Many tables are grouped in on database in RDBMS
Each table is given an extension in DBMSMany tables are grouped in on database in RDBMS
DBMS may satisfy less than 7 to 8 rules of Dr. E F CoddRDBMS usually satisfy more than 7 to 8 rules of Dr. E F



Naming Conventions

DBMSRDBMS
FieldColumn, Attributes
RecordRow, Tuple, Entity
FileTable, Relation, Entity Class

Many of the databases will be small, with one or two tables. But as the databases become braver, tackling bigger projects, it will be noticed that the design of the tables in proving problematic. The SQL written starts to become unmanageable and data anomalies start to creep in. This means it is time to learn about database normalization, or the optimization of tables.

Sundar  Neupane

Sundar Neupane

I like working on projects with a team that cares about creating beautiful and usable interfaces.

Comments



Report Response