I am designing a database to hold information about students and projects within a school.
A student may work on any number of projects, and multiple students may work on the same project.
Each project will have at least one student designated as the project leader.
Multiple co-leaders on the same project are allowed.
Similarly, each project will have at least one project sponsor (again, possibly more than one).
Finally, each project may have additional assigned students (with no specific role).
What tables would you propose for this system, and how would they relate to one another?