Entity relationship diagramming problem

Assi9's Avatar, Join Date: Aug 2009
Go4Expert Member
Hi friends. Sorry to bother you with this very, noob-level question, but I am having a hard time determining the answer to it.

I have to represent the Student Attendance entity which is, as its name suggest, intended to hold information about the attendances of Student. How would I proceed to create a relationship between the Student entity and the Student relationship entity in the database design? Is there a one-to-one relationship between them? Or is there a one-to-many relationship between Attendance and Student? Any help would be welcome.
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
Student - Attendance
====================
Student ID [1] - [m] Student ID

Student : Attendance would be 1-to-many kind of relationship because
1] Student Table will only contain 1 record per student (for 1 standard/year)
2] Attendance table would contain multiple records (1 for each day) for each student
Assi9 like this
Assi9's Avatar, Join Date: Aug 2009
Go4Expert Member
Thanks for the help, nimesh. Have a great day/night!
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor