Relational databases are structured systems that store data in tables with rows and columns, using a schema to define relationships between different data entities. They enable efficient data retrieval and manipulation through SQL queries, ensuring data integrity and consistency using ACID properties.