Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 21, 2012 05:15 AM by Decker Dong - MSFT
Dec 20, 2012 05:21 PM|LINK
I am working on a project student attendance management system.
EverY student's attendance is being submitted through grid view and grid view is passing student id, name, class, semester, date and status as P, A, or L. P mean present, A mean absent and L mean leave. Institution is following semester system and two exams,
mid and final are conducted in each semester.
I have to take attendance percentage of complete class for mid and final exam of each semester. Mean subject A has 5 classes conducted, subject B has 7 classes conducted, subject C has 6 classes conducted etc. So in how many classes student was present in all
till the mid and final exam and what is his attendance percentage. That is my objective.
Can any database expert help me please. I will be greately thankful to you.
Dec 20, 2012 05:24 PM|LINK
Dec 20, 2012 05:32 PM|LINK
I m a developer. Its not a homework.
Dec 20, 2012 05:52 PM|LINK
I'm not sure what it is exactly you are asking for here. What is your specific question?
Dec 20, 2012 05:58 PM|LINK
Can any database expert help me please.
Can you provide what you already tried to create so that we can take a look at it and try to fine grain it?
Dec 20, 2012 06:08 PM|LINK
This is what i have inserted into database.
and this is what i want.
i want to have comprehensive result.
Look if a student is present, he is marked P in the databse with that specific subject and specific date and specific semester. If he have attended 5 classes of a subject, and 4 of other, and 8 of other and i want to have it all sum and divide it by total
classes conducted and show percentage of classes attended in a saparate column.
Dec 20, 2012 06:11 PM|LINK
Every student who attends class is marked with P and that P mean 1 incerement in that specific class, subject date.
Dec 21, 2012 05:15 AM|LINK
Maybe you should use inner join to link the two tables together and then group by Status and StudentId, thus you can see every student's state count and name.