Yes, tables can be linked in a database. This is typically done using foreign keys, which are fields in one table that reference the primary key of another table. This relationship allows for the establishment of connections between related data across different tables, enabling more complex queries and data integrity. Common types of relationships include:
- One-to-One: Each record in one table corresponds to one record in another table.
- One-to-Many: A record in one table can be associated with multiple records in another table.
- Many-to-Many: Records in one table can be associated with multiple records in another table and vice versa, often implemented using a junction table.
These relationships help maintain data consistency and facilitate efficient data retrieval.
