Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: vehicle to autoparts relationships

Re: vehicle to autoparts relationships

From: Neo <neo55592_at_hotmail.com>
Date: 22 Nov 2006 14:26:24 -0800
Message-ID: <1164234383.970689.275900@m73g2000cwd.googlegroups.com>


> > >www.kel-tec.com/su16aparts.html
> >compare it with alternative
>
> Well, I promise nothing, but it was easy to get the rifle parts into a
> table, and set up the relationship table, and I need the exercise.

In keeping with the OP problems, there should be parts which are made of part recursively (like a Bill of Material). Is your data structure similar to schema A or B?

Schema A:
Gun
  part1
  part2
  part3
  ...
  partN

Schema B:
Gun
  part1

     part23
     part26
  part2
     part37
     part58
         part99
     part33
  part3
     part67

  ...
  partN

If it is similar to B, how did you determine it as the diagram is vague in some cases. For example, do the group of parts located in the left middle (240, 285, 236, 263, 205) consistute a sub part/assembly? Received on Wed Nov 22 2006 - 16:26:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US