title: Keep getting many-to-many relationships and I don't understand why
body: <p>I have three tables:</p>
  
  <ol>
  <li>Student - a table with student information including program, year entered, etc. Each student has a unique ID.</li>
  <li>Fellowship packages - each academic year has a selection of fellowships available, though some packages can occur in multiple years. Each package has amounts associated for each semester during the academic year.</li>
  <li>Awards - I want a table which has entries for: student, academic year of award, package, amounts associated with each package.</li>
  </ol>
  
  <p>I should say, I also will need a field in "Awards" that denotes the funding source for each semester in each award.</p>
  
  <p>The "Awards" table is linked to the "Student" table by the students ID#. It's linked to the "Package" by Academic Year. My problem is that I keep getting many-to-many relationships between "Awards" and "Packages", even if I create a separate table with just a list of the years and go through that.</p>