We need a suggestion on creating Oracle database for below scenario.
Suppose It is required to implement multiple B2C insurance products(for e.g., motor insurance, health and travel insurance etc..) where end user can get the quote and buy an insurance online through web application. There are some master data which can be same for all different products and need to be shared across products.
How should we design the database in Oracle 12c for this scenario? Should we create single database(single SID) containing all products data or should we create multiple database on same server(multiple SID) where one database represent one product? What can be the pros and cons of both the design?