A relational database is a structured collection of data that uses a schema to define relationships between tables, enabling efficient data retrieval and manipulation through SQL queries. It ensures data integrity and reduces redundancy by organizing data into tables where each row is a unique record identified by a primary key.