title: Represent a relationship
body: <p>I've currently come to a complete halt in thinking.</p>
  
  <p>I have a table called Account, which has attributes accountID(PK), firstName,lastName etc... and I have made a table called Class which has attributes classID(PK), className, classTime etc... Many to many relationship exists between the 2 tables.</p>
  
  <p>I need to break the many to many relationship. The conditions are: after an account is made, it may be enrolled to a class as either student or instructor but not both. However, an account could have an instructor role in one class, and a student role in another class</p>
  
  <p>So I thought of making a table called Enrollment, and having accountID, classID and enrollment type, but what I'm uncertain on is the relationships needed btwn Account and Enrollment and Enrollment and Class. Would it be one account to many enrollment?</p>
  
  <p>If anyone would be kind enough to help me understand this I would be very grateful.</p>