Hello!
I want to create database that would record the attendance.
Example:
I have project and this project has more programs. Person can join to one or more programs in one or more projects.
The intetion of database would be to see to which projects/programs this person joined..
I have 3 tables:
Person (PersonID, Person details...)
Program (ProgramID,PersonID, ProgramName, StartDate, EndDate)
Project (ProjectID, ProjectName)
Relationships:
Student -> (one-to-many) -> Program
Project -> (one-to-many) -> Program
I already tried to make this but everytime i want to add another student to same program (program starts with new id like this would be new program)
Any suggestion on this?Would anyone do this in different way?
Thanks
I want to create database that would record the attendance.
Example:
I have project and this project has more programs. Person can join to one or more programs in one or more projects.
The intetion of database would be to see to which projects/programs this person joined..
I have 3 tables:
Person (PersonID, Person details...)
Program (ProgramID,PersonID, ProgramName, StartDate, EndDate)
Project (ProjectID, ProjectName)
Relationships:
Student -> (one-to-many) -> Program
Project -> (one-to-many) -> Program
I already tried to make this but everytime i want to add another student to same program (program starts with new id like this would be new program)
Any suggestion on this?Would anyone do this in different way?
Thanks