What is the purpose of a foreign key in an Entity-Relationship Diagram (ERD)?
- Ensures referential integrity
- Primary identifier of a table
- Represents a one-to-one relationship
- Used for sorting records
A foreign key in an ERD serves the purpose of ensuring referential integrity between tables. It establishes a connection between two tables by referencing the primary key of one table as a foreign key in another, maintaining consistency and relational structure.
Loading...
Related Quiz
- How does collaboration improve the quality of data models?
- What are derived attributes, and why are they used in database design?
- In a database context, what does the acronym ACID stand for?
- In database design, what is the process of Reverse Engineering commonly used for?
- What is the primary goal of compression techniques in data storage?