Hi all, Andy here and a newbie to this *great* site and first post so here it goes...
Pretty new to PHP, been coding for about half a year now and loving it. To help get a better skill set and knowledge of the language I've decided to build a small marking system where teachers in my fantasy world could go around the class marking work by logging in on their tablet, picking the group and respective student they are sitting with and go ahead to submit a grade. It's purely a way of learning and a fun project to work on.
I'd like to sort of track my progress in here and it also allows me to ask for help, which will definitely be needed, and show others how with a bit of hard work you can achieve something.
Basically I want a system where the teacher logs in, is able to create a group, add a student to the database and also tie it in with a group, so the two are linked.
I'd like some feedback on the idea and how I'm doing my database (it's not my strongest area and I'm not sure how right it is)
user: id, name, username, password, date, admin
group: id, modulecode, groupname
user_grade_for_group: id, user_id (FK to user.id), group_id (FK to group.id)
The user table is to combine teachers and students. If it's a teacher the admin is set to 1 and they are able to add groups, students etc. if it's 0 they are a student.
The group table is for all the groups available which is why there's the module code and group name.
User_grade_for_group is where they are tied in, so after all the groups are created, while adding a student you can include one of the groups to "attach" them to.
However in my head I'm not sure if this works? I think I'm missing a link maybe in the user table or group table?
As I say, feedback appreciated. Go easy on me ;)