Content Management System with database

[Krycek]

Hi,

At the moment, I'm doing a project which involves making our own CMS. My first priority is to make a Database where files (in my case foto's in the JPEG format) and info can be stored.
Now I'm quite stuck because I don't know what kind of tables I need to use in the database.
I allready have the following: a table to store the users (because u need to login first), a table for usergroups (each user belongs to at least one group), a table for albums, subalbums, a table where all the pictures are stored, and last but not least a table where all the EXIF info about the pictures are stored. The problem is that I need at least 10 tables, but I have really no idea what kind of tables I can add to the ones I have.
If someone could help me out, I'd really appreciate that. 

Thanks in advance,

Greetz

[teacher]

It sounds like this is a project for school. Which means you're on your own. If we tell you what to do, you don't learn anything.

If you need help you should ask your mentor. It sounds like a big project so you should have one.  Asking a mentor for help is good. Some students don't believe that, but asking for help shows the mentor that you are interested in learning. The mentor will also be able to observe your learning progress if you have contact with him/her.

I'm going to give you some pointers though.

You say you need at least 10 tables. This makes me think that this project is for a database-course. If you paid attention in class you know that a many-to-many relationship requires three tables, so for this to work

a table to store the users (because u need to login first), a table for usergroups (each user belongs to at least one group)

you need three tables.

My first priority is to make a Database where files (in my case foto's in the JPEG format) and info can be stored.

Your first priority should be to figure out what information needs to be stored in a database, then create the tables needed. You are approaching the problem kind of backwards.