ORCA relationship requirements describe how a connection between objects works in a product. Sophia Prater uses MCSFD as a checklist for five decisions: mechanics, cardinality, sorting, filtering, and dependency. Teams use it to turn a relationship they discovered into rules they can design and test.
What does MCSFD cover?
Take one connection from a Nested Object Matrix. In this example, an agent opens Trip T-104 to find Booking B-52 and check whether the supplier has responded.
| Decision | Question | Example rule |
|---|---|---|
| Mechanics | How is the connection created or changed? | Adding a booking from a trip assigns that trip automatically. When adding one elsewhere, the agent selects a trip. |
| Cardinality | How many records can relate in each direction? | A trip can have zero or more bookings. Each booking belongs to exactly one trip. |
| Sorting | Which order helps people scan the related records? | Show the earliest service date first. Put bookings without a service date after dated bookings. |
| Filtering | Which subset helps with a task? | Agents can filter by Awaiting confirmation to find bookings the supplier has yet to confirm. |
| Dependency | What happens to related records when one changes or is removed? | Archiving a trip preserves its linked bookings. Agents with access can still review their history. |
These are product rules for the example. Confirm the equivalent rules with the people who do the work and the team that maintains the system.
How do these rules affect the design?
A trip with zero bookings needs a clear way for an authorized agent to add the first booking. If a status filter hides all bookings, the empty message can explain that no bookings match and offer to clear the filter. The agent can tell whether they need to create a booking or change the filter.
Apply the checklist in the direction that supports the task. On a Trip, sorting its bookings may matter. On a Booking, there is only one linked Trip, so sorting adds nothing to that view.
Review exceptions before finalizing the rule. Ask what an agent sees when opening a booking from search after its trip was archived. Confirm which records are still visible, which actions remain available, and where the agent can find the trip history.