table design

[Dreamstar_1961]

trying to work out how to do this, designing a database, what I have is a
database, were you have a customer, and you have a design number, plus a
design link, the problem is that this design number might have other design
numbers attached to it, as well as links, there is also a chance there is
update numbers and links as well, I think I need a table that will have these
numbers and another with the update numbers and links in it and link them to
the customers, I could do it in one table but there is no idea how many may
be attached to the customer, any ideas on how to work it, example below

OrderNo - Customer - DesignTitle - DesignNo - DesignLink - DesignNo -
DesignLink -UpdateNo - UpdateLink - UpdateNo - UpdateLink - UpdateNo -
UpdateLink

The links are to cad files on the server,
I think I need something like this but not sure how to do it-
(Table 1) OrderNo - Customer - DesignTitle
(Table 2) OrderNo - DesignNo - DesignLink
(Table 3) OrderNo - UpdateNo - UpdateLink
Any Ideas on how this would work

 

[Designing-Systems.com]

hi,
You have three entities and would go in three different tables. You will
then create relations and links between the tables.

Table 1: Customer Table: Pimary key is the customer ID. hold all customers
here

Table 2: Design numbers. this table only holds design numbers and primary
key can be a design number any other attribute that uniquely ientifies the
design. This table also has a design link column for each design.

Table 3: Update links. This table has two attributes. the design number and
its update number and update link.

Next you will create the junction table to link customers and their orders.
Say this is called the Orders table. It will hold the custmer ID and design
number ID.

Regards,

 

[NetworkTrade]

in addition to the advice already given....keep in mind your statement:
"this design number might have other design numbers attached to it......also
a chance there is
update numbers"

In the database world that is a very very messy statement. I understand
real life and this may be inflicted upon you. Probably it is obvious to you
that one is going to need a strict cross reference method between Customer
ID, Primary Design Number, "other Design Numbers" , Update Numbers.....
this is your key issue to resolve conceptually upfront....