AnsweredAssumed Answered

join table vs star join

Question asked by layotte on Aug 22, 2013
Latest reply on Aug 26, 2013 by philmodjunk


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.