Mysql表的设计与实现[关闭]

Question

I have this table that i want to create in my database:

ID--Name--Major1--Univ1--Major2--Univ2--Major3-Univ3

The problem is, maybe the user did 9 majors. What i'm going to do create a table of 18 columns of major and univ... So is there a dynamic technique followed for this type of situations?

Answer 1

Make 3 tables

Primary tables

Universities
id | name

Majors
id | name

students
id | name

bridge_table

student_major
students_id|university_id|major_id