Whats the Relational DataBase Solution1It is a crowd of data

What\'s the Relational DataBase ?

Solution

1.It is a crowd of data elements arranged as a group of officially details tables from data which are able to retrive or in dissimilar without rearranging the data base tables.

2.It is innovated by E.F CODD in the year 1970.

2.It is a group of tables with data countured into predefined classification.

3.Every table includes one or many data classified in columns.

4.Initially the data bases are smooth or even.i.e the data preserved in a single text file known as tab delimited file .every arrival in the text file is sundered with a special charecter like vertical bar(I) .

5.RDBMS is able to contrast information fastly.it utilizes the relation with same data to raise the speed and flexibility of the data base.

6.RBMS are fabricated with a computer languages as SQL structured quey language which is the basic for a database interperability.

Rules for relational database

1.every table will have a UNIQUE name.

2.every table is with number of rows.

3.evry column in a table will have a unique trait name.

There are many kinds of relation depending on the records in a table that are associated to number of records in another table ,it is callled as cardinality.

1.one to one

2.one to many

3.many to one

4.many to many