PDA

View Full Version : DB design needed


moali72
Mar 20, 2007, 03:54 AM
Hi,
I have problem in design db of my system
Here what I have:

I have customers with many branches &
Each branch has many machines &
Each machine exists in many branches

Also : each machine has many components
Each component exists in many machines

Also each branch has many machines with it's components , and each component in this branch machine has it's serial Number

Now how I draw this as I am confused

Thanks ,waiting for your apprecaited reply

jstrike
May 31, 2007, 09:03 AM
hi,
i have problem in design db of my system
here what i have:

i have customers with many branches &
each branch has many machines &
each machine exists in many branches

Also : each machine has many components
each component exists in many machines

Also each branch has many machines with it's components , and each component in this branch machine has it's serial Number

now how i draw this as i am confused

thx ,waiting for your apprecaited reply

Just found this... do you still need help?

moali72
Jun 3, 2007, 09:36 PM
Just found this...do you still need help?

Yes. I need to know how to draw it as ERD and how to draw it as physical tables
Thanks