Table Naming: Underscore vs Camelcase? namespaces? Singular vs Plural?

I typically use PascalCase and the entities are singular:

DoctorMain
DoctorProfile
DoctorPatient

It mimics the naming conventions for classes in my application keeping everything pretty neat, clean, consistent, and easy to understand for everybody.

Being consistent is far more important than what particular scheme you use.