I don't know of any technical limit which would prevent you from creating many tables.
Though following should be noted:
* each table will occupy space and the total DB space has a limit for the instance
* having more tables may impact DB performance
* having more tables also increases the time needed for publishing any data model as the API changes etc will take longer to be computed, deployed, etc