Build the next
connection together.

I have one person connected to the same film in two roles. Should I create two Person records?

Keep one Person identity. In the illustrative model, two Credit records connect that person to the film, each with its own role. Count distinct people only when the question asks for people.

One order has two feedback records. A joined table repeats the order amount on both rows.

Select the matching order IDs first, then add each order amount once. In the runnable sample, four feedback records point to three orders and the total remains $99,500.

I want to follow the route without repeating the same character as a new type at every stop.

Keep Character as a type and reuse the character’s record. Each Encounter can link to several participants and to the chapter that describes it.

A complete passage can overwhelm the first reply, but a separate page makes it hard to inspect.

Show a short reference beside the relevant statement, then expand the source in the same reply. Keep the document identity and passage location visible.