In this image it shows on how to relate its field using there control field instead we put there description of the Course and Gender since we are doing normalization then we will use the control of each element or data in the table.
In this image it shows all the data under Male and Female student inside tblStudentInfo.
In this image it shows all the data with there corresponding course under tblCourse. Data inside tblStudentInfo.
You can download my example below.
Download File