what is rdbms | one to one | one to many | many to many relation-codlack

what is rdbms

RDBMS stands for Relational Database Management System.

In HDBMS and NDBMS data is organized in the form of a  tree structure which looks complex to manage and  understand also. So to overcome this problem  in 70’s  dr. E F. codd from IBM came with a new concept on string the data in a table structure i.e. rows and columns of data.

E.F codd  with all his ideas for the new model called as relational model has published an article with the title as  “A relational model of Data for large shared data  bank”.

Basing on this above article many  companies came forward like IBM, Relational software INC(currently oracle) etc. has started the designed for the new database model i.e. RDBMS.

RDMS is mainly based on two mathematical principles relational algebra and calculus.

IN the year 70’s IBM has given the prototype for RDMNS known as “system R”.

In the year 1974 IBM has launched a language for communication with RDMNS known as SEQUEL.

The  first relational data base was launched in the industry in the year 1978 with the  name multi relational data store followed by Berkley ingress Quel and IBM Bs12

IN the year 1979 relational software INS has launched the most popular database in the market  right now i.e. oracle.

Here relation can be defined as commonness between objects these relations are classified into 3 types

  1.  One to One relation
  2. One to Many relation / Many to One relation
  3.  Many to Many relation

One to One relationship:
In this relationship one object can have a relationship with another object.

One  to Many relationships:- 
In this relationship one object can have a relationship with many objects.

one to many rdbms

Many to Many relationship:-
In this relationship many vendors (or) many objects can have the relationship with many other objects

many to many relation in rdbms

All the above relationships can be called as “Degree of Relationships”.

This model was developed on the basis of a mathematical concept can be called as “Relation Algebra” (i.e. sets & Relations).