Design a database for recording information about the activities (specifically votes) taken in the US House of Representatives, including:

Some common problems:

Total participation should be reserved for cases where an instance of the relationship must exist in the database. For example, there must be an IN for every district in the database. (This is reasonable because a district name is not meaningful - and is not unique - without the state the district is in.) In other cases, an instance of the relationship may always exist - for example, every representative serves in at least one Congress - but requiring total participation means that it would not be possible to have a representative in the database without also recording at least one Congress the representative is in.