DATABASE

DB :
A structured system used to store, manage, and retrieve data efficiently for multiple users and applications.

• Scalability : Handles large volumes of data efficiently.
• Data Integrity : Maintains accuracy using rules and constraints.
• Security : Protects data through controlled access and permissions.
• Analytics : Helps analyze data to support better decision-making.

TYPES OF DB :

1. Relational Databases.
2. NoSQL Databases.

RELATIONAL DATABASE(RDBMS) :

• Organize data into tables made up of rows (records) and columns (fields).

• They use schemas (blueprints) to define how data is structured and how different tables relate to each other.

1. MySQL.
2. Postgre SQL.
3. Oracle.
4. SQLite.

Postgre SQL :

An open-source relational database management system that stores and manages data in structured tables using SQL.

• Designed to manage structured data with high reliability and consistency.
• Handles relational, JSON, array, and custom data types efficiently.
• Used by banking, e-commerce, healthcare, and enterprise applications to manage large volumes of data securely.