Database Design - Request for Comment

I am building a searchable online photographic library and have produced an initial design for the database structure.                     

PHOTO ------ PHKW ------- KW
|
|

LOCATION-----LOCPLACE-----PLACES PHOTO: ID, description, locID
PHKW: phID, locID
KW: keyword, ID
LOCATION: fullLocation, ID
LOCPLACE: locID, plID
PLACES: placeName, ID

fullLocation consists of something like: Shinjuku, Tokyo, Japan placeName consists of indvidual place names eg Shinjuku; Tokyo; Japan; Europe

The database is to be constructed with Microsoft Access. Additional fields e.g. author and date may be added later.

I would be most grateful for any comment / suggestions for improvement.

abracad_at_hotmail.com Received on Sun Jul 08 2001 - 00:19:49 CEST