join table vs star join
I am developing a database for a school. There are 3 main tables - students, activities and expectations. A student can have many activities and an activity can have many students. Each activity can have many expectations and expectations can belong to many activities. I started with 2 join tables student to activities and activities to expectations but then was not able to assign a level to each expectation for each student. Would a star join in this case be a better way to proceeed? Any help would be appreciated.