I would like to create a database to classify and control all the photos that I have stored in my computer.
It is clear that I need one table PHOTOS with attributes of ID, name, camera and date.
Second table would be DATA, including aperture, ISO, fstop, focal length, and so.
Then come the problem: I would like to be able to include tags, for example portrait, landscape, etc, but some are subclasses, for example in portrait>family>my kids.
How can I construct the table, simply a list of tags each with an ID? And how do I relate the photo ID to the tags, if there are , say 6 for a photo?
And same problem with the lat table LOCATION in the computer: my files are stored in folders by years and inside the year, dates. I don't know how to construct the table for this.
Can you offer any help? (I am VERY new to databases, but I will learn)
THANK you in advance!