What is DBMS?

DBMS (Database Management System) allows users to create, manage, and interact with databases. It provides tools to store, retrieve, update, and delete data efficiently, ensuring data integrity and security.

FHm2ER5VIAEwWoP_enhanced.png

What are the different types of DBMS?

Copy of Stakeholder Map Team Whiteboard in Green Yellow Purple Trendy Stickers Style (7).png

  1. Relational DBMS (RDBMS): Stores data in structured tables with rows and columns. It uses SQL for querying and managing data (e.g., MySQL, PostgreSQL).
  2. NoSQL DBMS: Handles unstructured or semi-structured data, often used for large-scale, distributed applications. It supports a variety of data models, including document, key-value, column-family, and graph (e.g., MongoDB, Cassandra).

DBMS and RDBMS?

RDBMS DBMS
It stores the data in the rows & columns in table format. It stores the data in the format of files.
It is designed to handle large amounts of data. It is designed to handle a small amount of data.
In RDBMS normalisation is not achievable. In DBMS normalisation is achievable.
Ex: MySQL—stores data in tables with relationships, like a customer table linked to an orders table. Ex: FileMaker—used to store and manage data without complex relationships.

What is the Difference Between Database and Data Warehouse?

Database: Used for daily operations and storing current data.

Ex: A database at a retail store might keep track of each day’s sales, customer information, and inventory levels.