database organisation

Hi !

I have 5 major and 30 sub groups.
Each subgroup has cca 8 fields and each user can be in few
grups/subgroups/fields.
**********************************
e.g.
main table ( projects )
table: maingroup
table: subgroups
table: groupsList
***********************************
You can browse main,subgroups and fields.
e.g.
projects
web design
php
************************************
The problem is that the user can in multiple subgroups and fields (web
design, database design, php, ASP etc. ) and i have to organise all this.


So the question is how to make this and how to make the db optimization.

Re: database organisation

Hi Joja,

> So the question is how to make this and how to make the db optimization.

sounds like a basic student homework issue to me ;)

As the lack of data modelling knowhow is obvious in your post,
I suggest to learn two very usefull tasks first:

* Try to understand the basics of the ER model
(entity relationship model) and paint a map
of all 1:n and n:m relations for your data.

* Then, bring your data to (at least) the 3rd NF
(normalize data to the 3rd normal form).

After these important steps, the rest of your task will be
rather straight forward.

Good luck,
Frank

Re: database organisation

> sounds like a basic student homework issue to me ;)
:-)) well im new to mySql but this is what i have made and this is not
working for me

mainTable
*projectID (PK )
--------------------------
table groups
*groupID (PK)
*parentID (FK)
--------------------------
table mainGroups
*projectID (PK)
*groupID (PK)