"nj" <njvds.o11@gmail.com> wrote in message
news:1164265796.121055.39830@m7g2000cwm.googlegroups.com...
>
> Hi,
>
> Please suggest me efficient database design for below mentioned
> business logic .
>
> Business Logic:-
>
> "ShareBuilder customer login as an "investor". An investor has a
> username, a password, and a first and last name. An investor can have
> many accounts. Each account has an account number, a legal name, a
> legal address (with city/st/zip), and a "legal" email address for
> correspondence. Most accounts are specific to a single investor.
> However, joint accounts have a primary and a
> secondary investor-that is, either the primary or the secondary
> investor can log
> in to the site and view the joint account.
>
> Please prepare a schema to support this situation. Please write basic
> stored procedures to allow the website to insert/update customer and
> account information; these procedures should do their work in a
> transaction; if the procedure is called within an active transaction,
> the procedure should issue a savepoint. Please enforce basic data
> validation rules with check
> constraints. Please also find a way to
> enforce the rule that an account should never be associated with more
> than two investors. "
>
> Thanks,
> NJ
>