Home | SCIENCE | Information Management - BA8205 | RDBMS-Relational Database Management System

Business Science - Information Management - Database Management Systems

RDBMS-Relational Database Management System

   Posted On :  15.12.2016 07:30 am

In relational databases, the relationship between data files is relational. Hierarchical and network databases require the user to pass a hierarchy in order to access needed data.

RDBMS-Relational Database Management System

 

In relational databases, the relationship between data files is relational. Hierarchical and network databases require the user to pass a hierarchy in order to access needed data. These databases connect to the data in different files by using common data numbers or a key field. Data in relational databases is stored in different access control tables, each having a key field that mainly identifies each row. In the relational databases are more reliable than either the hierarchical or network database structures. In relational databases, tables or files filled up with data are called relations designates a row or record, and columns are referred to as attributes or fields.

 

Relational databases work on each table has a key field that uniquely indicates each row, and that these key fields can be used to connect one table of data to another.

 

            The relational database has two major reasons

 

            Relational databases can be used with little or no training.

 

            Database entries can be modified without specify the entire body.

 

            Properties of Relational Tables

 

In the relational database we have to follow some properties which are given below.

 

It's Values are Atomic

 

In Each Row is alone.

 

 

            Column Values are of the same thing.

 

            Columns are undistinguished.

 

            Sequence of Rows is Insignificant.

 

            Each Column has a common Name.


Tags : Business Science - Information Management - Database Management Systems
Last 30 days 50 views

​ReadOrRefer.in

OTHER SUGEST TOPIC