Exploration of Relational Database, Query Language, Relational Algebra and its operations

Abstract: DBMS acronym of Database Management System comprises of a collection of inter related data. It is a set of program or software that help to access the stored data in a very easy and efficient manner.  Database are generally used to design and to manage large amount of data in a very systematic manner. The management of stored information includes both the definition of structures for the storage of information and provision mechanism for manipulation of this information. This information is stored permanently in various files. Various application software is written to fetch or extract the information from these files as and when required. DBMS removes the data redundancy and inconsistency among the data. DBMS also provides different levels of security to the data. It also retrieves the data form the database as per the criteria specified by the user.

Keywords: RDBMS, DBMS, Relational Algebra, Relational Calculus, Procedural Language, No-Procedural Language, Query Language