Im a first year student new to the forums and Database design in general.
I have an assignment that requires me to design and build a database for a dragon boating org.
I have supplied the pdf for what I am working on so you can understand what it is I need to do. Not looking for the answers to be given to me mainly mentoring and pointers in the right direction.
Also provided is a SS of my current ERD (in progress) using lucid chart.
I am stuck at transferring the data regarding the REGATTAS and the RACES/HEATS...... Not Really sure how to go about displaying the heats....