ansaurus

Question

Answer 1

A:

id | name | grade | aggregate

This would do the trick, id is your primary key, name is students first last name, grade is what grade he is in and aggregate is aggregate % based on the grade.

Fro example some rows might be:
10 | Bill Cosby | 10 | 90
11 | Jerry Seinfeld | 4 | 60

Bill Cosby would have aggregate percent of 90 in grades 1-9, and jerry would have 60 in grades 1-3. In this case it is one table and boils down to you managing the rule of aggregation for this table, since it has to be one table.

Chris 2010-07-26 10:38:47

Thanks for your prompt response. But the thing is we don't need the aggregate of all the years, but for every year. Like -> The roll no of student, his 1st standard aggregate, 2nd standard aggregate, 3rd standard aggregate .......... so on. So when a student is selected we will be able to see his total academic progress. I told them two answers1. creating 10 columns for every standard. This was put as wrong because of unnecessary columns. 2. creating 10 rows for every standard. Again this is wrong coz the roll no will not be primary key.I think u got the point

2010-07-26 10:47:38

Thanks for your prompt response. But the thing is we don't need the aggregate of all the years, but for every year. Like -> The roll no of student, his 1st standard aggregate, 2nd standard aggregate, 3rd standard aggregate .......... so on. So when a student is selected we will be able to see his total academic progress. I told them two answers 1. creating 10 columns for every standard. This was put as wrong because of unnecessary columns. 2. creating 10 rows for every standard. Again this is wrong coz the roll no will not be primary key. I think u got the point

2010-07-26 11:06:07

Answer 2

A:

Dear user402128, I was wondering if you already have a solution for your problem. Another problem arrises if you ask that for one student you cannot tell his year started with 1; can it? What if the student started at year 2 and is in year 5, your aggregate would be from 2 till 4, wouldn't it? So you need a first year. like yearstart? what if the student was out for one year, so you would have a gap of x-years. So the aggregate could be 2 till 5 -x. So you would have a something like: yearsnotspend or free; the currentYear would be the year the student now is attending.

student | currentYear | startYear | yearGap

You can now calculate the aggregate ...

Hope it helps or if I am wrong, please provide me the correct way :-)

DannyS 2010-07-26 12:22:12

ansaurus

tags:

views:

answers:

Table structure of a student

related questions