Can some one let me know what can be the best ERD diagram for hotel management system, I mean how many tables should be there?
The number of tables will depend on the number of your entities and their relationship with each other.