Relational Database Management System or RDBMS was developed in 1970. It was introduced by Edgar F. Codd who was working with IBM. Basically, RDBMS is a developed form of some popular database systems like hierarchical system etc.
Though this database system was developed originally by IBM, many other stalwarts related to IT came forward with the versions of their own. This led to a competition, between various vendors, to make it more user-friendly and efficient. As a matter of fact, this competition only added to make it simpler and more advanced.
RDBMS is most widely used database system as far as data storage is concerned. Out of many RDBMS products available in the market, its most famous products are Oracle, D2B family by IBM, Microsoft's access etc. Some other famous products are Foxbase, Sybase, Informix etc.
The relational database management system uses Standard Query Language(SQL). The database system keeps all the information in a tabular form. This tabular form uses certain data values to define and describe the data. This database system also ensures that no information in a specific column in repeated.
RDBMS consists of one or many tables. These tables are made of interrelation between many columns and rows. The developers use set theory. This set theory puts these data in these columns and rows. These columns and rows, with data full in them, help to do certain data related operations.
RDBMS has been regarded by many as a very simple but advanced database system. Its simplicity makes its more user-friendly. Its easy-to-use features make it more productive. To make it simpler, simple tables are used by developers. Hence, the processing and understanding of data becomes easier. It also inspire easy communication of data and their transfers.
SQL has always remained too easy to learn by a database operator or user . As RDBMS uses SQL, it becomes lot easier for anybody to master this system at a great speed. Thus, this learning ease makes it immensely productive.
Further, it shows its great inability to store any information in form of an image or pictures. Moreover, a user can't store any video reel or any document in form of audio. In short, nothing sort of digital things could be loaded in this system.
However, the drawbacks and limitations are too less to be counted. These few shortcomings of RDBMS stand nowhere when we have a thorough look upon its vast and effective use and operations. No doubt, it was no less than a wonder when introduced almost forty years ago and interestingly, it is a wonder still.
Stationary Supplies is a company that sells stationary products to customers. Stationary Supplies allows their account customers to place orders over the telephone and delivers the required products to the customers' premises. This is possible for account customers because the company keeps information about these customers in a database, including an identifier, the customer name, phone number and delivery address.
When an order is phoned through by a customer the company records order details, and in-particular the date of the order. Stationary Supplies keeps a database of information about their products, and when orders are received a record of the quantity of a product included in the order is recorded. An order may contain a number of different products.