Difference between DBMS and RDBMS | Functional dependency types 2023

Difference between DBMS and RDBMS ?

DBMS :-

1. It stands for Database Management System .
   
   
2. DBMS can store data in any format. It can store data in the form of tree. graphs and also in tables.
   
   
3. DBMS is for single user only. It can not maintain many users at same time.
   
   
4. DBMS does not satisfy codd's rules. In DBMS no relation between database objects stored in database.
   
   
5. DBMS are for smaller organizations with small amount of data. where security of the data is not of major concern.
   
   
6. DBMS does not support client / server architecture .
   
   
7. It requires low software and hardware requirements .
   
   
8. Examples of some popular DBMS tools are: Dbase, Access and Foxpro.
   
   

RDMS :-

1. It stands for Relational Database Management system .
   
   
2. RDMS always stores data in the form of tables .
   
   
3. RDMS is for multi-user . It can maintain many many user at the same time .
   
   
4. RDBMS satisfy codd's ruies. in RDBM . relation between database objects stored in database. 
   
   
5. RDBMS are designed to take care of large amounts of data and also the security of the data .
   
   
6. RDBMS supports client/server architecture .
   
   
7. It requires high sottware and hardware requirement .
   
   
8. Examples of some popular RDBMS tools are: Oracle. Sybase, Infomix and SQL Server .
   
   

• FUNCTIONAL DEPENDENCY :-
  

             In RDBMS. Functional dependeney deseribes a relationship between the auribuies ot a single relation (table). It occurs when one aiutribute in a relation uniquely detemines akxher attribute i.e. an attribute is functionally dependant on another if we use the value attribute to determine the value of another.

                     In the above table, Roll_No attribute acts as a PRIMARY KEY as it uniquely determines each record of the relation (table). The other attributes Name, Class and Mobile No are functionally dependent on the primary key Roll_No because corresponding to Cach student's roll number, there exist one value of Name, Class and Mobile_No respectively which is represented as: