0

Hello sir,
I am creating student attendance tracking system in asp.net.
With attendance i need to track students attendance every day and want to generate charts with those data.
Charts for Daily Attendance report, Weekly Report, and monthly Report.
For this how to design database in msaccess?

1
Contributor
1
Reply
7
Views
8 Years
Discussion Span
Last Post by bharanidharanit
0

Hello sir,
I am creating student attendance tracking system in asp.net.
With attendance i need to track students attendance every day and want to generate charts with those data.
Charts for Daily Attendance report, Weekly Report, and monthly Report.
For this how to design database in msaccess?

You could do this with three tables!

1. Student Table
2. Calendar Table
3. Attendance Table


Insert all student records in the student table.
Insert all working days and holidays in the calendar.
With the third table you have a choice.
You can choose to insert both present & absent students.
You could choose to insert only the absent students (assuming that everyone else who doesn't have a record was present for that day).

The structure of the table would be:
Studentid,
Date,
Status (Status "P" for present "a" for absent).

Student Table
StudentID
StudentName

Calender Table
Working Date
Holiday

Attendance Table
StudentID
CalendarID
Attendance

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.