Understanding Relational Database Management System (RDBMS) in simple terms

By


Relational Database Management System 
(RDBMS)

A relational Database is a way of organizing data in rows and columns. The structure used to store data in row and column format is known as a table.

A relational database and the software required for handling the database will together form an RDBMS. It allows you to create, read, update, and delete (CRUD operations) data on a database.

In mathematics, 'a relation' is defined as a set of tuples that have the same attributes.

The table is a name we commonly use to represent a relation. It has a set of tuples(rows) and the same attributes(columns)

From the above discussion, we can understand that RDBMS is nothing but a collection of tables that store interrelated data  +  a set of programs to access and manipulate that data.

Some of the commonly used RDBMS packages are MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, IBM Db2, MariaDB.0



What are the different types of database users?




What do a database administrator do ?




Comments

Post a Comment

Popular posts from this blog

Understanding Database Normalization:

By
Image
Understanding Database Normalization:   In the world of database management, data organization is key to efficient storage, retrieval, and maintenance. One of the most important techniques for achieving this is database normalization . This process structures a database in a way that reduces redundancy and dependency, ensuring data is stored logically and consistently. In this blog, we'll explore what database normalization is, why it's essential, and the various normal forms (rules) that guide the normalization process. What is Database Normalization? Database normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. The primary goal of normalization is to eliminate duplicate data, ensuring that data is stored only once. When a database is normalized, each piece of information is stored in only one place, which reduces the risk of data inconsistency and makes it easier to update and maintain the database. Why...
Read more

Understanding the basic concept of DBMS - Database Management System

By
Image
Describing what a Database is or  What is a database  As ordinary computer users, we may be accustomed to saving data in simple files like text files in notepad, spreadsheets like Microsoft Excel, etc. When it comes to a single user, spreadsheets are excellent. We can use them to execute basic operations like integrating data from different sheets or even creating appropriate reports and dashboards. As long as the data volume is manageable and limited, this is alright. Otherwise, we must use what we refer to as databases, which are simply software applications made to store massive amounts of information in a highly structured manner. Note : Unofficially wherever we store data can be called a database; however computer science people generally call the software application, which is specifically built to handle data, a database.  I would like to stick on to the word "Database Management Systems/DBMS" when we refer to such applications 😀 A Database Management System in s...
Read more