Welcome to the Java Forums!
Have you attempted writing the code yet? If so, please post it if you get stuck - and please use
code tags. You can start by reviewing both the
Database forums for some posts related to yours, and/or have a view at
this site's Tutorials where there are a few threads regarding databases.
MySQL is a good choice.. however, you say you're "almost new", and I'm not sure what you mean by that. For beginner Java programmers, this assignment you have to do requires the use of some more advanced concepts. But post your code and ask your specific questions, we're here to help.
See you around!