I would approciate a few extra eyes to look over my DB structure, and give me your thoughts...My DB has grown to need extra tables. I think my Primary Key...which is made up of 7 fields is correct, BUt sure seems like a lot...cause I need to add more tables.

Look at my attachments.

here is a first pass user interface of the stats table data:

SHunt Stats

my 'stats' and 'quotas' tables Primary Key is a composite key...made if 7 fields.

I need to add several additional tables that will all use the same Primary Key...those 7 fields.

Is my Database design sound..."normailized"?

Would/How would you address the really LONG primary key in each of these tables?