77.3k views
3 votes
When implementing relationships, each many-one relationship becomes a _____ key?

User EGlu
by
7.1k points

1 Answer

5 votes

Final answer:

In database design, a many-one relationship translates into a foreign key which links two tables together, ensuring referential integrity.

Step-by-step explanation:

When implementing relationships in a database, each many-one relationship becomes a foreign key. A foreign key is a field in one table that uniquely identifies a row of another table. The foreign key thus establishes a link between the data in two tables and enforces referential integrity. For instance, if we have a table of employees and a table of departments, each employee is associated with one department. In the employee table, the department ID would be the foreign key that references the department table.

User Milad Faridnia
by
7.6k points