04 Try it yourself Interactive

Decide all 31 column sets, then break the keys you found

The same five students, in two runs. Find the keys works up by subset size and decides every one of the 31 non-empty column sets, naming the two rows that collide on each rejection. Break them declares the three keys that survived, adds the mentor foreign key, and pushes seven writes at them. Nothing plays on its own: Next, Back and Reset, or the arrow keys.

Find the keys
5 rows · nothing declared yet
Indigo = the columns this step is about. Rose = the values that make the step fail. Green = a key that survived. Amber = the existing row a rejected write collided with.
Press Next to begin. Each press advances the run by one step.


      

        
Sets decided–

        
Under test–

        
Candidate keys0

        
Rejected0

      


      

      

        
        
        
        step 0 / 0