Database design for a real estate office

[Erick Solms]

I have to do a database for a real estate company. I am having problems, if
someone can help me I will really appreciate it. My email is
(e-mail address removed)
So far I have decided to create 4 tables. One for properties, one for
clients, one for realtors and one for the rentals. On clients the PK will be
the client's social, on realtors the realtors social will be the PK, and on
properties I dont know what to do. Each property only has one Identification
Number, but each property can have two or more clients related to it. So I do
not know how to link the property and rental tables with the client and
realtors table. Please any solutions?

 

[Vincent Johns]

I agree with Duane Hookom's comments on not posting the same question
multiple times. I don't mind answering questions for people who appear
to need the information, but I'd rather not duplicate other people's
answers. It probably doesn't help you, either, to get extra answers
that you have to wade through. (I assume that you do plan to read the
answers you get!)

If you post a question (perhaps to multiple newsgroups, but listing them
all at the same time in the same message, so that it's obvious to
readers what you've done), and then get no response in a day or two, I
can understand that you might want to past it again, perhaps in slightly
altered form. But four minutes is not a reasonable time in which to
expect a response, at least on Usenet.

Anyway, I hope the answers you've gotten have helped you. But if people
get the impression you don't care about their time, some of them may
become less eager to respond.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.