You are here

Relationship Types

19 January, 2016 - 14:28

You may have noticed in the previous image is the dashed line that connects the two tables. This is referred as the relationship type. It’s either identifying or non-identifying. Please see the section that discussed weak and strong relationships for more explanation. The only thing you need to understand for this section is the way the relationship is depicted in the ERD. Identifying relationships will have a solid line (PK contains the FK). The non-Identifying relationship does not contain the FK in the PK.

media/image15.png
Figure 9.5