How would the RI be affected between the two systems when you sell them separately? You have to allow for them to be sold as a package or sold separately, correct? More like two separate modules of the same system maybe? Off the cuff, I would go with two different databases, but that would be my choice. To be sure, I would need to know more on the interaction between the two systems at the table level.

>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