RDBMS, , , , ,
  • RDBMS stands for Relational Database Management System
  • In DBMS, database is stored within a single table while in a Relational Database Management System database is spread over multiple tables and they are connected with some relationship
  • It is based on the relational model introduce by Edger.F.Codd in 1970
  • In 1985 he published 12 rules that can be considered as a measurement for a system to be RDBMS.
  • A system that satisfies most of the code rules is considered as RDBMS.
  • Oracle, Microsoft access, and My SQL are example of RDBMS applications.

Applications of DBMS/RDBMS

  • DBMS/RDMBS is the most frequently used in real life. It has wide applications area. Some major applications where it is used are as follow:
  1. It is used for maintaining small as well as large databases of the firms, companies and organizations.
  2. t is used for managing inventroy and stock, payroll etc.
  3. It ia used as an analysis tool for managind and processing data warehouses and data mining for better understanding and decision making.
  4. It is used for recording and managing day to day activities and transactions such as production, salling, income and expanses, purchase.
  5. Used in hospitals, banks, railway, school, colleges for managing their routine activiteis.
  6. It is used for financial planning and developing business strategy.
  7. It can be useful for monitoring financial and economical state of the organization.

DBMS v/s RDBMS

DBMS RDBMS
In DBMS, Relationship can be maintained programmatically. In RDBMS, Relationship can be created at the time of table creation.
It does not support client server architecture. It supports client server architecture.
It does not support distributed databases It support distributed databases
It has less security over data It has higher security over at OS level, command level and object level
It satisfies less than 7 to 8 codd rules. It satisfies more than 7 to 8 codd rules.
The following naming conventions are used.

(1)Fields

(2)Record

(3)File/Database

 The following naming conventions are used.

(1)Columns/attributes

(2)Row/Tuple

(3)Table