Consider a table is a pilot's entities and one of them is "NewPilot" which is boolean. If Pilot is new then s/he did not fly any Flight(another table). Now I want to define the relation between Pilot and Flight, which is when Pilot.NewPilot=False has a one to many relationship with flight.