A database is an organised collection of structured data stored electronically in a computer system. It is designed to efficiently manage, store, retrieve, and manipulate data, making it accessible for various applications and users.
Databases organise data in a structured manner, typically using tables composed of rows and columns. Each row represents a record or entry, while columns define specific attributes or fields of that record.
A Database Management System (DBMS) is software that enables users to interact with the database. It provides tools and interfaces to create, modify, delete, and query data within the database. Examples of DBMS include MySQL, Oracle, Microsoft SQL Server, PostgreSQL, and MongoDB.
ACID (Atomicity, Consistency, Isolation, Durability) properties are fundamental to database transactions. These properties ensure that database transactions are processed reliably and securely, guaranteeing the integrity of data.
Databases serve as critical components in various applications and industries, including banking, healthcare, e-commerce, finance, education, and more, enabling efficient data storage, retrieval, and management to support organisational operations and decision-making.
