primary key: student_id
name
email

primary key: course_id
name

primary key: registration_id
start_date
foreign key: student_id
foreign key: course_id

student name | course name
john         | computer science
alex         | architecture
daisy        | engineering

SELECT s.name, c.name
FROM students s
JOIN registration r ON r.student_id = s.student_id
JOIN courses c ON c.course_id = r.course_id