How to create New Database for job portal based on Industry
Posted by: Rajasekaran R
Date: December 07, 2008 01:53AM

Hi all

I have planned to create the job portal based on Industry like IT ,Pharma,banking,Airlines,Sales.

Option 1:

I have decided to create the seperate DB for each Industry but maintain the user account details in common DB

For example , Main DB is jobportal contains all useraccount details and common tables like country ,state ,city,designation in common Db

other 5 DB are IT ,Pharma,banking,Airlines,Sales .

Connect Main DB with all other DB..

option 2 :

Maintain all tables in Single DB only.But problem is job posting details different from industry to industry .so we cannot maintain common table for all industries..not only jobposting ..some other tables all same type of problem ..

option 3 :

Maintain Completly seperate DB for each Industries.. No relation between all DB..

Which one Best? Pls guide me regarding this..


Thanks
Rajasekaran

Options: ReplyQuote


Subject
Written By
Posted
How to create New Database for job portal based on Industry
December 07, 2008 01:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.