MODEL 01:

name email A B C D

aa john@test.com 0 0 1 1

bb rick@test.com 0 1 0 1

cc sally@test.com 0 1 1 0

dd aha@test.com 1 1 0 0

What would make better sense is to take the four columns: A,B,C,D and move them into a separate table:

MODEL 01A

NameID Name EMail

1 aa john@test.com

2 bb rick@test.com

3 cc sally@test.com

4 dd aha@test.com

NameID Mode

1 C

1 D

2 B

2 D

3 B

3 C

4 A

4 B

This allows adding new modes by adding a row and deleting a mode by deleting a row.