How could I model this relationship?

From: Stu <smcgouga_at__at_yaho.com_>
Date: Tue, 25 Jun 2002 13:18:00 +0100
Message-ID: <1025007470.16304.1.nnrp-10.c2de0ffb_at_news.demon.co.uk>

Hi,

I have a relationship: many companies have many customers. but a customer is also a company! So how would I model this in a relational db?

Could I just have the company with a relationship going straight back into company (EER)? If so How do you transfer this to tables?

cheers
stu Received on Tue Jun 25 2002 - 14:18:00 CEST

This message: [ Message body ]
Next message: Pavel Filatov: "Re: How could I model this relationship?"
Previous message: Jan.Hidders: "Re: The Theoretical Foundations of the Relational Model"
Next in thread: Pavel Filatov: "Re: How could I model this relationship?"
Reply: Pavel Filatov: "Re: How could I model this relationship?"
Reply: Stu: "Re: How could I model this relationship?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message