Hi there, I'm trying to really understand one to many versus many to many, because it's really messing up my database designs I'm pretty sure. To take a common example, courses and instructors. To me, this could BOTH be, one to many and many to many. A course could be taught many instructors (this semester Mr. Jones teaches Sociology 101 and next semester Mr. Smith teaches Sociology 101), making the relationship many to many. But what about two teachers teaching the same course, as in a Professor and a student aide teach the course? Or would the first scenario I mentioned ONLY be one to many, because only one teacher a time is teaching the course, and it doesn't matter that next semester a new teacher could be teaching the course? Thanks