I am designing a ERD on the Third Normal Form for a database and I have a problem.
I can't seem to do is join the People table with the Competitions table as for the Third normal form ERD I can't have any Many-To-Many relationships, only 1-to-Many or 1-To-1 and the task that I'm doing states that:
"Any person can enter more than one competition. A recording of which person enters which competition(s) should be kept in the database. The person is then given a number which indicates in which order the people compete in one particular competition."
So in that case: A person can be in MANY competitions and a competition can(has to) have MANY people - Many-To-Many.. Can't figure out how to get that into One-To-Many.
Oh and yes, I am a student and yes this is my coursework. I am not looking for people to do my work for me as I do want to learn, this is only a really small bit of the draft ERD that I have been stuck on for quite alot of time and can't seem to figure out.
I have attached this bit of my draft ERD in a word document any help would be great, thanks!