Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   Entity relationship diagramming problem (http://www.go4expert.com/forums/entity-relationship-diagramming-t18813/)

Assi9 4Aug2009 21:21

Entity relationship diagramming problem
 
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 5Aug2009 02:03

Re: Entity relationship diagramming problem
 
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 5Aug2009 06:50

Re: Entity relationship diagramming problem
 
Thanks for the help, nimesh. Have a great day/night!

nimesh 5Aug2009 09:57

Re: Entity relationship diagramming problem
 
:welcome:


All times are GMT +5.5. The time now is 04:42.