I would say, if you need RI, keep the tables in the same database. You can always distribute an empty table, for instance.
>Hi,
>I am developing stock inventory and membership system. Stock inventory system will keep track of stock, and also basic feature of membership system, such as keep member points and member sales report. OTH, membership will has all membership features that built in to inventory syste, PLUS management of redemption.
>
>Both system should be able to integrated or sell seperately.
>
>I question is, should I have inventory and membership tables in ONE database, or seperate it ?
>If seperate it, I cannot have benefit of RI.
>If join both, I may have problem when distribute both database sperately.
>
>Any comments?
>
>Thank you
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)