Relational Database Management Systems- Introduction

Data: 

Data refers to raw facts that represent information or observations. It must be processed or interpreted to become meaningful.

Data is unprocessed and lacks context (Raw data).  It may not have structure or meaning on its own(unorganized). Can be qualitative (Ex: Green) or quantitative (Ex: 36).

After processing or interpreting, data becomes information, which is data that is meaningful and useful for decision-making.

Database:

A database is a structured collection of data that is organized to allow easy storage, management, and retrieval. It is designed to keep information in a way that makes it efficient to find, update, and use when needed.

Example, university database organizes the data about students, faculty, and admin staff etc. which helps in efficient retrieval, insertion and deletion of data from it.

Database Management System:

A Database Management System (DBMS) is a software system that allows users to create, manage, and interact with databases. It provides tools to store, organize, update, and retrieve data efficiently while ensuring data security, integrity, and consistency.

    A Database Management System is software that helps users work with databases easily and safely. It handles how data is stored, organized, and used.

Example: MySQL, Oracle etc.

Relational Database Management Systems (RDBMS):

A Relational Database Management System (RDBMS) is a type of database management system that stores data in tables made up of rows and columns. It uses a structure based on the relational model, which organizes data into relationships (or "relations").

A relational database refers to a database that stores data in a structured format using rows and columns. It is "relational" because the values within each table are related to each other. Tables may also be related to other tables. The relational structure makes it possible to run queries across multiple tables at once.

Most well-known DBMS applications fall into the RDBMS category. Ex: Oracle Database, MySQL, Microsoft SQL Server, and IBM DB2. Some of these programs support non-relational databases, but they are primarily used for relational database management.

Examples of non-relational databases include Apache HBase, IBM Domino, and Oracle NoSQL Database.