A relational database is organized in a tabular format, where data is structured into rows and columns. Each table (or relation) represents a specific entity, with rows containing records and columns containing attributes. This organization facilitates efficient management and retrieval of data through structured query language (SQL). The tabular format allows for relationships to be created between different tables, enabling the establishment of connections and enhancing data integrity within the database schema.