design a single normalised table

[kkshansid]

S.N.
Name of NGOs
Boys
Girls
No. of Students
Passed
Failed
Employment Status
Grant Released
i have this type of data in table format for each Finical Year(2004-05 to2009-10) kindly help me to design a single normalised table
so that i can execute different query operations on it
as i am not getting any solution
any suggestions?????????

[jankhana]

You can have SNO , Name of NGO, Boys, Girls and NoofStudents in one table say
NGO_DET
and in another table you can have SNO(Ref parent NGO_DET), Student Name , Employment Status, Grant Released.

I don't know what is passed and failed I thing you can add that with the second table and instead of having No of students as a columns you can calculate it every time by using sum(Boys,Girls).

[kkshansid]

@jankhana
S.N.
Name of NGOs
totalBoys
totalGirls
total No. of Students
total Passed
total Failed
Employment Status
Grant Released

i have this type of data in table format for each Finical Year(2004-05 to2009-10) what about finantial year i have this type of data only no detailed data

kindly help me to design a single normalised table
so that i can execute different query operations on it
as i am not getting any solution
any suggestions?????????

[jankhana]

You mean that Grant Released is common for all students in NGO and same is the case for the Employment status?????????
If that is so than u can directly go for one table and include one more col as financial yr which will store for which financial yr the data is!!!!!!!!!!

I hope I understood right!!!!!

[kkshansid]

@jankhana

yes grant goes to ngos not students.do u mean i should design like this?

S.N.
Name of NGOs
totalBoys2004-05
totalGirls2004-05
total No. of Students2004-05
total Passed2004-05
total Failed2004-05
Employment Status2004-05
Grant Released2004-05
totalBoys2005-06
totalGirls2005-06
total No. of Students2005-06
total Passed2005-06
total Failed2005-06
Employment Status2005-06
Grant Released2005-06
.
.
.
so on
isnt there any limit of columns?

[jankhana]

No I mean you just include one more column called year which will have the year value i.e 2004-2005 or 2008-2009 etc so.
Table design will be like this:
Name of NGOs
totalBoys
totalGirls
total No. of Students
total Passed
total Failed
Employment Status
Grant Released
Year

So table is well maintained and has no problem in which year or which NGO and you can query it easily k....
Hope it's fine and helps you.

[kkshansid]

@jankhana
then ngos will be repeated again and again and there will not be any primary key

[jankhana]

what about students and all?????
can u give some demo of ur records so that its clear... Only name of the NGO will be repeated again and again total boys or girls and all those stuff will be different than right????????