Which type of relationship is represented by a crow's foot notation in a physical data model?

In entity-relationship diagrams using crow's foot notation, the "crow's foot" symbol (a three-pronged fork) represents the "many" side of a relationship. A line connecting two entities with a single perpendicular tick on one end and a crow's foot on the other visually depicts a one-to-many relationship. This notation clearly indicates that one record in the first entity can be associated with multiple records in the second entity.

A. Subtype/Supertype relationships are typically represented with a circle and a line, indicating an "is-a" relationship, not a crow's foot.

C. A Many-to-Many relationship is represented by a crow's foot at both ends of the relationship line, not just one.

D. A One-to-One relationship is typically represented by a single perpendicular tick at both ends of the relationship line.

1. Oracle SQL Developer Data Modeler User's Guide

23c

"Relational and Physical Models". The diagrams throughout this guide illustrate the use of crow's foot notation for one-to-many and many-to-many relationships.

2. Stanford University

CS 145: Introduction to Databases

"Lecture 3: The Relational Model and ER to Relational Mapping". The lecture notes cover ER diagram notations

including crow's foot for representing "many" cardinality.