Pages

Popular Posts

Powered By Blogger

Monday, November 9, 2009

Difference between DBMS & RDBMS

DBMS (Database Management System):

1)In DBMS no relationship concept.
2)It supports single user only.
3)It treats data as files internally.
4)It supports 3 rule of EF CODD out of 12 rules.
5)It requires low software and hardware requirements.
6)FOXPRO,IMS are example.

RDBMS (Relational Database Management System):

1)It is used to establish the relationship concept between two database objects.i.e,tables etc.
2)It supports multiple users.
3)It treats data as tables internally.
4)It supports minimum of 6 rules of EF CODD.
5)It requires high software and hardware.
6)SQL-server,Oracle are examples.

12 RULES OF EF CODD:

If DB support >=6 then the DB is known as RDBMS rule.

1)Information rule:DB is should contain in the form of table with R&C for storing.
2)Rule of Guarantee access:For ex:if emp,dept if i want to access emp it should give the data from emp not from other table.
3)Systematic treatment of Null value:Null value:Absence of info.
4)Comprehensive Sub language:
5)View update rule:
ex: emp emp1
10 columns 3 columns
6)Insert and Update rule:
DMS command insert,update,delete.
7)Physical data independent:
HD1 HD2 HD3
Access the data from any HD
8)Logical data independent:
C D E F
Access the data from others.
9)Data description rule:
See the structure of table
>desc emp;
10)Data distribution rule:
DB ADMIN
emp,dept LAN
Distribute the table which can access from db.
11)Integrity rule:
Constraints
12)No subversion rule:
New version should support old version.

1 comment: