What is RDBMS?
A Relational DataBase Management System (RDBMS) is a software that:
-Interprets an SQL query and combines information from various tables.
-Allow you to use and implement a large as well as small database with relation, columns, tuples and indexes.
-Updates the indexes automatically.
-Specify the Referential Integrity between the tuples of many tables.
RDBMS Terms:
Database - Collection of the tables(relation) or data is called Database.
Table - The table is a collection of data in rows and columns format.
Column - Column is also called as attribute of the table. which is nothing but used to identify the structure of any entity.
Row - A row is called as tuple in database which define the value of the attribute
Redundancy - Repetation of data in database is called redundancy
Primary Key - From multiple candidate key, administration choose one key then it is called primary.
Foreign Key - The key of one table which derived from the primary key of another table is called as foreign key.
Compound Key - Compound key is also called as candidate key which is minimal superkey.
Index - The table index is used for the fast accessing of the database like index page in books.