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

Chapter: Business Science : Information Management : Database Management Systems

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.

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.


Study Material, Lecturing Notes, Assignment, Reference, Wiki description explanation, brief detail
Business Science : Information Management : Database Management Systems : RDBMS-Relational Database Management System |


Privacy Policy, Terms and Conditions, DMCA Policy and Compliant

Copyright © 2018-2023 BrainKart.com; All Rights Reserved. Developed by Therithal info, Chennai.