Relational data Modeling is based on the concept of organizing the data into collections of two-dimensional tables and interfacing these with relationships.
Relational databases are found today in, large-scale applications such as
- The Credit Reference Bureau,
- Airline reservation systems or
- Banking systems,
In medium sized applications, like large retailers and in desktop computers handling individual activities such as:
- CAD systems,
- address books,
- music collections
All of these rely on relational database systems and make good use of tables of information, and the relational data model helps us design these tables and develop the data structures needed to access them efficiently.
Where is it useful
With ODBC, Microsoft opened the ability for anyone using Windows to access relational database management systems (RDBMS) of all sizes using a simple language known as ‘SQL’
Borland, of course, had a similar system which involved dbase and Paradox earlier.
But ODBC now gives a single user access to powerful database engines like ORACLE, ‘SQLanywhere’.
How is it used
The Import issue these days, is the design of the data structure so that relatively inexperienced users can find what they are looking for. The RDBMS engines are typically fast and powerful in their own right
The purpose of the relational model is to provide a discrete method for specifying data.
It states what information the database contains and where (which table) contains it, as well as the relations (links) between the tables.