How to implement one-to-many relationship while designing-01311

Online Quiz This subjective question is related to the book/course vu eng201 Business and Technical English Writing. It can also be found in vu eng201 Mid Term Solved Past Paper No. 4.

Question 1: How to implement one-to-many relationship while designing tables?
Answer:

If the primary key in a parent table matches multiple foreign keys in a child table, then the relationship is one-to-many. This relationship is common in database applications. For example, an application for a sports league might access a team table and a player table. Each team has multiple players, and each player belongs to a single team. Every row in the child table (player) has a foreign key identifying the player's team. This foreign key matches the team table's primary key.

When designing such entity beans, you must decide whether both tables are represented by entity beans, or just one.


Choose an organization

Theme Customizer

Gaussian Texture



Gradient Background