Data is arranged into tables, or relations, with rows and columns in a relational database. Foreign keys are used to construct associations across tables, and each table has its own unique key. Data integrity and efficient querying are made possible by this structure.