I probably should have said "compound key" instead of "composite key"...however, same issue...same point.
Creating an auto-increment field in all tables is simply not good design. It is easier, but the integrity of the data will be upheld with the use of composite keys when ever possible.
It make no sense to require the variable if the developer won't use it.