Understanding JOINs in MySQL and Other Relational Databases 理解JOIN在MySQL和其他数据库中的运用

This database is not efficient. It’s fine for this example, but a student can only be enrolled on zero or one course. A real system would need to overcome this restriction — probably using an intermediate ‘enrollment’ table which mapped any number of students to any number of courses.This d