Last post Jul 22, 2011 06:26 AM by Endiss
Jul 21, 2011 04:23 PM|Endiss|LINK
hi got some school project and dont have a point how to make 1 table that will have all classes like bilogy etc, and 2nd will have student grups my question is easy how to make 2 tables and connect them to give 1 class multiply grups ? sory but im new in
Jul 21, 2011 05:24 PM|Shuvo Aymon|LINK
if one class will be tagged with multiple gourps then...
StudentGroup table will have columns groupID and group_name
StudentClass table will have columns classid, class_name and groupID
two talbes will be connected by groupID.
if one group can be connected with multiple class also then
StudentClass table will have columns classid, class_name
another link table will be needed to perform many to many relationship StudentGroupClass which will have columns groupid and userid. this table will connect previous two tables.
if you have any other confusion please let me know.
Jul 21, 2011 08:14 PM|Endiss|LINK
and if i wanna add grades table so it will be like for each student in student grup and each class? sory its so complicated at begining;/
Jul 22, 2011 02:39 AM|Shuvo Aymon|LINK
you will need some more tables i think.
grades --- GradeID, Grade_Code, Grade_Name
Students ---- Student_ID, Name, GroupID, add the columns you wanna store
now group and students are tagged. so students are tagged with classes.
Let me know how you want to tag grades with student. is it class wise?
is it something like studets - groupe - class - grades
or student - class -grade???
you may use
studentGrade --- studentid, classid, gradeid
is it ok?
Please enlighten me with your ideas so that i can try to help you out with appropriate suggestion.
You may have a look at database normalization to understand the connectivity between objects.
Waiting to help you out.
Jul 22, 2011 06:26 AM|Endiss|LINK
Ok its looks like this
any ideas ? i think it will workout so if ill have more problems ill write here;p