I don't see any relationships. :(

In order to normalize your database to the third normal form (3NF), ranks should go into a separate table. And no, this isn't overkill and it will eliminate data duplication for your ranks. Not to mention that having a lookup table is very useful.

Take a look at the following link and look how the PaymentType3NF table is and how it is linked to the OrderPayment3NF table.

http://www.agiledata.org/images/dm101Order3NF.gif