Agree with previous poster in that "Yes, this is a very good match for a RDBMS".
in reply to OT: SQL and me
As you are just getting started with the DB stuff, I would start with SQLite which has some real advantages for this kind of a project:
- DB is a single file
- Has a good DBD module with reasonable documentation
- It provides all the functionality you are asking for without having to get into a lot of DB admin like you might with heavier DB's like mysql, postgreql etc....The online docs are not bad
I would do is look for existing DB implementations (google search) as the album app is commonly used as an example for simple DB development.
And finally, I would delve into basic DB design by checking out some books like This one.
Hope that is helpful and encouraging...
- ...the majority is always wrong, and always the last to know about it...
- ..by my will, and by will alone.. I set my mind in motion