In a relational database, data is organized into tables. Each table consists of rows and columns, where each row represents a unique record and each column represents a specific attribute of the data. Relationships between tables are established through keys. The primary key uniquely identifies each record within a table, while a foreign key links records across different tables.
