Generally speaking, the number of tables a database can create is limited only by available hard drive space.
The real question is how many tables can a database perform a join on efficiently, and that's something you won't likely find in a book, but by experimentation.