There are databases that are designed for photo management. iPhoto for one.
Filemaker can do all you ask, but reinventing the wheel, without a unique requirement, may not be necessary.
It all depends on what needs to be stored and how it needs to be accessed. Bento may be a better fit.
I am unsure about the RAW (CR2?) requirement.
Thanks for the reply. The main reason I'm not going with iPhoto or Bento is that I need to have the auto-fill functionality that only comes with FileMaker (as far as I know anyway). e.g. each aircraft has an individual registration, and each airport an individual identifier code. I want to be able to enter the registration and the airport code, and have FileMaker automatically fill in the other details of the aircraft (i.e. Make, Model, Airline etc) and the airport (i.e. Country, City, Airport Name etc).
Just for clarification, CR2 is Canon's version of the RAW format - Nikkon has a separate file extension, not sure what that is. If RAW support isn't possible, is it instead possible to reference a jpeg thumbnail of the raw image, which opens the RAW file in Photoshop when clicked?
Both Bento and Filemaker can do the autofill given a database that contains the related information.
I understand camera raw, I just doubt that any database (other than a photo database) can display CR2 or NEFF information.
JPEGs sure. Opening a related CR2 with the same filename, yes.