Here are some table suggestions.  Create a one-to-many relationship from the
primary keys to the foreign keys of the same name.

COMMIT_MEMBER
CommitMemberID – autonumber – primary key
CommitteeID – number – integer – foreign key
SenateID – number – integer – foreign key

COMMITTEE
CommitteeID – autonumber – primary key
Name - text

COMMITVOTE
COMITVoteID – autonumber – primary key
BillID – number – integer – foreign key
SenateID – number – integer – foreign key
CommitteeID – number – integer – foreign key
Vote – text – validation – “Yes”, “No”, “Abstained”
Method – text – validation – “Voice”, “Roll Call”, “Electronic”
VoteDate - DateTime

VOTING
VoteID – autonumber – primary key
BillID – number – integer – foreign key
SenateID – number – integer – foreign key
Vote – text – validation – “Yes”, “No”, “Abstained”
Method – text – validation – “Voice”, “Roll Call”, “Electronic”
VoteDate - DateTime

BILL
BillID – autonumber – primary key
BillNUM – text
Title text
SubTitle – text
FinalAction – text – validation – “Passed”, “Failed,” “Tabled”, “Referred to
committee”

SPONSORS
BillSentorSponsorID – autonumber – primary key
BillID – number – integer – foreign key
SenateID – number – integer – foreign key

SENATORS
SenateID – autonumber – primary key
Lname – text
Fname – text
MI – text
State – text
Party - text
Elected – DateTime
EndTerm – DateTime