DB relationships

Hello,

I'm building a db for an estate agents. It has five tables. If you imagine a
circle, with table buy_sell at it's centre, and four other tables named:
1/ client [containing all client data - sellers]
2/ buyer [containing all buyers information = mirror image of client]
3/ property [containing all the property for sale data]
4/ enquiries [bring together buyers and property they have enquired about]
around it's circumference.

The relationships as I see them are: seller to properties = one seller can
have many properties thus many:1?

buyer to enquires = many buyers can enquire about one property thus many:1?

property to enquires = only one property should enter here with buyers
enquiries, thus 1:1?

property to buy_sell = one property to one buyer to one seller thus 1:1?

seller to buy_sell = one seller to one property here thus 1:1?

buyer to buy_sell = only one buyer here to one property thus 1:1?

Not sure if I should ask this question here, but if someone could look and
either confirm or [not] as the case maybe, if this is correct. I've just
checked and have actually made all relationships 1:1 and think this maybe
incorrect....

Thank You




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org