Right? Here we are in our lab, we're going to walk through the solution, with respect to association, so the first place we had to start was in table initializer. Make sure we drop courses before students. So the first change you made was to have a primary key to be auto generated. Then we have our familiar name, date of birth and gender. So we have an identity auto increment primary key now on the student table. Then we ask you to come down here to the courses table. In our courses table, what we wanted you to do is to introduce student ID into the table. And making sure it's not null but declare it as a foreign key. Called student ID using the student ID column, referencing the table students and the column ID. Well, if we go back to our student table, we can see that our ID is now auto generated. So we can link up the two tables to that as a foreign key, primary key association. Now when we come down to loading the students, you'll notice since it's auto incremented, I don't have to put it in here ID, I can just inject the data, name, date of birth, gender. When we come down to the courses table, well at that point we now see we've added student ID here. And in our values, look 1,1, I could have done 1 and 2, but I'm doing 1, 1 because I want to show a student can have many courses. The rest is the same, which is execute the rows like so. When we came back into student DAO, what we wanted to do now was to go to our print students method and change the SQL. I'm only interested in picking up students who have courses now, and so I change the SQL to select all from students is my alias. And join to the table courses using an alias, where the primary key of student is equal to the foreign key student ID on courses. And then I print out name, date of birth, gender, title, code, and fee. And do an expression here as I consume the result set. So if I come back to my j unit now, this is where we left it, I don't think there's anything I have to do we should see a change in print students now up top here, let's find out. This is from the student table, and this is from the courses table. Why I've only got James?. Because James is the only student who had courses
