fields and tables for an estate agent...

R

Ringwraiths

Hi all

A complete newbie here

I?m making a database for an estate agent, would the following fields
in the tables be appropriate??? All the tables will be ?linked?
together.
What changes/additions can be made???

Tbladvert
advertID*
PropertyID
NewspaperName

Tblappointment
appointmentID*
buyerID
propertyID
time
details

tblbuyer
BuyerID*
PropertyID
SolicitorID
Date
Buyerfirstname
Buyerlastname
Buyeraddress
Buyerphone

Tblproperty
propertyID*
BuyerID
vendorID
AdvertisementID
Date
PropertyType
Bedrooms
Bathrooms
..
..
..
..etc?.

tblvendor
vendorID*
PropertyID
SolicitorID
Date
vendorBuyerfirstname
vendorBuyerlastname
vendorBuyeraddress
vendorBuyerphone

tblsolicitor
solicitorID*
vendorID
buyerID

please reply to me on [email protected]

thank you all for any input
 
Top