Data in a relational database is stored in tables, which consist of rows and columns. Each table represents a specific entity, while columns define the attributes of that entity. Relationships among tables can be established through keys, particularly primary and foreign keys, enabling efficient data organization and retrieval. SQL (Structured Query Language) is commonly used to manage and query this data, allowing users to insert, update, delete, and retrieve information seamlessly while maintaining data integrity.