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.
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.
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.
aryans14
Member
4 Points
34 Posts
ASP NET database problem. . . .
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.
cornball76
Participant
1128 Points
211 Posts
Re: ASP NET database problem. . . .
Dec 20, 2012 05:24 PM|LINK
Homework?
aryans14
Member
4 Points
34 Posts
Re: ASP NET database problem. . . .
Dec 20, 2012 05:32 PM|LINK
I m a developer. Its not a homework.
Curt_C
All-Star
66017 Points
7639 Posts
Moderator
Re: ASP NET database problem. . . .
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?
v5.1 of iTracker (Inventory Tracker Starter Kit) is out, Download it now!
XIII
All-Star
182789 Points
23485 Posts
ASPInsiders
Moderator
MVP
Re: ASP NET database problem. . . .
Dec 20, 2012 05:58 PM|LINK
Hi,
Can you provide what you already tried to create so that we can take a look at it and try to fine grain it?
Grz, Kris.
Interested in Azure, ASP.NET (MVC), jQuery, WCF, EF, MS SQL, ...
Keep the forums clean: report to the moderation team!
aryans14
Member
4 Points
34 Posts
Re: ASP NET database problem. . . .
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.
aryans14
Member
4 Points
34 Posts
Re: ASP NET database problem. . . .
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.
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: ASP NET database problem. . . .
Dec 21, 2012 05:15 AM|LINK
Hi,
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.