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 (e-mail address removed)

thank you all for any input
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top