Question:

I'm trying to create a database with members of congress. The uid for a rep is [ST][CD] such as MI05 for Michigan CD 5, etc.

However, when I get to senators, there is a Junior and Senior senator. In a way, the uid is kind of the state + Junior or Senior.

Would you put the 435 members of the house in the same table as the 50 senators? Or two separate tables.