1Z0-006 practice question 10 of 10

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

Full set: 356 questions
Answer options
A: Subtype/Supertype
B: One-to-Many Correct answer
C: Many-to-Many
D: One-to-One
Correct Answer:
B. One-to-Many
Explanation

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.

Why Incorrect

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.

References

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.

Scroll to Top