I Am in fresher for Postgres...
I am newly developed one DB design ...

Actually My ERP have a four module (FINANCE,HR,INVETORY,PRODUCTION)

mY dOUPT IS ?

Each Module developed a seperate Schema,OR Single schema ...

Which one is better? How to build a strong Security Level ?
The data is very very Important One ?
I need a advantege and disadvantage of Both ?
How to develop a ER diagram in this module Any Ref...

I am eagerly waiting for ur Reply...

Thanks
Kumar