An interesting Question on DBDesign

I'm so sorry but I am not be able to see the aforementioned attachments
"lara169" wrote:

> Hi,
> Pls see the attachments.
> This Question was asked in one of the top indian universities(I've copied
it
> exactly the same way as it was on the Question paper). I got this from one
> of my friends.
> Can any one help me in designing the database in SQL server 2000 and findi
ng
> the payout for each ids?(the second part)
> Regads Lara................
>
>
>
>This was the exact Question...
Based on this Can u suggest the best way of DB design.. I think its just a
binary tree implementation
regards Lara
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:9980E6CD-CEFC-4A72-8E97-CC911E396C51@.microsoft.com...
> I'm so sorry but I am not be able to see the aforementioned attachments
> "lara169" wrote:
>
copied it
one
finding|||lara169 skrev:

> This was the exact Question...
> Based on this Can u suggest the best way of DB design.. I think its just a
> binary tree implementation
>
> regards Lara
>
No we cannot suggest much, as you seem to have some attachments
somewhere that are not visible in your posts (using for example Google
or an ordinary news reader - correct me if I'm wrong).
Either post a(n) URL for that/those attachment(s), or explain better in
a posting (text only).
/impslayer, aka Birger Johansson|||It is very hard to debug code when you do not let us see it. No
attachments, no URLs, real code please.
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. Sample data is also a good idea, along with clear
specifications.
If this is a tree problem, you can also get a copy of TREES &
HIERARCHIES IN SQL. Binary trees are pretty easy to model.