I would like to know if it is possible for me to achieve something like this...
Yes this is all possible with FileMaker.
Whether it is possible for YOU to do it with FileMaker is not a question we can answer for you.
You can download the 30 day free trial and see what you can do with it. There are books and tutorials to help you get started. And we'll be glad to provide an assist to any specific questions you might have as you work on your database solution.
Bob, Im faced with a similar question as an artist, did you figure out the best solution?