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

Quote:

---

Originally Posted by moali72

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?

Quote:

---

Originally Posted by jstrike

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