I am designing a database system to store salary information. It includes different tables (salary,personal info , ect)
I want to make it use for different companies. Also i want each set of data to be separated. (by company wise). (i.e. i dnt want all the employee names of every company in one table!!)
what would be the best database structure for that.??
i tried 1. one db for 1 company
That looks like invain.
please help me. I jst want an idea. thankx in advance