table name can be case-sensitive, but you can force it is not case-sensitive by configure my.cnf add a line lower_case_table_names=1
So if you set this, the uppercase table name will not work.
I don't think it is necessary, the default is case-sensitive. The first letter of table name is uppercase is good, this can be corresponding to object name in application, e.g., Java, php, that often use uppercase for class name.