dbTalk Databases Forums  

many to many probelm

comp.databases comp.databases


Discuss many to many probelm in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
moali
 
Posts: n/a

Default many to many probelm - 03-26-2007 , 02:35 AM






hi,
i have problem in design db of my small system , so i describe all relation
to get the whole picture
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

The problem exist in :
each branch has many machines with it's components , and each component in
this branch machine has it's serial Number (this the most confusion part)

now how i draw this as ERD and Physical tables as i am confused ,

thx ,waiting for your appreciated reply


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.