You are reviewing a design for a database. A portion of this design is shown in the exhibit.
Note that you may choose to view either the Crow’s Foot Notation or Chen Notation version
of the design. (To view the Crow’s Foot Notation, click the Exhibit A button. To view the
Chen Notation, click the Exhibit B button.)
Which term is used to describe the relationship between Customer and Order?
A.
many-to-many
B.
multi-dimensional
C.
one-to-many
D.
one-to-one
E.
one-dimensional
Good Afternoon.
Just to clarify something in this answear. Isn’t the right answear “one-to-many”?
Or, if it is “one-to-one”, could someone explain why?
Thank you.
I would view this as a “one-to-many” as well.
Exhibit A is displaying the Crows Foot Notation. It shows the two entities don’t possess attributes, shows a mandatory line between each entity, and a many symbol at the Order entity. Though the diagram doesn’t include further symbols at either end (single line, double line, circle) it can still be inferred as a “one-to-many” relationship.
In exhibit B, though there aren’t further indications from each Entity (Customer, Order) the Chen notation is labelled as a 1:N relationship – (one-to-many).
Again, noting the Chen Notation, it’s an (entity-relationship-entity) diagram, it shows how a customer can place many orders, but an order can only be place by one customer.
C is the correct answer , one to many
C: One to Many
According to the diagram, “1” means one, both “N” or crowfeet means many