top of page
Data on a Touch Pad

RDBMS FUNDAMENTALS

RELATIONAL DATABASE

•    A database that stores huge amount of data in tabular format is called as relational database.
•    In relational database a table is called as a relation.
•    A table consists of rows and columns.
•    Rows are called as records and columns are called as fields.
•    In relational database, data are stored, access, manipulate efficiently.
•    It uses various constraints like primary key, foreign key, etc.
•    Example:- IRCTC, banking system, etc.

RDBMS

•    RDBMS stands for Relational Database Management System.
•    It is a software used to manage or maintain relational database.
•    It organizes data in a tabular format.
•    It establishes relationship between tables.
•    E.F. Codd gives 12 rules for database system.
•    A DBMS that satisfy 6 or more than 6 E.F. Codd rules is called as RDBMS.
•    Example:- My SQL, SQL server, etc.
​

Related Topics:

bottom of page